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

Tip: Looking for answers? Try searching our database.

Posting Photos

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 15 Jan 2006 14:41 GMT
I need help in inserting photos into a mail merged documents.
I have a multi page mailmerge Word document that I would like to insert
photos into several different pages.
I am using excel to store my data on each student and a file folder with all
student folders. Each photo is given a file number such as "tray1234IMGo1" I
show this file number in the Excel worksheet.
Many thanks for any help!
GTS - 15 Jan 2006 20:01 GMT
> I need help in inserting photos into a mail merged documents.
> I have a multi page mailmerge Word document that I would like to insert
[quoted text clipped - 3 lines]
> show this file number in the Excel worksheet.
> Many thanks for any help!
You can use an Includepicture field to add photos. The photo file name is
the file number mergefield:

{ INCLUDEPICTURE "C:\\PICTURES\\{ MERGEFIELD FILENUMBER }.jpg" }

However this assumes that all pictures are in one folder ( PICTURES). If the
student folders are all named the same as the file numbers you could try
using the same file number in the path but no idea if it would work:

{ INCLUDEPICTURE "C:\\FILE FOLDER\\{ MERGEFIELD FILENUMBER }\\{ MERGEFIELD
FILENUMBER }.jpg" }

The curly braces are added using CTRL-F9 if hand-typing the above.
Alternatively use insert to insert a linked picture and replace the file
name with your mergefield thus:

"INCLUDEPICTURE "FileName" [Switches ] }
Inserts the specified graphic.

To insert an INCLUDEPICTURE field, point to Picture on the Insert menu,
click From File, click the arrow next to the Insert button, and then click
Link to File"
Graham Mayor - 16 Jan 2006 06:55 GMT
See http://www.gmayor.com/mail_merge_graphics.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> I need help in inserting photos into a mail merged documents.
> I have a multi page mailmerge Word document that I would like to
[quoted text clipped - 3 lines]
> "tray1234IMGo1" I show this file number in the Excel worksheet.
> Many thanks for any help!
Dave - 16 Jan 2006 16:47 GMT
I thank you for your direction and assistance, however I am still having a
problem getting it to work.

Here is what I ended up with:
{INCLUDEPICTURE "d:my documents\my data sources\cadet photos\{MERGEFIELD
"Photo_ID"}}

All the student photos are stored in the "cadet photos" file and the file
names are shown in my exel spreadsheet under the column headed "Photo ID"

Any other help will be appreciated.

> See http://www.gmayor.com/mail_merge_graphics.htm
>
[quoted text clipped - 5 lines]
> > "tray1234IMGo1" I show this file number in the Excel worksheet.
> > Many thanks for any help!
Graham Mayor - 17 Jan 2006 07:43 GMT
The correct syntax would be
{INCLUDEPICTURE "d:\\my documents\\my data sources\\cadet
photos\\{MERGEFIELD
"Photo_ID"}"}
assuming the path to the files is correct. If the Photo_ID field does not
contain the full filename with extension, you will have to add the extension
also, eg:
{INCLUDEPICTURE "d:\\my documents\\my data sources\\cadet
photos\\{MERGEFIELD
"Photo_ID"}.jpg"}
Merge to a new document, select all (CTRL+A) then F9 to update.
Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> I thank you for your direction and assistance, however I am still
> having a problem getting it to work.
[quoted text clipped - 26 lines]
>>> "tray1234IMGo1" I show this file number in the Excel worksheet.
>>> Many thanks for any 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.