#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Bill D
 
Posts: n/a
Default Mail Merge saga

Working in Word 2002. I have an Access Table sorted by Vendor Number (key).
Each Vendor has 1 to many Divisions. I need to create a Mail Merge that will
print as follows.... NOTE equals Access Fields

VendorName
Address1
Address2
City, State Zip

A paragrah of misc Text..........

Here's where I need to bring in the Division(s)...

Divison, next Division, next Division and so on until all the related
Divisions for this Vendor are listed.

This a HOT issue I need help ASAP.

I know how to build a 'normal' mail merge letter... just adding the
Divisions is driving me nuts. I have tried the {If} clause and it's not
work.

Bill

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail Merge saga

As the data is in Access, if I were you, I would use a report in Access.

Word does not really have the ability to do that, but see:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at \:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

http://www.knowhow.com/Guides/Compou...poundMerge.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

"Bill D" Bill wrote in message
...
Working in Word 2002. I have an Access Table sorted by Vendor Number
(key).
Each Vendor has 1 to many Divisions. I need to create a Mail Merge that
will
print as follows.... NOTE equals Access Fields

VendorName
Address1
Address2
City, State Zip

A paragrah of misc Text..........

Here's where I need to bring in the Division(s)...

Divison, next Division, next Division and so on until all the
related
Divisions for this Vendor are listed.

This a HOT issue I need help ASAP.

I know how to build a 'normal' mail merge letter... just adding the
Divisions is driving me nuts. I have tried the {If} clause and it's not
work.

Bill



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
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 02:53 PM
My Email Mail Merge Does Not Work zombeese Mailmerge 0 May 19th 06 02:10 PM
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 05:43 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 05:44 PM.

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"