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 / December 2006

Tip: Looking for answers? Try searching our database.

Word 2002 Changing Photo Merge Field Data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy - 27 Dec 2006 00:40 GMT
Hi;

Had been using Word 2000 for a mail merge from Access 2000 and the this code
worked correctly in Word 2000:
{IncludePicture "c:\\Program Files\\My Program\\ProductPictures\\{MERGEFIELD
ProductCategory}{ProductSubCategory}{ProductName}.jpg"}

What the code does is pull a photo of the Product.
Note: The photos are named using the Category: Clothing, Sub-Category:
Woman, and ProductName: Shoes.
Example: ClothingWomanShoes.jpg

A query with a criteria in Access generates the merge using the information
the user has displayed on the screen.

A command button then executes the merge.
Everything worked correctly until we started using Word 2002 on one
computer.

The code changes to:
{IncludePicture "../../../program%20files/My
Program//ProductPictures/ClothingWomansShoes.jpg" \* MERGEFORMATINNET}

The Double Backslashes are replaced by the above.

Tried doing it manually.  It works at first but when the document is saved
it changes from:
{IncludePicture "C:\\Program Files\\My Program\\ProductPictures\\{MERGEFIELD
ProductCategory}{MERGEFIELD ProductSubCategory}{MERGEFIELD
ProductName}.jpg"}
To:
{IncludePicture "../../../program%20files/My
Program//ProductPictures/ClothingWomansShoes.jpg" \* MERGEFORMATINNET}

With the first example the code is dynamic and shows the correct picture,
with the second it is static and calls for a specific picture
"ClothingWomansShoes.jpg" and doesn't show any graphic at all.  It only
shows a "Place Holder" where the photo should be.

Tried the resolution from Microsoft:
Example:
{INCLUDEPICTURE {MERGEFIELD "Picture"} \*MERGEFORMAT}
http://support.microsoft.com/kb/114306/en-us
And
Example: { IncludePicture "C:\\Data\\Pics\\{ Mergefield Signature \*
upper }" }
From: http://homepage.swissonline.ch/cindymeister/MergFram.htm
And quite a few more.

Getting nowhere fast.

Would someone be so kind and point me in the correct direction?

Thank You for taking the time to read this post.

Andy
Cindy M. - 27 Dec 2006 10:20 GMT
Hi Andy,

The problem is in Tools/Options/General/Web options/Files. Deactivate the
option to automatically update links when saving. That will stop Word from
making the changes to the field code.

> Had been using Word 2000 for a mail merge from Access 2000 and the this code
> worked correctly in Word 2000:
[quoted text clipped - 42 lines]
> From: http://homepage.swissonline.ch/cindymeister/MergFram.htm 
> And quite a few more.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Andy - 27 Dec 2006 16:45 GMT
Cindy;

Thank You.

It Works!

Andy

> Hi Andy,
>
[quoted text clipped - 62 lines]
> reply
> in the newsgroup and not by e-mail :-)
 
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.