Copy Excel Data To Email (Excel 2004 for Mac)

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

Nevermind, I found exactly what I needed right here!

It won't work with Apple Mail as far as merging it to your email, but you can merge it into a document that you can easily copy/paste into mail or if you have Entourage, you can use mail merge with that.

Hopefully that might help anyone else with a similar problem.