 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2004Multiple Data Source
Could someone please tell me if it is possible to merge from two or more data sources into a main doc. If so please explain how. Mailmerge works only with a single file or table - that could be from an external query.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Could someone please tell me if it is possible to merge from two or > more data sources into a main doc. > > If so please explain how. Thanks Graham Any suggestions any other way I could go about achieving this. Rgds Steve > Mailmerge works only with a single file or table - that could be from an > external query. [quoted text clipped - 3 lines] > > > > If so please explain how. It depends on the nature of your data source - e.g. Access is better at manipulating data than Word. With Excel you could create a table to collate your information and merge from that. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks Graham > Any suggestions any other way I could go about achieving this. [quoted text clipped - 16 lines] >>> >>> If so please explain how. Steve, You do have the option of using Insert/Field/Database combined with a merge document, with this method you can combine multiple data sources as long as they all have a common link between them i.e unique i.d number. Its all according how you would like the layout of the document/data to appear. I'm currently working on a project to see if this method would be useful in my line of work so feel free to reply and discuss. Regards Badger > It depends on the nature of your data source - e.g. Access is better at > manipulating data than Word. With Excel you could create a table to collate [quoted text clipped - 20 lines] > >>> > >>> If so please explain how. |
Reply to this Message |
 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.