Mail Merge.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BeJay - 14 May 2007 10:31 GMT

I have mail merge word doc, which links a different excel sheet
dependant on the merge data. I need to refine this so that the link
is based on the name of the sheet and the data in one of the merged
fields. I.E .... where postcode in the merged doc = "BS28 1PP" insert
the sheet named "BS28 1PP". I don't know if this can be written into
an IF statement in the Link field. Please ....... any help really
really appreciated! thanks

Reply to this Message

Doug Robbins - Word MVP - 14 May 2007 12:18 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

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 have mail merge word doc, which links a different excel sheet
> dependant on the merge data. I need to refine this so that the link
[quoted text clipped - 3 lines]
> an IF statement in the Link field. Please ....... any help really
> really appreciated! thanks

Reply to this Message

BeJay - 15 May 2007 14:45 GMT

On 14 May, 12:18, "Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org>
wrote:

> Sounds like you are probably trying to perform a "multiple items per
> condition (=key field)" mailmerge which Word does not really have the
[quoted text clipped - 30 lines]
>
> - Show quoted text -

Doug, thanks for the links, however, I have tried to impliment the
ideas there, but can't seem to get these methods to work for what I
need .... which is

Where MERGEFIELD LocRef = BOB, link to worksheet BOB, then Where
MERGEFIELD LocRef= FRED, link to worksheet FRED.

However, what is happening is:- Where MERGEFIELD LocRef = FRED, The
letter is still linked to BOB worksheet and doesn't seem to want to
pick up FRED. I have tried on seperate workbooks called BOB, FRED
etc, but I still get the same problem. Again, any advice would be
most gratefully appreciated.

Reply to this Message