[TimTDP]

I do a mail merge from Access. The merge consists of two fields, namely ProductCode and Logo. I use the IncludePicture function to include 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!

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" wrote in message
...

I do a mail merge from Access. The merge consists of two fields, namely
ProductCode and Logo. I use the IncludePicture function to include 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]

Not quite!
The error message disappears, but so does the graphic (Logo) in valid entries.

Originally Posted by Doug Robbins

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" wrote in message
...

I do a mail merge from Access. The merge consists of two fields, namely
ProductCode and Logo. I use the IncludePicture function to include 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]

When I print the word document the "if" function prints and not the graphic! How do I resolve this?

Originally Posted by TimTDP

Not quite!
The error message disappears, but so does the graphic (Logo) in valid entries.

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.


--

Graham Mayor - Word MVP

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


TimTDP wrote:
Not quite!
The error message disappears, but so does the graphic (Logo) in valid
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" wrote in message
...-

I do a mail merge from Access. The merge consists of two fields,
namely
ProductCode and Logo. I use the IncludePicture function to include
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-

ToolsOptionsPrint and uncheck Field codes in the Include with document
section of the dialog.

--
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" wrote in message
...

When I print the word document the "if" function prints and not the
graphic! How do I resolve this?

TimTDP Wrote:
Not quite!
The error message disappears, but so does the graphic (Logo) in valid
entries.


--
TimTDP