Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
insert the relevant bitmap picture of a persons signature
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
insert the relevant bitmap picture of a persons signature
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/cindy...r/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 "Garry" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i automatically insert signature | Microsoft Word Help | |||
Can I insert a filename when I insert a picture into word? | Microsoft Word Help | |||
How to insert a linked picture from a Web page? | Microsoft Word Help | |||
How do you embed a bitmap so that insert it as a packaged file? | Microsoft Word Help | |||
How do you change the default picture insert to lock anchor? | Page Layout |