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 / August 2005

Tip: Looking for answers? Try searching our database.

If function and IncludePicture

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TimTDP - 17 Aug 2005 08:13 GMT
Not quite!
The error message disappears, but so does the graphic (Logo) in vali
entries.

Doug Robbins Wrote:
> Use the following field construction
>
> { IF { MERGEFIELD Logo } "" { INCLUDEPICTURE { MERGEFIELD Logo } } "
> }
>
> --
> 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
> "TimTDP" TimTDP.1tvgrf@news.wordbanter.com wrote in message
> news:TimTDP.1tvgrf@news.wordbanter.com...-
>
> I do a mail merge from Access. The merge consists of two fields
> namely
> ProductCode and Logo. I use the IncludePicture function to includ
> the
> Logo in the merge. This works well.
> However I want to expand this to include an "if" function so that if
> the field "Logo" is empty, no error message appears in the merged
> document.
>
> Any help will be appreciated!
>
> --
> TimTDP

--
TimTDP
Graham Mayor - 17 Aug 2005 10:59 GMT
Your reproduced field missed out the essential <> part.

{ IF { MERGEFIELD Logo } <> "" "{ INCLUDEPICTURE { MERGEFIELD Logo }}"}

Merge to a new document then select all CTRL+A and F9 to update.

Signature

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

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

> Not quite!
> The error message disappears, but so does the graphic (Logo) in valid
[quoted text clipped - 29 lines]
>> --
>> TimTDP-
 
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.