Can I do a mail merge from within Excel?

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

Guest

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?
 
If you're creating a real pretty form letter, you may want to keep your data in
excel and then build your form/template in MSWord. Then use MSWord's mailmerge
to print each letter (or create individual emails).

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

But if you want to really build that form in excel, you could use the stuff at
Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and a way to update the data:
http://contextures.com/xlForm02.html

Or visit John Walkenbach's site:
http://www.j-walk.com/ss/excel/tips/tip92.htm
 
Hi,

Your question is not clear. If you want to create Mail merge in Microsoft
Word using Microsoft Excel data that is possible.

Note: Could you just elaborate a bit more, because there are two component
you are trying to emphasis - Form and Mail merge into Excel - what does this
mean?

Challa Prabhu
 
Hi,

Your question is not clear. If you want to create Mail merge in Microsoft
Word using Microsoft Excel data that is possible.

Note: Could you just elaborate a bit more, because there are two component
you are trying to emphasis - Form and Mail merge into Excel - what does this
mean?

Challa Prabhu
 
I keep school district information (names of superintendents, principals,
etc) in a spreadhseet. That information may change yearly. I'd like to
develop a form in Excel that would go to nine different districts
individually and it would include their current information ........ I will
be asking them to verify this information for the next school year. I
currently have this set up as a Word/Excel mail merge but I don't like the
looks of it. I thought it would be better if I could set it in Excel as a
form. I hope this helps clarify what I'm trying to accomplish. Thanks.
 
Back
Top