Reply
 
Thread Tools Display Modes
  #1   Report Post  
Salaivani
 
Posts: n/a
Default To select data from across worksheets in a excel file for a main .

In MS Word we have mail merge option, for which we can select the data source.
When i select the datasource as one of the worsheet in an excel, the main
document refers only the same worksheet for all its datasource.
But if one of the sections in the main document wants to refer to other
worksheet in the excel file, the previous referenced fileds are lost. Hence
the option should be given to select across the worksheets for atleast a
single excel file.

  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Word can only merge data from a flat file.

--
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
"Salaivani" wrote in message
...
In MS Word we have mail merge option, for which we can select the data
source.
When i select the datasource as one of the worsheet in an excel, the main
document refers only the same worksheet for all its datasource.
But if one of the sections in the main document wants to refer to other
worksheet in the excel file, the previous referenced fileds are lost.
Hence
the option should be given to select across the worksheets for atleast a
single excel file.



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
Put autotext names into txt file or excel file Anita Microsoft Word Help 1 January 14th 05 04:06 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 6th 05 12:23 AM
How do I select specific data from an imported document smintey Microsoft Word Help 1 December 6th 04 02:28 PM
Insert Excel Worksheets into Word Document Barb Reinhardt Microsoft Word Help 1 December 1st 04 07:30 PM
Export table data to Excel Kenny Kepler Tables 1 November 25th 04 02:45 PM


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

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

About Us

"It's about Microsoft Word"