Home |
Search |
Today's Posts |
#1
|
|||
|
|||
merge data from excel to word
When I go to merge information from a file in Excel (with three spreadsheets)
it comes up as a blank sheet even though it is full of information. This makes it seem useless to have the Excel file if it won't merge into a document for my purposes. Thanks! |
#2
|
|||
|
|||
merge data from excel to word
Make sure that you spreadsheet complies with the information in the the
article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm Also check for the "Gotchas" detailed there. Data from an Excel spreadsheet can definitely be merged into a Word document if everything is the way it needs to be. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mbiber" wrote in message ... When I go to merge information from a file in Excel (with three spreadsheets) it comes up as a blank sheet even though it is full of information. This makes it seem useless to have the Excel file if it won't merge into a document for my purposes. Thanks! |
#3
|
|||
|
|||
merge data from excel to word
Yes that helped but it only allows me to see one of the spreadsheets.
"Doug Robbins - Word MVP" wrote: Make sure that you spreadsheet complies with the information in the the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm Also check for the "Gotchas" detailed there. Data from an Excel spreadsheet can definitely be merged into a Word document if everything is the way it needs to be. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mbiber" wrote in message ... When I go to merge information from a file in Excel (with three spreadsheets) it comes up as a blank sheet even though it is full of information. This makes it seem useless to have the Excel file if it won't merge into a document for my purposes. Thanks! |
#4
|
|||
|
|||
merge data from excel to word
If you are using XP or 2003, in Word, from the Tools menu, select Options
and then go to the General tab and check the box against Confirm conversions and open. When you attach the spreadsheet, you will then get a number of options for the way in which the connection should be made. The DDE option may overcome your problem. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mbiber" wrote in message ... Yes that helped but it only allows me to see one of the spreadsheets. "Doug Robbins - Word MVP" wrote: Make sure that you spreadsheet complies with the information in the the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm Also check for the "Gotchas" detailed there. Data from an Excel spreadsheet can definitely be merged into a Word document if everything is the way it needs to be. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mbiber" wrote in message ... When I go to merge information from a file in Excel (with three spreadsheets) it comes up as a blank sheet even though it is full of information. This makes it seem useless to have the Excel file if it won't merge into a document for my purposes. Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge from data in excel to word document. | Mailmerge | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
How do I create & merge specific data base & master documents? | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout |