Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Shweta Srivastava Shweta Srivastava is offline
external usenet poster
 
Posts: 3
Default Mail Merge with more than one file

Hi,

Any trick to get data from three different excel workbook in a WORD document.
I am required to prepare detailed report in WORD which require data from
three different workbook at the required place in WORD.


--
Shweta Srivastava
  #2   Report Post  
Posted to microsoft.public.word.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mail Merge with more than one file

Hi Shweta,

You can create a new workbook that brings together the required data from the other three workbooks and use the new workbook as the
mailmerge data source.

--
Cheers
macropod
[Microsoft MVP - Word]


"Shweta Srivastava" wrote in message
...
Hi,

Any trick to get data from three different excel workbook in a WORD document.
I am required to prepare detailed report in WORD which require data from
three different workbook at the required place in WORD.


--
Shweta Srivastava


  #3   Report Post  
Posted to microsoft.public.word.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mail Merge with more than one file

Hi Shweta,

You can create a new workbook that brings together the required data from the other three workbooks and use the new workbook as the
mailmerge data source.

--
Cheers
macropod
[Microsoft MVP - Word]


"Shweta Srivastava" wrote in message
...
Hi,

Any trick to get data from three different excel workbook in a WORD document.
I am required to prepare detailed report in WORD which require data from
three different workbook at the required place in WORD.


--
Shweta Srivastava


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
mail merge using two different xls file how findout max data like text, any word Mailmerge 1 January 17th 09 08:20 PM
When I use mail merge, can I merge a field to make the file name? Mulsh50 Mailmerge 1 August 17th 07 04:14 AM
After mail merge, "File format is not valid" error when opening XLS file Bob on Whidbey Mailmerge 4 July 4th 07 10:49 AM
my mail merge tool bar is not active in my mail merge file 547512 Microsoft Word Help 1 February 7th 06 06:50 AM
Mail Merge: How do you merge to file but create separate files david Mailmerge 1 March 22nd 05 07:11 AM


All times are GMT +1. The time now is 12:40 AM.

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"