personalize mailing

[jjatcal]

I checked Outlook 2000 help and it describes how to do mail merge from Outlook contacts to Word. It does not describe how to mail from Excel to Outlook.

I have email addresses in an Excel file. There are about 200 rows each containing a column for email address, a first name and a last name.

I want to have one email go to each person, not a mass email to all 200 where a) ONLY their email id is shown in the "To" field and b) their name is in the text.

So row 1 from Excel would go to michaeljordan@hotmail.com and the text would start by saying "Hello Michael".

Row 2 would go to magicjohnson@hotmail.com and text would start with "Hello Magic".

How do I do this?

 

[Marcs41]

Open Excel and look for mailmerge in Help.
Using Word may be more what you need for your purpose, so check there too.

Marc
_{If 'something' 'somewhere' gives 'some' error, expect random guesses or no replies at all. Please specify details.
Free Tip: The F1 Key does NOT destroy your PC!}

 

[jjatcal]

The Excel doesn't help much.

But the Word helped a great deal. I was able to mail merge from Word and then selected send to email (instead of to a new document or to printer). I was able to put in a subject and mail it out. It sent the email to each record!!

Thanks!!!

 

[Marcs41]

You're welcome

 

[jjatcal]

I've been doing this without attachments but now I need to send attachments also.

How may I do this?

 

[jjatcal]

Oh and I forgot to ask...

I have Outlook 2000 and Express 6 installed. I want to use Express 6 to send out my mail merges. However, when I go through Word to run the merge, it automatically uses Outlook.

I tried setting the default mail client to Express 6 thinking that may cause it to use Express instead of Outlook.

But that didn't work.

THoughts???

Thanks!