Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2013, 05:14 PM
malalex malalex is offline IncludePicture does not work in Mailmerge Windows XP IncludePicture does not work in Mailmerge Office 2007
Novice
IncludePicture does not work in Mailmerge
 
Join Date: Dec 2013
Posts: 3
malalex is on a distinguished road
Default 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





Attached Images
File Type: jpg includepict.JPG (57.0 KB, 2 views)
Reply With Quote
  #2  
Old 12-10-2013, 06:31 PM
macropod's Avatar
macropod macropod is offline IncludePicture does not work in Mailmerge Windows 7 32bit IncludePicture does not work in Mailmerge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,194
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 12-10-2013, 06:47 PM
malalex malalex is offline IncludePicture does not work in Mailmerge Windows XP IncludePicture does not work in Mailmerge Office 2007
Novice
IncludePicture does not work in Mailmerge
 
Join Date: Dec 2013
Posts: 3
malalex is on a distinguished road
Default

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).
Reply With Quote
  #4  
Old 12-10-2013, 07:02 PM
macropod's Avatar
macropod macropod is offline IncludePicture does not work in Mailmerge Windows 7 32bit IncludePicture does not work in Mailmerge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,194
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #5  
Old 12-10-2013, 07:09 PM
malalex malalex is offline IncludePicture does not work in Mailmerge Windows XP IncludePicture does not work in Mailmerge Office 2007
Novice
IncludePicture does not work in Mailmerge
 
Join Date: Dec 2013
Posts: 3
malalex is on a distinguished road
Default

YESSS , I was missing the single quotes. Thanks a lottt for your help. A pavlona for you
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IncludePicture does not work in Mailmerge IncludePicture does not refresh the pictures ragesz Mail Merge 5 10-23-2020 03:41 AM
IncludePicture does not work in Mailmerge Using IncludePicture and MailMerge to insert picture Elena Mail Merge 23 06-20-2020 04:29 PM
INCLUDEPICTURE with Mail Merge - showing same image on every document ccordner Word 0 10-23-2013 06:42 AM
IncludePicture does not work in Mailmerge Yes/No field does not work in mailmerge Abacus1234 Mail Merge 10 10-14-2013 06:37 AM
IncludePicture does not work in Mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft