Importing from Excel to Word??

[Guest]

I am trying to send the same letter to a large number of people but I want it
personalized for each. I have a list of all the names in an Excel file. Is
there a way to have this automated/imported into Word????

e.g. I want it to say

"Dear Bob:
It was nice to meet you.

Sincerely,
John Doe"

"Dear Johnny:
It was nice to meet you.

Sincerely,
John Doe"

I dont want to have to type each name and then print them out individually.

Please help!!!!!
Thanks a million!

 

[John John]

A fine question for the fellows in one of the Office newsgroups. Or
search your help files for "mail merge".

http://office.microsoft.com/en-us/help/results.aspx?qu=merge+excel+word

John

 

[Lanwench [MVP - Exchange]]

In

I am trying to send the same letter to a large number of people but I
want it personalized for each. I have a list of all the names in an
Excel file. Is there a way to have this automated/imported into
Word????

e.g. I want it to say

"Dear Bob:
It was nice to meet you.

Sincerely,
John Doe"

"Dear Johnny:
It was nice to meet you.

Sincerely,
John Doe"

I dont want to have to type each name and then print them out
individually.

Please help!!!!!
Thanks a million!

What you're looking for is called a 'mail merge' - and you initiate it from
Word, using your Excel spreadsheet as the source. The versions of Word and
Excel need to match, I believe - although you can probably use a tab- or
comma-delimited text file as the data source.

I suggest you post in a Microsoft Word newsgroup, if F1/help doesn't do it
for you - you'll get more help in there, as this is not a Windows issue.
Best o' luck.

 

[Tom Porterfield]

I am trying to send the same letter to a large number of people but I
want it personalized for each. I have a list of all the names in an
Excel file. Is there a way to have this automated/imported into Word????

e.g. I want it to say

"Dear Bob:
It was nice to meet you.

Sincerely,
John Doe"

"Dear Johnny:
It was nice to meet you.

Sincerely,
John Doe"

I dont want to have to type each name and then print them out
individually.

You want to do a mail merge in Word. In Word select Tools->Letters and
Mailings->Mail Merge. This will walk you through creating the letter and
selecting recipients. On the Select Recipients step choose the option to
use an existing list and click the Browse... link to browse to your Excel
spreadsheet. You will be able to then compose the letter, inserting fields
from your Excel sheet where you want them, and then finally complete the
merge.

Search Mail Merge in Word's help for additional details.

 

[Gord Dibben]

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

I am trying to send the same letter to a large number of people but I want it
personalized for each. I have a list of all the names in an Excel file. Is
there a way to have this automated/imported into Word????

e.g. I want it to say

"Dear Bob:
It was nice to meet you.

Sincerely,
John Doe"

"Dear Johnny:
It was nice to meet you.

Sincerely,
John Doe"

I dont want to have to type each name and then print them out individually.

Please help!!!!!
Thanks a million!

Gord Dibben MS Excel MVP