mail merging when you only have 2 excel spreadsheets

[Guest]

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?

 

[Paul B]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.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

 

[Guest]

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]

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