software

Here's my predicament. I have an application for medical insurance that I
need each employee of a company to fill out. I have basic data that I can
mail merge so all they have to do is sign the application. The problem is
the application was sent to me in Excel and the census data from the company
was also sent in Excel. I know how to take a Word document and merge that
census data but how can I do that when the application is in Excel format? I
have tried opening Word and opening the Excel file that way and it asks if I
want to set it up in mail merge format but when it finally comes up it's all
messed up and does not appear like it does in Excel. Is there any hope for
me?

Kelly,
For help on Word mail merge using Excel as the data source have a look here

www.mvps.org/dmcritchie/excel/mailmerg.htm

www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

www.mvps.org/word/FAQs/MailMe...DataSource.htm--
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 amp; 2003

quot;Kelly Edwardsquot; gt; wrote in message
...
gt; Here's my predicament. I have an application for medical insurance that I
gt; need each employee of a company to fill out. I have basic data that I can
gt; mail merge so all they have to do is sign the application. The problem is
gt; the application was sent to me in Excel and the census data from the
company
gt; was also sent in Excel. I know how to take a Word document and merge that
gt; census data but how can I do that when the application is in Excel format?
I
gt; have tried opening Word and opening the Excel file that way and it asks if
I
gt; want to set it up in mail merge format but when it finally comes up it's
all
gt; messed up and does not appear like it does in Excel. Is there any hope
for
gt; me?
I know how to do a mail merge when your main document is a Word document, my
problem is the main document I have is in Excel. I have a separate
spreadsheet that has my data source. I tried to convert my main document to
a Word document from Excel and it just didn't work. Is there any way to do
this?

quot;Paul Bquot; wrote:

gt; Kelly,
gt; For help on Word mail merge using Excel as the data source have a look here
gt;
gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt;
gt; www.mvps.org/word/FAQs/MailMe...AMailMerge.htm
gt;
gt; www.mvps.org/word/FAQs/MailMe...DataSource.htm
gt;
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Kelly Edwardsquot; gt; wrote in message
gt; ...
gt; gt; Here's my predicament. I have an application for medical insurance that I
gt; gt; need each employee of a company to fill out. I have basic data that I can
gt; gt; mail merge so all they have to do is sign the application. The problem is
gt; gt; the application was sent to me in Excel and the census data from the
gt; company
gt; gt; was also sent in Excel. I know how to take a Word document and merge that
gt; gt; census data but how can I do that when the application is in Excel format?
gt; I
gt; gt; have tried opening Word and opening the Excel file that way and it asks if
gt; I
gt; gt; want to set it up in mail merge format but when it finally comes up it's
gt; all
gt; gt; messed up and does not appear like it does in Excel. Is there any hope
gt; for
gt; gt; me?
gt;
gt;
gt;

Kelly, see if this will help

from John Walkenbach
www.j-walk.com/ss/excel/tips/tip92.htm--
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 amp; 2003

quot;Kelly Edwardsquot; gt; wrote in message
...
gt; I know how to do a mail merge when your main document is a Word document,
my
gt; problem is the main document I have is in Excel. I have a separate
gt; spreadsheet that has my data source. I tried to convert my main document
to
gt; a Word document from Excel and it just didn't work. Is there any way to
do
gt; this?
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt; gt; Kelly,
gt; gt; For help on Word mail merge using Excel as the data source have a look
here
gt; gt;
gt; gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt; gt;
gt; gt; www.mvps.org/word/FAQs/MailMe...AMailMerge.htm
gt; gt;
gt; gt; www.mvps.org/word/FAQs/MailMe...DataSource.htm
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Paul B
gt; gt; Always backup your data before trying something new
gt; gt; Please post any response to the newsgroups so others can benefit from it
gt; gt; Feedback on answers is always appreciated!
gt; gt; Using Excel 2002 amp; 2003
gt; gt;
gt; gt; quot;Kelly Edwardsquot; gt; wrote in
message
gt; gt; ...
gt; gt; gt; Here's my predicament. I have an application for medical insurance
that I
gt; gt; gt; need each employee of a company to fill out. I have basic data that I
can
gt; gt; gt; mail merge so all they have to do is sign the application. The
problem is
gt; gt; gt; the application was sent to me in Excel and the census data from the
gt; gt; company
gt; gt; gt; was also sent in Excel. I know how to take a Word document and merge
that
gt; gt; gt; census data but how can I do that when the application is in Excel
format?
gt; gt; I
gt; gt; gt; have tried opening Word and opening the Excel file that way and it
asks if
gt; gt; I
gt; gt; gt; want to set it up in mail merge format but when it finally comes up
it's
gt; gt; all
gt; gt; gt; messed up and does not appear like it does in Excel. Is there any
hope
gt; gt; for
gt; gt; gt; me?
gt; gt;
gt; gt;
gt; gt;