Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pmv464 pmv464 is offline
external usenet poster
 
Posts: 3
Default Mail merge with multiple worksheets

Is it possible to select multiple worksheets in the same workbook when
specifying the data source?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge with multiple worksheets

No, Word can only use a single flat file as the data source. You will
therefore need to add a third sheet to your file on which you reference the
data on the other two sheets so that it all appears in the one place.

--
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

"pmv464" wrote in message
...
Is it possible to select multiple worksheets in the same workbook when
specifying the data source?



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
Using data from all worksheets within a workbook for mail merge Scott Mailmerge 2 June 11th 07 08:47 PM
How do I use multiple worksheets when doing a mailmerge Donna Mailmerge 2 February 2nd 06 05:10 PM
Why doesn't mail merge show filtered excel worksheets REVA Mailmerge 1 January 24th 06 02:30 PM
How do I mail merge data from different Excel worksheets into one. blw Microsoft Word Help 1 March 23rd 05 06:39 PM
Mail Merge using multiple worksheets in excel? TheRanz Microsoft Word Help 1 February 9th 05 02:13 AM


All times are GMT +1. The time now is 06:25 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"