Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Donna
 
Posts: n/a
Default How do I use multiple worksheets when doing a mailmerge

I need to do a mailmerge containing data from 4 worksheets from 1 spreadsheet
document. How do I select all 4 worksheets in order to merge the data?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default How do I use multiple worksheets when doing a mailmerge

Word can only use a single, flat datasource for mailmerge. You will have to
add a 5th worksheet to the file on which to bring together in the one place
all of the required information from the other four sheets.

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

"Donna" wrote in message
...
I need to do a mailmerge containing data from 4 worksheets from 1
spreadsheet
document. How do I select all 4 worksheets in order to merge the data?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default How do I use multiple worksheets when doing a mailmerge

Hi ?B?RG9ubmE=?=,

I need to do a mailmerge containing data from 4 worksheets from 1 spreadsheet
document. How do I select all 4 worksheets in order to merge the data?

Since you don't describe any details on how the data is (or might be related)
it's hard to say, but you might see if this article helps

http://support.microsoft.com/default...b;en-us;180599

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

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
Linking multiple excel worksheets into Word reades Microsoft Word Help 2 November 12th 05 11:36 PM
Mail Merge using multiple worksheets in excel? TheRanz Microsoft Word Help 1 February 9th 05 03:13 AM
Using different worksheets as sources for mailmerge Graham Mailmerge 1 January 29th 05 01:40 AM
Multiple mailmerge documents open WordHazIt Mailmerge 0 January 5th 05 11:39 PM
How do I get multiple Access records into a single mailmerge lett. Wiley W. Mailmerge 1 December 18th 04 05:47 PM


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