Importing from Excel to Word??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
In
Scott23 said:
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!
Click to expand...

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.
 
Scott23 said:
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.
Click to expand...

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.
 
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!
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top