Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge from excel want day & month only | Excel Discussion (Misc queries) | |||
Merging Excel Spreadsheets Together | Excel Discussion (Misc queries) | |||
merging two excel spreadsheets - track changes from original | Excel Worksheet Functions | |||
Column format when merging Excel data to Word labels | Excel Discussion (Misc queries) | |||
Linked Excel Spreadsheets | Excel Discussion (Misc queries) |