#1
|
|||
|
|||
IncludePicture does not work in Mailmerge
Hi there,
I want to insert a picture in the footer of the LAST page of a page section. I found a way to do it by using IF, PAGE AND SECTIONPAGES This parsing works ok in the word template: {IF {PAGE} = {SECTIONPAGES} {INCLUDEPICTURE "d:\\signature.jpg"\* MERGEFORMATINET}} This works ok in the template, the signature is printed only in the last page of the section ( see attachment for example) But when I do a mail merge using the includepicture dissappears and only Page number and total Page section is populated. ( I populated Page number and Page section just to check that the pages were being numered correctly and they are) Any ideas of why this happen? I am puzzled |
#2
|
||||
|
||||
You cannot use an IF field this way in a mailmerge. That's because the first thing that happens when the merge executes is that the IF field gets evaluated and converted to its result. What you can use instead is a numeric picture switch in a formula field!
Try: {={SECTIONPAGES}-{PAGE} \# ";;'{INCLUDEPICTURE "d:\\signature.jpg"}'"} Note: you probably don't need the '\* MERGEFORMATINET' switch.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
thanks for the reply. I tried and the image still is not being populated in the mail merge, but now does not work in the template either. I am looking for more information about numeric picture switch ( first time ever that I heard about that option).
|
#4
|
||||
|
||||
The field won't 'work' in your mailmerge main document, because it can't be evaluated properly; it can only be evaluated properly when the merge executes.
Note too that you need to include the two single quote characters either side of the INCLUDETEXT field.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
YESSS , I was missing the single quotes. Thanks a lottt for your help. A pavlona for you
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using IncludePicture and MailMerge to insert picture | Elena | Mail Merge | 25 | 02-06-2022 05:35 PM |
IncludePicture does not refresh the pictures | ragesz | Mail Merge | 5 | 10-23-2020 03:41 AM |
INCLUDEPICTURE with Mail Merge - showing same image on every document | ccordner | Word | 0 | 10-23-2013 06:42 AM |
Yes/No field does not work in mailmerge | Abacus1234 | Mail Merge | 10 | 10-14-2013 06:37 AM |
Mailmerge to Email with a mailmerge attachment | Baldeagle | Mail Merge | 13 | 05-29-2012 02:04 PM |