insert the relevant bitmap picture of a persons signature

G

Garry

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
 
D

Doug Robbins - Word MVP

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.
--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top