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 / January 2006

Tip: Looking for answers? Try searching our database.

how so i imerge info from a datasource into table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Teri - 18 Jan 2006 16:55 GMT
I have a table in my letter. I need to know how to merge the information from
a datasource into that table.
Peter Jamieson - 18 Jan 2006 18:21 GMT
Generally speaking, Word expects to create one copy of your letter for each
record in the datasource. In other words, Word mailmerge is not designed to
stuff a set of records into the middle of a document, i.e. does not really
work the way you are hoping it will.

So, what can be done? It depends on precisely what you're trying to achieve,
but the simplest way to achieve what you want could be:
a. create a completely new mailmerge, using a "catalog mailmerge". This
would have a single table row with one column for each column you want to
merge from the datasource. Attach the mail merge main document to the data
source, and insert a MERGEFIELD field in each column of the table row.
b. perform the merge, outputting to a new document. You should have a new
table consisting of the rows you want.
c. copy/paste that table into your letter.
d. create a header row by selecting row 1 and copying/pasting it, then
replacing the copied data by the table column headers you want.

There are other possibilities...

Peter Jamieson

>I have a table in my letter. I need to know how to merge the information
>from
> a datasource into that table.
 
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.