ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can i use mailmerge to in excel like you would in word? (https://www.excelbanter.com/excel-discussion-misc-queries/69266-can-i-use-mailmerge-excel-like-you-would-word.html)

acain1711

can i use mailmerge to in excel like you would in word?
 
is it possible to use mail merge in excel instead of word but have the same
overall effect


Paul B

can i use mailmerge to in excel like you would in word?
 
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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

A training tutorial for creating envelopes and labels.
http://office.microsoft.com/training...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

"acain1711" wrote in message
...
is it possible to use mail merge in excel instead of word but have the

same
overall effect




David McRitchie

can i use mailmerge to in excel like you would in word?
 
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.

"Paul B" wrote
A training tutorial for creating envelopes and labels.
http://office.microsoft.com/training...RC010390291033




Paul B

can i use mailmerge to in excel like you would in word?
 
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

"David McRitchie" wrote in message
...
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.

"Paul B" wrote
A training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033






All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com