[Colonel Blip]

Hello, All!

I am creating a picture directory using Outlook and mail merge. I have all
of the pictures available on my hard drive so I can do the mail merge and
then insert the respective picture for each directory entry. However, it
would be nice if the MM feature from OL supported the graphic in the OL
Contacts. Maybe it does and I haven't discovered how. So this prompts 2
questions:

1. Is there a way to mail merge the picture in each contact entry along with
the other pertinent name/address/etc.?

2. Assuming there is not and I have to insert individual pictures into the
finalized mail merge I have a different issue. I have to resize every
individual picture after I insert it into Word. Is there a way to set up
Word where the insert will be automatically sized to a predetermined size?

Thanks,
Colonel Blip.
E-mail:

[Graham Mayor]

You can't insert the graphic from the Outlook database, but if you have the
graphics named appropriately you can merge them from the hard drive - see
http://www.gmayor.com/mail_merge_graphics.htm

As for sizing, merge them into a fixed width table cell (without border?).
The graphic will adapt to the width of that cell (provided the graphic is
larger than the cell).

--

Graham Mayor - Word MVP

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


Colonel Blip wrote:
Hello, All!

I am creating a picture directory using Outlook and mail merge. I
have all of the pictures available on my hard drive so I can do the
mail merge and then insert the respective picture for each directory
entry. However, it would be nice if the MM feature from OL supported
the graphic in the OL Contacts. Maybe it does and I haven't
discovered how. So this prompts 2 questions:

1. Is there a way to mail merge the picture in each contact entry
along with the other pertinent name/address/etc.?

2. Assuming there is not and I have to insert individual pictures
into the finalized mail merge I have a different issue. I have to
resize every individual picture after I insert it into Word. Is there
a way to set up Word where the insert will be automatically sized to
a predetermined size?
Thanks,
Colonel Blip.
E-mail:

[Colonel Blip]

Hello, Graham!
You wrote on Fri, 25 Aug 2006 16:14:24 +0300:




Graham,



As far as I can tell I followed the web site info but for some reason the
photo is not being picked up. If I just use the {mergefield "Last_Name"} in
the table it works fine to show the last name of my directory entry.
However, the picture is not being picked up. I have to send a screen print
since I can't figure out how to copy the codes and paste them (altho I'm
sure there is a way). BTW, I've tried both \\ and \ in the path with the
same results. Can you see what might be wrong from this?


Thanks,

Colonel Blip.
E-mail:


GM You can't insert the graphic from the Outlook database, but if you have
GM the graphics named appropriately you can merge them from the hard drive
GM - see http://www.gmayor.com/mail_merge_graphics.htm

GM As for sizing, merge them into a fixed width table cell (without
GM border?). The graphic will adapt to the width of that cell (provided
GM the graphic is larger than the cell).

[Graham Mayor]

Assuming the picture is named according to the content of the last_name
field eg Smith and is stored in the folder O:\TEMP, then for Smith.jpg, the
syntax that is required is:

{INCLUDEPICTURE "O:\\TEMP\\{Mergefield "Last_Name"}.JPG"}
or
{INCLUDEPICTURE "O:/TEMP/{Mergefield "Last_Name"}.JPG"}

The quotes around Last_Name are optional.

You must merge to a new document then select all (CTRL+A) and update (F9) of
use the update macro at http://www.gmayor.com/installing_macro.htm

Please do not post attachments, only those of us who access via NNTP will
even have the opportunity to see them and that is severely discouraged in
text based news groups. If you want to reproduce field constructions in a
message, use the macro at http://www.gmayor.com/export_field.htm

--

Graham Mayor - Word MVP

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



Colonel Blip wrote:
Hello, Graham!
You wrote on Fri, 25 Aug 2006 16:14:24 +0300:




Graham,



