IncludePicture syntax for URL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Binchar - 01 Feb 2004 19:36 GMT

I need to do a mail merge that includes pictures that are on the web. There is a mail merge field in the data source that has the url to the picture. I can't seem to stumble on the right syntax to get mail merge to insert the URL from the data source into the IncludePicture. Can I do this? If so, would someone mind posting the syntax

Thanks

LAR

Reply to this Message

Graham Mayor - 02 Feb 2004 06:30 GMT

Let's assume that you have the urls in the data file in the format:

http://www.gmayor.com/NewHouse/112-1225_IMG.jpg

in a field called Image, then to insert the image you need a field
construction

{IncludePicture {Mergefield Image}}

Merge to a new document, select all (CTRL+A) then F9 to update and display
the pictures. I would imagine that you would need a reliable fast
interconnection for this to work well. It would work faster if all the
required images were cached on your hard drive and you work off line.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I need to do a mail merge that includes pictures that are on the web.
> There is a mail merge field in the data source that has the url to
[quoted text clipped - 5 lines]
>
> LAR

Reply to this Message

Binchar - 03 Feb 2004 03:51 GMT

Graham,

Thanks for the quick response. Is there a syntax for "linking" to the picture rather than embedding it? The pictures I'm trying to refer to are not on a local drive, but on an internet server. Second, how does the substitution take place on a mail merge with no "chevron" fields?

Thanks for your help.

Larry

Reply to this Message

Graham Mayor - 03 Feb 2004 06:01 GMT

The 'chevron' fields are merely internal indicators used by Word's mail
merge. If you toggle them, they should display as {Mergefield fieldname}.
You can enter mergefields from the keyboard using CTRL+F9 to set the field
boundaries {}.

Use a \d switch on the IncludePicture field to link rather than store in the
file.
eg
{IncludePicture {Mergefield Image}\d}

If the pictures are not available locally, the merge will simply take
longer, but the procedure is as originally stated.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Graham,
>
[quoted text clipped - 7 lines]
>
> Larry

Reply to this Message

Binchar - 03 Feb 2004 17:46 GMT

Awesome! Thanks so much Graham.

Larry

Reply to this Message

Graham Mayor - 03 Feb 2004 21:56 GMT

You are welcome :)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Awesome! Thanks so much Graham.
>
> Larry

Reply to this Message