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

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

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/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


"Plbowles" <Plbowles@discussions.microsoft.com> wrote in message
news:26EFE5C7-7F18-4EEE-8434-EFAE12CBF21B@microsoft.com...
>I have a form I would like to add mail merge fields to. Does anyone know
>how
> to do that?

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

"Plbowles" wrote:

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

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


"Plbowles" <Plbowles@discussions.microsoft.com> wrote in message
news:35AA2F5F-27AD-4E41-B0C2-E0A6D964ABB2@microsoft.com...
> The form I'm using is in Excel, not Word. Is there a way to
> create a mail
> merge using an Excel file?
>
> "Plbowles" wrote:
>
>> I have a form I would like to add mail merge fields to. Does
>> anyone know how
>> to do that?

Thanks. Any way to tell me how to get started or where I could go?

"Chip Pearson" wrote:

> 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
>
>
> "Plbowles" <Plbowles@discussions.microsoft.com> wrote in message
> news:35AA2F5F-27AD-4E41-B0C2-E0A6D964ABB2@microsoft.com...
> > The form I'm using is in Excel, not Word. Is there a way to
> > create a mail
> > merge using an Excel file?
> >
> > "Plbowles" wrote:
> >
> >> I have a form I would like to add mail merge fields to. Does
> >> anyone know how
> >> to do that?
>
>
>

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


"Plbowles" <Plbowles@discussions.microsoft.com> wrote in message
news:27DE7469-EE1C-4416-918A-62B23DB2597B@microsoft.com...
> Thanks. Any way to tell me how to get started or where I could
> go?
>
> "Chip Pearson" wrote:
>
>> 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
>>
>>
>> "Plbowles" <Plbowles@discussions.microsoft.com> wrote in
>> message
>> news:35AA2F5F-27AD-4E41-B0C2-E0A6D964ABB2@microsoft.com...
>> > The form I'm using is in Excel, not Word. Is there a way to
>> > create a mail
>> > merge using an Excel file?
>> >
>> > "Plbowles" wrote:
>> >
>> >> I have a form I would like to add mail merge fields to.
>> >> Does
>> >> anyone know how
>> >> to do that?
>>
>>
>>

John Walkenbach has a sample workbook that does a mailmerge using Excel only.

Try it out.

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



Gord Dibben Excel MVP

On Mon, 19 Dec 2005 10:10:03 -0800, "Plbowles"
<Plbowles@discussions.microsoft.com> wrote:

>The form I'm using is in Excel, not Word. Is there a way to create a mail
>merge using an Excel file?
>
>"Plbowles" wrote:
>
>> I have a form I would like to add mail merge fields to. Does anyone know how
>> to do that?