I need some help creating a data-oriented email template design and having that template be populated with data that is managed in an excel document.
The logic of the excel -> email template data population should include the following:
1) each row in excel document represents data for a distinct email. Code should loop through all rows in excel and be able to generate a separate email for each row.
2) the email template should contain 2-3 horizontally stacked sections. the template should allow me to cut and paste/re-order those 2-3 horizontal sections manually.
3) if data is missing for a specific excel row for for a specific set of columns (which represent sections of the email) then the email template generated should hide that section with no data
4) this should work across both windows & mac versions of excel