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 / August 2004

Tip: Looking for answers? Try searching our database.

customizing merge documents

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandy - 17 Aug 2004 13:30 GMT
I am trying to create a merge document using Microsoft Access. My
document will have several sections each requiring different filtered
data from the same database.  I can filter no problem using <Next
Record If> but I need to enter text between each set of filtered
records and am unable to do so.  Can anyone suggest what I may be
doing wrong.

e.g.
Bachelor of Arts (heading)

«Next Record If»«cal_subj»    «cal_num» (If = not equal to SCIE)

Bachelor of Science (heading)

«Next Record If»«cal_subj»    «cal_num» (If = not equal to ARTS)
   
This returns the heading before each record in the set.

Thanks!
Doug Robbins - 18 Aug 2004 00:02 GMT
Sounds to me like you should be using a report in Access.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am trying to create a merge document using Microsoft Access. My
> document will have several sections each requiring different filtered
[quoted text clipped - 15 lines]
>
> Thanks!
 
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.