Reply
 
Thread Tools Display Modes
  #1   Report Post  
Cowtoon
 
Posts: n/a
Default merge with excel question

I have all of my data for my merge in an excel spreadsheet. For good
reasons, the spreadsheets has the information in several worksheets (but all
in one file).

Is there a way to do a merge that will include all of the worksheets? I
have to do toooooo many merges to merge all of the data, otherwise. I don't
usually merge all of the worksheets at a time.

Can someone help with this. Thanks. Diana
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Word can only use a single "flat file" as the data source. If for some
other reason, you need to keep the separate worksheets, add another
worksheet to the file on which you have references to each of the cells in
the individual worksheets so that on that new worksheet ALL of the data is
displayed.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Cowtoon" wrote in message
...
I have all of my data for my merge in an excel spreadsheet. For good
reasons, the spreadsheets has the information in several worksheets (but
all
in one file).

Is there a way to do a merge that will include all of the worksheets? I
have to do toooooo many merges to merge all of the data, otherwise. I
don't
usually merge all of the worksheets at a time.

Can someone help with this. Thanks. Diana



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge an excel document Pat McGlamery Tables 1 December 10th 04 03:00 AM
Merge from Excel to word for labels pattimelt Mailmerge 1 December 5th 04 10:44 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM
mail merge using excel spread looses the format for social securit rmoritzky Mailmerge 2 December 1st 04 10:55 AM
how do i create a mail merge for email using excel as a data sourc AnnA Mailmerge 1 December 1st 04 12:57 AM


All times are GMT +1. The time now is 05:06 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"