Email merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralph Smith - 01 Jul 2005 17:47 GMT

I have approx 200 email addresses. I need to send a form letter to
each address, but within the form letter I need to have a unique
username and passord for each recipient. Is there a way to do an
email merge with Outlook 2000? How can I find out about this? If
this is not the correct newsgroup please direct me to the right one.

Thanks.

Reply to this Message

Russ Valentine [MVP-Outlook] - 01 Jul 2005 18:33 GMT

Outlook uses Word for performing mail merge functions such as Form Letters,
mailing labels, envelopes, and fax or email merges. For an overview of these
functions take a look here:
http://www.slipstick.com/contacts/printlabel.htm
http://www.outlook-tips.net/howto/mailmerge.htm
http://office.microsoft.com/en-us/assistance/HA011186361033.aspx

Signature

Russ Valentine
[MVP-Outlook]

>I have approx 200 email addresses. I need to send a form letter to
> each address, but within the form letter I need to have a unique
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Sue Mosher [MVP-Outlook] - 01 Jul 2005 22:28 GMT

Where are the username and password supposed to come from?

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have approx 200 email addresses. I need to send a form letter to
> each address, but within the form letter I need to have a unique
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Ralph Smith - 07 Jul 2005 21:21 GMT

I have everything in an Excel file:

FirstName
LastName
Email
Username:
Password:

>Where are the username and password supposed to come from?

Reply to this Message

Sue Mosher [MVP-Outlook] - 07 Jul 2005 21:28 GMT

And your issue is? (It really helps if you keep all the germane information together in the current post.)

Is the Excel file set up so that each record is in its own row? DId you create a named range covering the data to be merged?

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have everything in an Excel file:
>
[quoted text clipped - 5 lines]
>
>>Where are the username and password supposed to come from?

Reply to this Message