[Tonygets]

Hi,

I am trying to create an automation that copies and pastes the product data contained in excel from my website into an HTML email template. The automation will match text data from a cell in excel to text data in an HTML template. The automation will then copy a specific cell from the active excel row over the matching text variable in the html template.

I have attached the sample excel file and the html template file.

Step 1) match text data in Column A starting at row 2 of excel session to text data in HTML template file and if there is a perfect match then past text data from Column B of the active row over the matching text data in the HTML file.

Step 2) for the same active row, match text data in Column C of excel session to text data in HTML template and if there is a perfect match then past text data from Column D of excel over the matching data in the HTML file.

Step 3) for the same active row, match text data in Column E of excel session to text data in HTML file and if there is a perfect match then past text data from Column F of excel over the matching data in the HTML file.

Step 4) for the same active row, match text data in Column G of excel session to text data in HTML file and if there is a perfect match then past text data from Column H of excel over the matching data in the HTML file.

Step 5) for active row, match text data in Column I of excel session to text data in HTML file and if there is a perfect match then past text data from Column J of excel over the matching data in the HTML file.

Step 6) Loop through all rows until there is a blank row in the excel document.

Additional Conditions: If there is any blank data in an active excel row/column or in the HTML file (i.e. no match) write the data ‘no match’ in Column K for the active row in the excel session and continue to the next column or the next row (it does not matter if there are 1 or more failed matches within the row, we just need to write ‘no match’ once in Column K and we will investigate the entire row).

Thanks and regards.