 |
 | 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 / January 2007Mailmerge multiple query's
I want to mailmerge data from about 8 or more query's from Access. How can I do this? Thanks! Can you describe a bit more about what you mean? For example: a. Do all the queries return the same columns, and do you just want to combine all the rows returned by all the queries into one big data source for a single merge? Or b. Do all the queries have the same number of rows, bu different columns, and you want to combine all the columns into one big data source for a merge? Or c. are the query results related in some other way? Or d. do you want to perform one merge per query, but maybe you want to automate the process. Or what? Peter Jamieson >I want to mailmerge data from about 8 or more query's from Access. > How can I do this? > > Thanks! I have word template (formated table) with 8 columns and I want insert fields manualy to some cells in this table. This is usualy process list. All query's get data from same table but for diferent product (example - price field), and have diferent numbers of rows. I must separate products and put this in template. > Can you describe a bit more about what you mean? For example: > a. Do all the queries return the same columns, and do you just want to [quoted text clipped - 15 lines] > > > > Thanks! Are you trying to produce a. 8 documents. Each document looks the same, but has the data from a different query b. 1 document, containing a table with the data from each query Or something else? If it makes it more simple to describe, make a sample doc to show approximately a. how you want the data to appear b. where the data should come from and e-mail it to me. You will need to despam my e-mail address by removing the text "KillMaps". Peter Jamieson >I have word template (formated table) with 8 columns and I want insert >fields [quoted text clipped - 25 lines] >> > >> > Thanks!
|
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.