Best way to handle this solution

[thutmose]

Hello guys I have been given the task to create some type of automated way to do the following. Presently a document exist that is a microsoft excel 2007 document. This document contains the data in cells and rows. What I am trying to accomplish is to create a template in Microsoft outlook 2007 that as a variable pull the data one row or cell at a time and into each template and create an email. EX:



Dear $variable1


We really appreciate your business...etc...etcc




thanks $variable$

Do you guys have any ideas. I am not a developer but trying to figure out should this be a VBSCRIPT, a form? Any help would be appreciated, thanks.

 

[JPaules]

Have you tried doing a mail merge with the info?

--
JP