mail merging when you only have 2 excel spreadsheets
 

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?

mail merging when you only have 2 excel spreadsheets
 

Kelly,
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


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

"Kelly Edwards" wrote in message
...
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?

mail merging when you only have 2 excel spreadsheets
 

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?

"Paul B" wrote:

Kelly,
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


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

"Kelly Edwards" wrote in message
...
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?

mail merging when you only have 2 excel spreadsheets
 

Kelly, see if this will help

from John Walkenbach
http://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 & 2003

"Kelly Edwards" wrote in message
...
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?

"Paul B" wrote:

Kelly,
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


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

"Kelly Edwards" wrote in
message
...
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?