Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
knowshowrosegrows knowshowrosegrows is offline
external usenet poster
 
Posts: 12
Default Rookie - Access to Word

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.
--
Thanks

You all are teaching me so much
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Rookie - Access to Word

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/cindy...r/MergFram.htm

--
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

"knowshowrosegrows" wrote in
message ...
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.
--
Thanks

You all are teaching me so much



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Inability to see queries in complicated access files: 2003 access& bird lover Mailmerge 1 December 29th 06 09:02 PM
can't access my word files - access restricted film101 Microsoft Word Help 1 April 6th 06 09:22 AM
word opens access in mail merge. Access is already opened.=twice Sherri Mailmerge 1 February 11th 06 05:59 PM
Word and Access Z Microsoft Word Help 1 November 15th 05 09:57 AM
Can you help with mail merge rookie? Tony Barker Mailmerge 2 February 23rd 05 06:32 AM


All times are GMT +1. The time now is 09:47 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"