Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2005

Tip: Looking for answers? Try searching our database.

Can mail merge pull from records from multiple data sources?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nursery School Volunteer - 07 Aug 2005 05:56 GMT
I have an excel workbook that contains two separate worksheets for separate
school member info.  I need to create a mail merge letter and corresponding
labels for them, however, I am not sure if Word 2003 is capable of pulling
data from two separate data sources to create the labels.  It is easy to
create one set of labels and then merge the next set of labels, but that is
wasteful when there are extra labels on the first sheet.

Please advise
Doug Robbins - 07 Aug 2005 12:18 GMT
Mailmerge can only use a single flat datasource.  I assume that what you
need to do is create two formletter merges, one for each worksheet, with
different content for each worksheet and then you want to create labels for
both letters.  What you should do, so that the label merge can be executed
in one go, is to create a third worksheet into which you copy and paste the
relevant data from each of the other two worksheets.

There will be an issue if you later add records to the individual worksheets
as you will have to remember to copy the records to the "label" worksheet.

On the other hand, if you have Access, you could have each of the original
two worksheets as a separate table and use a union query to combine them and
form the source of the label type mailmerge.  Then you would only have to
enter new records one time.

Signature

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

>I have an excel workbook that contains two separate worksheets for separate
> school member info.  I need to create a mail merge letter and
[quoted text clipped - 6 lines]
>
> Please advise
Nursery School Volunteer - 07 Aug 2005 17:08 GMT
Thanks Doug.  That is one limitation of mail merge I would like to see
enhanced.  You are right, the best possible solution is combine the two
separate data onto a separate worksheet specifically for labels.  I was just
hoping that somehow the "concantenanate" function would work on this type of
task also.

Thanks again.
Linda

> Mailmerge can only use a single flat datasource.  I assume that what you
> need to do is create two formletter merges, one for each worksheet, with
[quoted text clipped - 21 lines]
> >
> > Please advise

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.