Outlook Mail Merge

[Guest]

From other posts I am not clear on the steps to accomplish the following
action with Outlook 2003:

I have an Excel spreadsheet that has 4 columns (Email_ address, LastName,
FirstName, PassCode), and there are 250 rows of data.

I want to use Outlook 2003 to send an Email to each Email_address in the
Excel spreadsheet. Each Email needs to include some standard text (same for
all e-mails) plus the individualized FirstName and PassCode for each
recipient.

Anyone know the high level steps to accomplish this?

 

[Roady [MVP]]

Start Word, create your template and then choose Tools-> Letters and
Mailings-> Mail Merge

 

[Vanguard]

in message

From other posts I am not clear on the steps to accomplish the
following
action with Outlook 2003:

I have an Excel spreadsheet that has 4 columns (Email_ address,
LastName,
FirstName, PassCode), and there are 250 rows of data.

I want to use Outlook 2003 to send an Email to each Email_address in
the
Excel spreadsheet. Each Email needs to include some standard text
(same for
all e-mails) plus the individualized FirstName and PassCode for each
recipient.

Mail Merge is a function in Word, not in Outlook. Ask in a Word
newsgroup how to use Mail Merge *after* you have first read through
the help already included in Word.

 

[Guest]

Thank you Roady. I am setting this up this morning and will reply back with
the results.

 

[Guest]

Thank you. Based on two responses to this post, I'm running through the
traps this morning - will let you know the results.

 

[Guest]

Hi agian Roady:

Thank you...!

Since the Excel file containing the Email address and other personalized
columns was already done, estimated time from start to finish using your
instructions below: 5 min (and most of that time was spent on composing the
short generic e-mail message & then inserting the personalized fields in
right places).

 

[Guest]

That was the key I was missing - start in Word. Then it's totally simple and
intuitive. Thanks!

 

[Roady [MVP]]

You're welcome!

Hi agian Roady:

Thank you...!

Since the Excel file containing the Email address and other personalized
columns was already done, estimated time from start to finish using your
instructions below: 5 min (and most of that time was spent on composing
the
short generic e-mail message & then inserting the personalized fields in
right places).