Rookie - Access to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

knowshowrosegrows - 07 Mar 2008 17:29 GMT

I am fairly familiar with Access, but have only done a few merges with word
using an Excel recipient list.

The project now is a letter to 200 folks. Each agency will be getting some
money for special projects. Each project has a paragraph that is associated
with it. No agency will get all the project funds, so no letter will include
all the paragraphs.

Agency one should get the paragraph 2, 5 and 9.
Agency two should get paragraph 3.
Also, these paragraphs are longer than 255 characters.

Which of you wizards are familiar enough with Access and Mailmerge to help
me make this happen... like MAGIC.

Signature

Thanks

You all are teaching me so much

Reply to this Message

Doug Robbins - Word MVP - 10 Mar 2008 12:28 GMT

Use and INCLUDETEXT field in the mailmerge main document that includes data
from a field in the datasource that relates to the file that contains the
group of paragraphs that are to be inserted.

The procedure is the same as that for including graphics (other than for the
use of the INCLUDETEXT rather than INCLUDEPICTURE) as detailed the "Graphics
from data base" item under the "Special merges" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

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 am fairly familiar with Access, but have only done a few merges with word
> using an Excel recipient list.
[quoted text clipped - 13 lines]
> Which of you wizards are familiar enough with Access and Mailmerge to help
> me make this happen... like MAGIC.

Reply to this Message

Rate this thread: