How ca I mass email from Outlook 2003 using an Excel database

A client of mine owns a hotel and has an excel database (Office 2003) containing the details of several thousand clients.

He wants to email a standard invitation email using Outlook to each one.

What is the best way to achive this?

Secondly, the database also contains Fax numbers for many clients - he wants to fax all these contacts as well.

Any recommended software for this?
Who is Participating?
DaveConnect With a Mentor Commented:
For part 1) see Ron de Bruin's code to mail a message to all email addresses in a range,



chrisfixitAuthor Commented:
Thanks, but where/how do I create, run, this Macro?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.