I have an excel spreadsheet that has data that includes a name, email, and company name. For each row, I need to send an email to the email address in column L, that starts out "Hello _____," with the blank being the data from column K, and then within that email is a section where I need the company's name from column E.
The letter is written and formatted perfectly in a word document and this formatting needs to somehow be maintained.
Is it possible to create a macro (or something else entirely) that automatically moves the data from the excel sheet to the word doc and then to an email in Apple Mail v 2.1.3 while still keeping it formatted as it is in the word doc? Keep in mind I am using Word and Excel 2004 for Mac.
Any input or links to tutorials would be greatly appreciated.
Thanks in advance!
-Amy Kate
Bookmarks