can i use mailmerge to in excel like you would in word?

A

acain1711

is it possible to use mail merge in excel instead of word but have the same
overall effect
 
P

Paul B

acani1711,
Here's a way from John Walkenbach just using excel, although I think using
word to do the merge would be better

http://www.j-walk.com/ss/excel/tips/tip92.htm

You can also use word mail merge an Excel as the data source

For help on this have a look here

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

A training tutorial for creating envelopes and labels.
http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

David McRitchie

Hi Paul,
The last reference is for creating an individual
letter or envelope and specifically states that you would look
in Word's help for information on Mail Merge. So if you are
keeping track of mail merge tutorials you might want to revise wording
in future.
 
P

Paul B

David, thanks I will make a note of that

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top