[Jack Cannon]

I am using the Mail Merge feature in Word 2002.
The data source is from an Access 2002 table.
That is working correctly.

However when I attempt to include a picture I am unable to change the
original picture regardless of what I do.

Initially I insert the picture using:
Insert/Picture/From File ... /Link to File

I get back something like:
{IncludePicture "C:\\Photos\\John.jpg" \* MERGEFORMATINET \d }
The selected picture is inserted into the document.

I then change the IncludePicture code to:
{IncludePicture "C:\\Photos\\{Mergefield "FirstName"}.jpg" \*
MERGEFORMATINET \d }
When the Mail Merge executes I get John's picture regardless of what is in
the database.
All other Mergefields operate correctly.

I also attempt to change the IncludePicture code to:
{IncludePicture "C:\\Photos\\Mary.jpg" \* MERGEFORMATINET \d }
and I still continue to get John's picture.

Can anyone explain what is going on?

Thanks Much,
Jack Cannon

[Jack Cannon]

It looks like I found the problem.
One needs to depress the key F9 after editing the IncludePicture code.

Thanks Anyway,
Jack Cannon

"Jack Cannon" wrote:

I am using the Mail Merge feature in Word 2002.
The data source is from an Access 2002 table.
That is working correctly.

However when I attempt to include a picture I am unable to change the
original picture regardless of what I do.

Initially I insert the picture using:
Insert/Picture/From File ... /Link to File

I get back something like:
{IncludePicture "C:\\Photos\\John.jpg" \* MERGEFORMATINET \d }
The selected picture is inserted into the document.

I then change the IncludePicture code to:
{IncludePicture "C:\\Photos\\{Mergefield "FirstName"}.jpg" \*
MERGEFORMATINET \d }
When the Mail Merge executes I get John's picture regardless of what is in
the database.
All other Mergefields operate correctly.

I also attempt to change the IncludePicture code to:
{IncludePicture "C:\\Photos\\Mary.jpg" \* MERGEFORMATINET \d }
and I still continue to get John's picture.

Can anyone explain what is going on?

Thanks Much,
Jack Cannon

[Graham Mayor]

No - you need to merge to a new document and then update all the images
http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

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



Jack Cannon wrote:
It looks like I found the problem.
One needs to depress the key F9 after editing the IncludePicture code.

Thanks Anyway,
Jack Cannon

"Jack Cannon" wrote:

I am using the Mail Merge feature in Word 2002.
The data source is from an Access 2002 table.
That is working correctly.

However when I attempt to include a picture I am unable to change the
original picture regardless of what I do.

Initially I insert the picture using:
Insert/Picture/From File ... /Link to File

I get back something like:
{IncludePicture "C:\\Photos\\John.jpg" \* MERGEFORMATINET \d }
The selected picture is inserted into the document.

I then change the IncludePicture code to:
{IncludePicture "C:\\Photos\\{Mergefield "FirstName"}.jpg" \*
MERGEFORMATINET \d }
When the Mail Merge executes I get John's picture regardless of what
is in the database.
All other Mergefields operate correctly.

I also attempt to change the IncludePicture code to:
{IncludePicture "C:\\Photos\\Mary.jpg" \* MERGEFORMATINET \d }
and I still continue to get John's picture.

Can anyone explain what is going on?

Thanks Much,
Jack Cannon

[Jack Cannon]

Thanks Graham,

You mentioned, "Select the new document - CTRL+A - then press F9 to update"
or to use the macro "UpdateAll".
That works great. But I need to execute the code from within Access VBA
without user intervention. Is there a way to do that?

I realize that this might not be the right forum but Word Mail Merge
questions do not fit in Access either.

Jack Cannon


"Graham Mayor" wrote:

No - you need to merge to a new document and then update all the images
http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

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

[Doug Robbins - Word MVP on news.microsoft.com]

At the appropriate place in your code, use the command

ActiveDocument.Fields.Update

--
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, originally posted via msnews.microsoft.com

"Jack Cannon" wrote in message
...
Thanks Graham,

You mentioned, "Select the new document - CTRL+A - then press F9 to
update"
or to use the macro "UpdateAll".
That works great. But I need to execute the code from within Access VBA
without user intervention. Is there a way to do that?

I realize that this might not be the right forum but Word Mail Merge
questions do not fit in Access either.

Jack Cannon


"Graham Mayor" wrote:

No - you need to merge to a new document and then update all the images
http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

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

[Jack Cannon]

Thanks Doug.

This is exactly what I was looking for.
Everything is now working great and
without user intervention.

Jack Cannon

"Doug Robbins - Word MVP on news.microsof" wrote:

At the appropriate place in your code, use the command

ActiveDocument.Fields.Update

--
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, originally posted via msnews.microsoft.com

[Jack Cannon]

Thanks Doug.

This is exactly what I was looking for.
Everything is now working great and
without user intervention.

Jack Cannon

"Doug Robbins - Word MVP on news.microsof" wrote:

At the appropriate place in your code, use the command

ActiveDocument.Fields.Update

--
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, originally posted via msnews.microsoft.com