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

Tip: Looking for answers? Try searching our database.

Saving mail merge document problem!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jo416 - 15 Feb 2006 19:26 GMT
Hello,

I have been trying to create a mail merge document that uses the
INCLUDEPICTURE command.  (I'm using Word and Excel 2003)  I have followed
several examples online, and I finally got it to work, however I'm running
into an odd problem.

When I save the document,

{INCLUDEPICTURE {MERGEFIELD Picture1 } \d }

becomes

{INCLUDEPICTURE "Procedure%20Pictures/" \*MERGEFORMAT \d}

(The file path of the pictures is S:\OSHA DATA\LOTO PROGRAM\Updated
Procedures 2006\Procedure Pictures)

I have tried several different things including:

{INCLUDEPICTURE "S:\\OSHA DATA\\LOTO PROGRAM\\Updated Procedures
2006\\Procedure Pictures\\{MERGEFIELD Picture1} \d}

Whatever I do, it still replaces it all with {INCLUDEPICTURE
"Procedure%20Pictures/" \*MERGEFORMAT \d}

Could this be some sort of bug in the program?   Is there anything I can do
to fix it?  I can do the merge before I save, and that works, but as soon as
I hit the save button, it will magically change the field.  The problem is I
need to be able to run this merge several times with different pictures, so i
need to be able to save this document.

I hope someone can help!!!  This is so frustrating!!!  Thanks in advance!
Jo416 - 15 Feb 2006 19:37 GMT
Oh!  Never mind!  I just found the solution in one of the other posts!  Whew!

"In Tools/Options/General/Web options/Files deactivate the checkbox next to
"update links on save" (or similar). That's what's causing the abomination.

Cindy Meister"

Thanks, this site is great!

> Hello,
>
[quoted text clipped - 29 lines]
>
> I hope someone can help!!!  This is so frustrating!!!  Thanks in advance!
Richard Tackett - 16 Feb 2006 01:24 GMT
Glad you got your problem solved. Now, can you help me with my similar problem?

{INCLUDEPICTURE "C:\\Pix\\{MERGEFIELD photo}.jpg"}

The merge worked and a picture frame was included. The image was not there
though. There was the type of icon like you see on a web page when there is a
problem with the link to the image file.

My picture image is named SmithJoe.jpg and is stored in the directory
C:\Pix. There is a field in the table named photo that contains the text
SmithJoe.

Thanks for the help!

> Oh!  Never mind!  I just found the solution in one of the other posts!  Whew!
>
[quoted text clipped - 38 lines]
> >
> > I hope someone can help!!!  This is so frustrating!!!  Thanks in advance!
Jo416 - 16 Feb 2006 13:56 GMT
Hi Richard,

I don't know what could be wrong... but the text in my photo fields have the
.jpg extension in it.  For example, my code would just be

{INCLUDEPICTURE "C:\\Pix\\{MERGEFIELD photo}"}

because the text in the photo field is SmithJoe.jpg.

I don't know if that would have anything to do with it, but I guess it's
worth a shot.  Also, are you using CTRL and F9 to bring the brackets up,
instead of typing in "{" and "}" ?

Hope this helps, I'm not that great at this stuff, just started doing it
recently for a project at work. :)

> Glad you got your problem solved. Now, can you help me with my similar problem?
>
[quoted text clipped - 9 lines]
>
> Thanks for the help!
 
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.