Image files in Form Letters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric Byers - 09 Nov 2004 22:38 GMT

Running Office 2000

I am trying to create a form letter which will include a logo file for each
of the comapnies in my database. I am mail merging from and Excel file with
a column called CompanyLogo which has a UNC to file (i.e.
C:\CompanyLogos\*.*) I have been trying to get the following string to work
but it doesn't seem to be working. Not sure why.

{INCLUDEPICTURE {MERGEFIELD CompanyLogo}}

Thanks

Reply to this Message

Graham Mayor - 09 Nov 2004 23:41 GMT

Merge to a new document, select all (CTRL+A) then F9 to update.

Signature

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

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

> Running Office 2000
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Ariana - 19 Jan 2005 14:01 GMT

I used the following format:

{INCLUDEPICTURE {MERGEFIELD "Picture"} \*MERGEFORMAT}

however, i continue to receive an error in the final document. I did attempt
to CTRL+A then F9 but only receive an expanded empty field in the intended
image location.

> Merge to a new document, select all (CTRL+A) then F9 to update.
>
[quoted text clipped - 9 lines]
> >
> > Thanks

Reply to this Message

Doug Robbins - 19 Jan 2005 23:42 GMT

What is the format of the data in the picture field. The path separators \
must be doubled \\.

If you press Alt+F9 in the document produced by executing the merge, what do
you see?

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I used the following format:
>
[quoted text clipped - 18 lines]
>> >
>> > Thanks

Reply to this Message

Ariana - 03 Feb 2005 19:19 GMT

The image link in the XLS spreadsheet is as follows:

\\dca.state.vt.us\accddata\Shared\Available_Sites_photos\Barre City - Office
Suites.jpg

I have tried several configurations of naming the link, and i have tested
the link (and been able to open the image directly from double-clicking in
the spreadsheet.)

> What is the format of the data in the picture field. The path separators \
> must be doubled \\.
[quoted text clipped - 24 lines]
> >> >
> >> > Thanks

Reply to this Message

Doug Robbins - 03 Feb 2005 23:27 GMT

It needs to be

[Driveletter]:\\dca.state.vt.us\\accddata\\Shared\\Available_Sites_photos\\Barre
City - Office Suites.jpg

Signature

> The image link in the XLS spreadsheet is as follows:
>
[quoted text clipped - 38 lines]
>> >> >
>> >> > Thanks

Reply to this Message