excel to outlook

[Guest]

Good afternoon,

Is it unheard of to use a spreadsheet to, in a way, merge to an email.

meaning, if I have a generic bodied letter, and a spreadsheet the lists
email address, can I send this data to outlook and send an email per row in
my spreadsheet?

Any direction will help

thanks
aaron

 

[Guest]

It'd probably take some work in Excel, where Word has functionality to handle
this rather quickly & easily. Crank up Word, display the Mailmerge toolbar,
set up your form document, and merge in the data from the Excel file. You'll
then have the option (one of the buttons on the toolbar) to Mailmerge to email

 

[Jason Morin]

I would start with the basics. Ron de Bruin has some
basic code for manipulating Outlook via Excel:

http://www.rondebruin.nl/sendmail.htm

HTH
Jason
Atlanta, GA