How can I use a Macro to automatically update all the pictures in a word doc

[GezLundy]

Hi

I am using the include picture function in my mailmerge document to link to a microsoft visual studio report. The report has a parameter which is a mergefield from the word document. I have managed to get the document to merge and to update the first picture successfully using the macro "ActiveDocument.Fields.Update"

The problem i'm having is that when more that one record is merged producing more than 1 picture only the first one is updated and the rest of the pictures are a replica of the first.

I am able to manually update these by pressing "CTRL A" then F9 but i want this to be done in the macro.

Does anyone know if this can be done and if so how?

Many Thanks

Geraint

[jpb103]

Add this line to the beginning of your code:

Selection.WholeStory

This is the VBA code for select all (Ctrl+A). If you ever want to see what something you do a lot of looks like in code, just click on "Record Macro" in the "Code" section of the Developer tab and repeat the procedure. Stop recording once you're done and have a look at the code for the macro you just recorded.

[macropod]

You do the whole lot as part of the mailmerge without the need for any macros. See: https://www.msofficeforums.com/mail-...g-dynamic.html

[GezLundy]

Hi Macropod,

This has worked perfectly.

Many thanks for your help.

Geraint