How do I create a mail merge document in Excel? Is it possible?

P

Plbowles

I have a form I would like to add mail merge fields to. Does anyone know how
to do that?
 
P

Paul B

Plbowles, I would use word for the merge,

For help on Word mail merge using Excel as the data source 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
 
P

Plbowles

The form I'm using is in Excel, not Word. Is there a way to create a mail
merge using an Excel file?
 
C

Chip Pearson

There is no built-in way to do a mail merge using Excel. You'd
have to write your own.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

Chip Pearson

Do you know how to code in VBA? Any solution would be code based.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top