Large Graphic "Mail Merge"

Barry S.

unread,

Oct 23, 2005, 4:09:29 PM10/23/05

to

I prepare a 30 page report every week and it has 20-30 1600x1200
pictures in the document.

I would love to be able to effectively do a mail merge with them.
(E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes
here.)

What's the best way to do this?

Thank you.

__________________
Note: To reply, replace the word 'spam' embedded in return address with 'mail'.

Doug Robbins - Word MVP

unread,

Oct 24, 2005, 12:24:03 AM10/24/05

to

See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

--
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

"Barry S." <nn...@spamsack.org> wrote in message
news:qbrnl11aj4ur2qou7...@4ax.com...

Robert M. Franz (RMF)

unread,

Oct 24, 2005, 4:50:30 AM10/24/05

to

Hi Barry

Barry S. wrote:
> I prepare a 30 page report every week and it has 20-30 1600x1200
> pictures in the document.
>
> I would love to be able to effectively do a mail merge with them.
> (E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes
> here.)
>
> What's the best way to do this?

It sounds like a MailMerge would not be the best way (at least it isn't
straight-forward why you'd want to use one): my first idea would be to
insert the pictures as links (positioned in table cells with fixed
height/width).

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word

Barry S.

unread,

Oct 24, 2005, 6:47:42 PM10/24/05

to

On Mon, 24 Oct 2005 06:24:03 +0200, "Doug Robbins - Word MVP"
<d...@REMOVETHISmvps.org> wrote:

>See the "Graphics from data base" item under the "Special merges" section of
>fellow MVP Cindy Meister's website at
>
>http://homepage.swissonline.ch/cindymeister/MergFram.htm

I'm reading it and I think I'm missing some things..

Like how the merge field in Word knows how to reference to a given
Field in Access..

{ IncludePicture "C:\\Data\\Pics\\{ Mergefield Signature \* upper }" }

Is "Signature" The field in the Access Database?

Thanks..

Barry S.

unread,

Oct 25, 2005, 12:51:21 AM10/25/05

to

On Mon, 24 Oct 2005 10:50:30 +0200, "Robert M. Franz (RMF)"
<robert...@mvps.org> wrote:

>Hi Barry
>
>Barry S. wrote:
>> I prepare a 30 page report every week and it has 20-30 1600x1200
>> pictures in the document.
>>
>> I would love to be able to effectively do a mail merge with them.
>> (E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes
>> here.)
>>
>> What's the best way to do this?
>
>It sounds like a MailMerge would not be the best way (at least it isn't
>straight-forward why you'd want to use one): my first idea would be to
>insert the pictures as links (positioned in table cells with fixed
>height/width).
>
>HTH
>Robert

Could you direct me to a further instruction on inserting pictures as
links?

Google doesn't seem to be directing me...

Thanks.

Robert M. Franz (RMF)

unread,

Oct 25, 2005, 10:06:11 AM10/25/05

to

Hi Barry

Barry S. wrote:
> On Mon, 24 Oct 2005 10:50:30 +0200, "Robert M. Franz (RMF)"
> <robert...@mvps.org> wrote:
> Could you direct me to a further instruction on inserting pictures as
> links?
>
> Google doesn't seem to be directing me...

What version of Word? In 2003 (and most probably in all three previous
versions), I have a topic "Insert Picture" in the offline help. In
there, click on "Insert a picture from a file", and also on "Show All".

That's the base information (it doesn't really tell you _how_ to do it,
though :-( ).

The actual thing to do is: Insert | Picture | From File, locate the
picture, and click on the small black triangle next to the "Insert"
button. Use "Link". This results in an INCLUDEPICTURE-link (which you
can see when you press SHIFT-F9 while the picture is selected. Now you
can read up that field in Word's help, too.

Barry S.

unread,

Nov 23, 2005, 5:53:32 PM11/23/05

to

On Tue, 25 Oct 2005 16:06:11 +0200, "Robert M. Franz (RMF)"
<robert...@mvps.org> wrote:

>The actual thing to do is: Insert | Picture | From File, locate the
>picture, and click on the small black triangle next to the "Insert"
>button. Use "Link". This results in an INCLUDEPICTURE-link (which you
>can see when you press SHIFT-F9 while the picture is selected. Now you
>can read up that field in Word's help, too.

Once I've got the picture in there and Shift-F9d it, I get:

{ INCLUDEPICTURE "M:\\test\\1.JPG" \d }

When I manually update the text so 1 become 2 or 3 or 4.. It does not
change the picture. (1, 2, 3, 4.JPG all exist.)

Is there a way to manually change the link so it points to the correct
file?

Suzanne S. Barnhill

unread,

Nov 23, 2005, 6:20:45 PM11/23/05

to

Are you pressing F9 to update the field after you edit it?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Barry S." <nn...@spamsack.org> wrote in message

news:3hs9o1punqr29edo8...@4ax.com...

Barry S.

unread,

Nov 23, 2005, 9:10:30 PM11/23/05

to

On Wed, 23 Nov 2005 17:20:45 -0600, "Suzanne S. Barnhill"
<sbar...@mvps.org> wrote:

>Are you pressing F9 to update the field after you edit it?

No, but that seems to help though..

Thank you.

unread,

Nov 25, 2005, 10:47:38 AM11/25/05

to

FWIW, the field code I'm using is this:

{ INCLUDEPICTURE "C:\\Documents and Settings\\Suzanne S. Barnhill\\My
Documents\\My Pictures\\Rotary\\Member Photos\\{ IF { MERGEFIELD Photo } =
"" "No Photo" "{ MERGEFIELD Photo }" }.JPG" \d }

I'm inserting it into a table cell with exact height and preferred width.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Barry S." <nn...@spamsack.org> wrote in message

news:bu8do1l4g4sqli4ao...@4ax.com...

jay m

unread,

Nov 28, 2005, 12:15:00 PM11/28/05

to

It seems to just come in as default when linked.
You format the pic for desired size, but it seems to revert when you
change the source or update it.
Maybe use a quick VBA routine to update and resize the pics?
here's my field contents:
{ INCLUDEPICTURE "C:\\Documents and Settings\\jm065225\\My
Documents\\My Pictures\\1.bmp" \* MERGEFORMAT \d }

Jay

Barry S.

unread,

Dec 3, 2005, 11:05:53 PM12/3/05

to

On 28 Nov 2005 09:15:00 -0800, "jay m" <jays...@covad.net> wrote:

>It seems to just come in as default when linked.
>You format the pic for desired size, but it seems to revert when you
>change the source or update it.

That sounds like what is happening.

>Maybe use a quick VBA routine to update and resize the pics?
>here's my field contents:

Hmm, I only want them to resize to fill the table cell on a document
that gets edited every week. I suspect it retains some sort of
formatting when I do an insert picture, but I lose it when I try to do
an IncludePicture..

I'm not looking to change the actual size of the picuture.. (Eg. Not
go from 1600x1200 to 640x480) So the change is a formatting only
change. Is there some sort of VBA script that will change the
formatting only in the document?

>{ INCLUDEPICTURE "C:\\Documents and Settings\\jm065225\\My
>Documents\\My Pictures\\1.bmp" \* MERGEFORMAT \d }

Which is basically what I have..

Barry S.

unread,

Dec 4, 2005, 3:34:46 AM12/4/05

to

On Sat, 03 Dec 2005 21:05:53 -0700, Barry S. <nn...@spamsack.org>
wrote:

>On 28 Nov 2005 09:15:00 -0800, "jay m" <jays...@covad.net> wrote:

>
>>It seems to just come in as default when linked.
>>You format the pic for desired size, but it seems to revert when you
>>change the source or update it.
>
>That sounds like what is happening.

Decided to record some macros tonight to see what I had..

Sub Macro1()
'
' Macro1 Macro
'
InlineShapes.AddPicture FileName:= _
"C:\test\test.JPG", LinkToFile:=True _
, SaveWithDocument:=True
End Sub

All desired formatting was retained.. Is there a way to type the VBA
directly into a table cell?

jay m

unread,

Dec 5, 2005, 7:13:02 PM12/5/05

to

Check the Word MVPs FAQ-
I know you can create a button or other control linked to a macro.
Maybe there's a better way.