As far as I can tell I followed the web site info but for some reason
the photo is not being picked up. If I just use the {mergefield
"Last_Name"} in the table it works fine to show the last name of my
directory entry. However, the picture is not being picked up. I have
to send a screen print since I can't figure out how to copy the codes
and paste them (altho I'm sure there is a way). BTW, I've tried both
\\ and \ in the path with the same results. Can you see what might be
wrong from this?

Thanks,

Colonel Blip.
E-mail:


You can't insert the graphic from the Outlook database, but if you
have the graphics named appropriately you can merge them from the
hard drive - see http://www.gmayor.com/mail_merge_graphics.htm

As for sizing, merge them into a fixed width table cell (without
border?). The graphic will adapt to the width of that cell (provided
the graphic is larger than the cell).

[Colonel Blip]

Hello, Graham!
You wrote on Sun, 27 Aug 2006 08:57:48 +0300:

Thanks on both counts. I think I was missing the update (F9) part and should
have known better. Working now.

Thanks again,

Colonel Blip.
E-mail:

GM Assuming the picture is named according to the content of the last_name
GM field eg Smith and is stored in the folder O:\TEMP, then for Smith.jpg,
GM the syntax that is required is:

GM {INCLUDEPICTURE "O:\\TEMP\\{Mergefield "Last_Name"}.JPG"}
GM or
GM {INCLUDEPICTURE "O:/TEMP/{Mergefield "Last_Name"}.JPG"}

GM The quotes around Last_Name are optional.

GM You must merge to a new document then select all (CTRL+A) and update
GM (F9) of use the update macro at
http://www.gmayor.com/installing_macro.htm

GM Please do not post attachments, only those of us who access via NNTP
GM will even have the opportunity to see them and that is severely
GM discouraged in text based news groups. If you want to reproduce field
GM constructions in a message, use the macro at
http://www.gmayor.com/export_field.htm

[Graham Mayor]

It is clearly stated in the linked article
However a graphic contained in the original page has not reproduced. I have
now reinserted the image and hopefully the link should now be even clearer?
It is uploading now.
--

Graham Mayor - Word MVP

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


Colonel Blip wrote:
Hello, Graham!
You wrote on Sun, 27 Aug 2006 08:57:48 +0300:

Thanks on both counts. I think I was missing the update (F9) part and
should have known better. Working now.

Thanks again,

Colonel Blip.
E-mail:

Assuming the picture is named according to the content of the
last_name field eg Smith and is stored in the folder O:\TEMP, then
for Smith.jpg, the syntax that is required is:

{INCLUDEPICTURE "O:\\TEMP\\{Mergefield "Last_Name"}.JPG"}
or
{INCLUDEPICTURE "O:/TEMP/{Mergefield "Last_Name"}.JPG"}

The quotes around Last_Name are optional.

You must merge to a new document then select all (CTRL+A) and update
(F9) of use the update macro at
http://www.gmayor.com/installing_macro.htm

Please do not post attachments, only those of us who access via NNTP
will even have the opportunity to see them and that is severely
discouraged in text based news groups. If you want to reproduce field
constructions in a message, use the macro at
http://www.gmayor.com/export_field.htm

[Colonel Blip]

Hello, Graham!
You wrote on Mon, 28 Aug 2006 09:26:41 +0300:

It was indeed and I have some other forms that I update every week with
Ctrl-A, F9. I was just so focussed on the right code that I missed (or
ignored) other instructions.

Thanks,

Colonel Blip.
E-mail:

GM It is clearly stated in the linked article
GM However a graphic contained in the original page has not reproduced. I
GM have now reinserted the image and hopefully the link should now be even
GM clearer? It is uploading now.
GM --
GM
GM Graham Mayor - Word MVP

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

GM Colonel Blip wrote:
?? Hello, Graham!

[Graham Mayor]

If you hadn't raised the question, I wouldn't have rechecked my web page and
discovered the missing graphic

--

Graham Mayor - Word MVP

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


Colonel Blip wrote:
Hello, Graham!
You wrote on Mon, 28 Aug 2006 09:26:41 +0300:

It was indeed and I have some other forms that I update every week
with Ctrl-A, F9. I was just so focussed on the right code that I
missed (or ignored) other instructions.

Thanks,

Colonel Blip.
E-mail:

It is clearly stated in the linked article
However a graphic contained in the original page has not reproduced.
I have now reinserted the image and hopefully the link should now be
even clearer? It is uploading now.
--

Graham Mayor - Word MVP

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


Colonel Blip wrote:
Hello, Graham!