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?