Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2007

Tip: Looking for answers? Try searching our database.

Insert image conditionally

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Russell Campbell - 23 May 2007 15:49 GMT
I was on http://word.mvps.org/FAQS/MailMerge/CreateAMailMerge.htm where
there is some info on conditionally inserting an image into a document.
Unfortunately, I am not having much success with what it says should work.

Specifically, it says use something like this:

{ IF { MERGEFIELD FirstName } <> "" { INCLUDEPICTURE "C:\\Temp\\Logo.tif" \d
\* MERGEFORMAT } "" }

But it will not display the graphic and it seems to sometimes mangle my
entries (for instance, I close the document and bring it up later and it has
changed what I entered).

My statement was:

{ IF { MERGEFIELD msdsmfg } = 1 {INCLUDEPICTURE "c:\\msds\\test.bmp" \d \*
MERGEFORMAT } "" }

But Word alters it and later I get:

{ IF { MERGEFIELD msdsmfg } = 1 {INCLUDEPICTURE "../../../..msds\\test.bmp"
\* MERGEFORMAT \d } "" }

Not sure why that is and really don't care as long as this will work, but it
does not.  Any help would be appreciated.

Russell Campbell
Graham Mayor - 23 May 2007 15:59 GMT
Try - Tools > options > general > web options > files > uncheck update links
on save.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I was on http://word.mvps.org/FAQS/MailMerge/CreateAMailMerge.htm
> where there is some info on conditionally inserting an image into a
[quoted text clipped - 23 lines]
>
> Russell Campbell
Russell Campbell - 23 May 2007 16:29 GMT
Thanks.  I'll check that out.  I'm making progress.  It seems that it is
necessary to use F9 to update or this just doesn't work as expected.  I have
to do some testing in a real document - only been using a little test doc so
far - then I have to see if I can write a macro to make the necessary
changes in hundreds of existing docs.

> Try - Tools > options > general > web options > files > uncheck update
> links on save.
[quoted text clipped - 26 lines]
>>
>> Russell Campbell
Graham Mayor - 24 May 2007 06:49 GMT
When merging graphics you need to merge to a new document then update the
fields in that document - see http://www.gmayor.com/mail_merge_graphics.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks.  I'll check that out.  I'm making progress.  It seems that it
> is necessary to use F9 to update or this just doesn't work as
[quoted text clipped - 40 lines]
>>>
>>> Russell Campbell
Russell Campbell - 24 May 2007 14:27 GMT
Thanks again.  I went to your site to look around and found some helpful
information and to Cindy Meister's site.  I think some of the issues I'm
having are related to using Excel as a data source.  I'm wondering if a text
file would be better.  What can you tell me about that?

> When merging graphics you need to merge to a new document then update the
> fields in that document - see
[quoted text clipped - 44 lines]
>>>>
>>>> Russell Campbell
Graham Mayor - 24 May 2007 15:21 GMT
The Excel data source should not be an issue provided its use produces the
correct filename and path - however the conditional field may be - see the
workaround at http://www.gmayor.com/formatting_word_fields.htm 
(Conditionally Insert a Graphical Image)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks again.  I went to your site to look around and found some
> helpful information and to Cindy Meister's site.  I think some of the
[quoted text clipped - 57 lines]
>>>>>
>>>>> Russell Campbell
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.