merge data from excel to word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mbiber - 11 Nov 2005 18:31 GMT

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 to this Message

Doug Robbins - Word MVP - 11 Nov 2005 19:38 GMT

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/MailMerge/CreateADataSource.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.

Signature

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

> 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 to this Message

mbiber - 11 Nov 2005 21:26 GMT

Yes that helped but it only allows me to see one of the spreadsheets.

> Make sure that you spreadsheet complies with the information in the the
> article "Creating a Mail Merge Data Source" at:
[quoted text clipped - 12 lines]
> > document for my purposes.
> > Thanks!

Reply to this Message

Doug Robbins - Word MVP - 12 Nov 2005 08:13 GMT

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.

Signature

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

> Yes that helped but it only allows me to see one of the spreadsheets.
>
[quoted text clipped - 16 lines]
>> > document for my purposes.
>> > Thanks!

Reply to this Message