insert the relevant bitmap picture of a persons signature

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Garry - 12 Jan 2007 17:57 GMT

Can anyone please help me with this problem

I have to mailmerge and print 10,000 letters

Letter text is common to all

In the data file I have the relevant addresses etc plus a ref as follows :

AJ, PB and GF.

When lasering the letters in postcode order I need to insert the relevant
bitmap picture of the persons signature.

So if record being printed has a ref of PB I need to insert the correct
signature for Peter_Baxter.bmp, AJ for Angela_Jones.bmp etc

Can this be done so as to maintain postcode order. Thanks in advance, Garry

Reply to this Message

Doug Robbins - Word MVP - 12 Jan 2007 18:21 GMT

You may be able to do it with and If...then...Else field

{ IF { MERGEFIELD ref } = "AJ" { INCLUDEPICTURE
"Drive:\\Path\\[AJSigFile.bmp]" } { IF { MERGEFIELD ref } = "PB" {
INCLUDEPICTURE "Drive:\\Path\\[PBSigFile.bmp]" } { INCLUDEPICTURE
"Drive:\\Path\\[GFSigFile.bmp]" } } }

You must use Ctrl+F9 for each pair of field delimiters { }

See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

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

I would not be trying to execute the whole merge in one hit. Try a few
records and see how it goes.

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

> Can anyone please help me with this problem
>
[quoted text clipped - 14 lines]
> Can this be done so as to maintain postcode order. Thanks in advance,
> Garry

Reply to this Message