Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Garry Garry is offline
external usenet poster
 
Posts: 3
Default 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   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 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i automatically insert signature jeremy Microsoft Word Help 11 December 10th 09 11:14 PM
Can I insert a filename when I insert a picture into word? tpbIII Microsoft Word Help 2 March 13th 06 11:13 AM
How to insert a linked picture from a Web page? userBTM Microsoft Word Help 0 December 1st 05 10:39 PM
How do you embed a bitmap so that insert it as a packaged file? Kirk Microsoft Word Help 1 November 18th 05 08:13 PM
How do you change the default picture insert to lock anchor? Clark Griffiths Page Layout 1 November 30th 04 10:45 AM


All times are GMT +1. The time now is 12:11 AM.

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

About Us

"It's about Microsoft Word"