Email through Outlook using an Excel list.

[barlet]

I have a list of birthdays. It contains all the necessary data including of course, the birth date, name and email address. I would like to send an attachment (birthday card), automatically, to the person who will have the birthday. Has anyone got any idea how to go about getting this job done?

[gmr4evr1]

Take a look at this site..
http://www.rondebruin.nl/win/section1.htm

[barlet]

Thanks as your answer did solve part of my problem. The other part of the problem is that every ecard I want to send must be sent the day before the birthday occurs. Say if the birthday falls on 1st August, the ecard would automatically be emailed on 31st July or at least at the beginning of the month.
I have in mind that to set excel starts and runs with Windows, so that part of the automation can be easily be taken care of. Any ideas?

[gmr4evr1]

Ok I have been searching and searching for a solution and I hate to follow up with more links but these might help you out more...

http://www.mrexcel.com/forum/excel-q...l-outlook.html

http://www.mrexcel.com/forum/excel-q...lications.html

[barlet]

Thanks once again. I think I got it but now I have ended with three files. I shall put them to work together and post the reply over here later on this month. Thanks all your help.

[gmr4evr1]

No problem. If you need help getting them together, let us know.