Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
minignaz minignaz is offline
external usenet poster
 
Posts: 2
Default Mail Merge Query

I have been asked to do a mailmerge between an Excel file and a Word
Document, the excel file has 2 groupd of contact names (Agent / Personal),
the personal is always unique, but the Agent will be repeated depending on
how many times the agent is needed.

I wish to merge a document based on the Agent, but only have 1 document
produced whenever the agent name changes.

The problem is that I need a way of, on that single document, displaying all
of the other contact details of the personal fields.

Is there away of doing this?
  #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 Mail Merge Query

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

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

or at

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

"minignaz" wrote in message
...
I have been asked to do a mailmerge between an Excel file and a Word
Document, the excel file has 2 groupd of contact names (Agent / Personal),
the personal is always unique, but the Agent will be repeated depending on
how many times the agent is needed.

I wish to merge a document based on the Agent, but only have 1 document
produced whenever the agent name changes.

The problem is that I need a way of, on that single document, displaying
all
of the other contact details of the personal fields.

Is there away of doing this?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
minignaz minignaz is offline
external usenet poster
 
Posts: 2
Default Mail Merge Query

Thank you, that seems like it will do the job (I've only glanced at it, and
will have a better look soon).
Thanks again.

"Doug Robbins - Word MVP" wrote:

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

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

or at

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

"minignaz" wrote in message
...
I have been asked to do a mailmerge between an Excel file and a Word
Document, the excel file has 2 groupd of contact names (Agent / Personal),
the personal is always unique, but the Agent will be repeated depending on
how many times the agent is needed.

I wish to merge a document based on the Agent, but only have 1 document
produced whenever the agent name changes.

The problem is that I need a way of, on that single document, displaying
all
of the other contact details of the personal fields.

Is there away of doing this?




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
Mail merge using Access query problem NB Mailmerge 2 June 13th 06 04:52 PM
Query a mail merge for multiple letters at once? Brese Mailmerge 1 May 20th 05 02:10 PM
Mail Merge Access to Word using a Query Winston Mailmerge 3 May 4th 05 09:17 PM
how do I set up a query for my mail merge Laura Mailmerge 1 March 22nd 05 09:31 PM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM


All times are GMT +1. The time now is 12:40 PM.

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

About Us

"It's about Microsoft Word"