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

skmarshall wrote:

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?

--

Dave Peterson

I would recommend Word for mail-merging, but John Walkenbach has an
Excel-only mail merge method you could use.

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


Gord Dibben MS Excel MVP

On Wed, 18 Jul 2007 13:02:03 -0700, skmarshall
wrote:

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?

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

"skmarshall" wrote:

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?

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


"skmarshall" wrote:

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?

Hi,

Please refer to this link: http://www.mcgimsey.com/excel/subs/mergedata.html

Challa Prabhu

"skmarshall" wrote:

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?

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.

"challa prabhu" wrote:

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

"skmarshall" wrote:

I would like to be able to develop a form in Excel and mail merge information
into Excel. Is this possible?