Linking to Photos

154 views
Skip to first unread message

PeterM

unread,
Nov 7, 2002, 10:12:58 PM11/7/02
to
Can anyone please help. I want to use excel as data for a mail merge
document, however on of the fields is a photo. Can I link a photo file
to the excell field so it fills the merge document with the photo.

Many Thanks

Debra Dalgleish

unread,
Nov 8, 2002, 11:08:23 PM11/8/02
to
1. In Excel, include the full path to the picture, and use double
slashes, e.g.: c:\\Data\\myphoto.jpg

2. In Word, use the Insert Merge Field menu to insert all the merge
fields in the Main Document, including the photo field.

3. To view the field codes, press Alt+F9

4. Position the cursor outside the photo field brackets.

5. To insert a new set of field brackets, press Ctrl+F9

6. Inside the brackets, type INCLUDEPICTURE ""

7. Select the photo field, including the field brackets.

8. Drag the photo field inside the quotation marks, e.g.:
{ INCLUDEPICTURE "{MERGEFIELD Photo}" }

9. To hide the field codes, press Alt +F9

10. Save the main document, and merge to a new document.

11. In the new document, press Ctrl+A to select all.

12. Press F9 to update the fields.

As you scroll through the document, you should see the merged data,
including the pictures.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

David McRitchie

unread,
Nov 9, 2002, 7:47:56 AM11/9/02
to
Hi Peter,
Basically same as Debra but with pictorial examples of Excel spreadsheet,
and resulting word document as a picture catalog, with a little more explanation.
Merge Pictures and Words - Oh My!, Cindy Meister (Word)
http://www.computorcompanion.com/LMMArticle.asp?ID=126

What do you mean by "fills the merge document with a photo", do
you perhaps mean like a watermark background for each page.

Q285055 - HOW TO: Create Watermarks in Word 2002
... For more information about how to add a watermark to a document, click Microsoft
Word Help on the Help menu, type add a background or watermark in the Office ...
http://support.microsoft.com/support/ kb/articles/Q285/0/55.ASP
http://support.microsoft.com/support/ kb/articles/Q211/3/24.ASP

MS KB is being flakey, the above links may not work, and neither are the following,
try again on Monday. One billions links from web pages and search engines like
the above will fail between now and two years from now.

http://support.microsoft.com/default.aspx?scid=kb;en-us;285055
http://support.microsoft.com/default.aspx?scid=kb;en-us;211324

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Debra Dalgleish" <d...@contextures.com> wrote ...
[clipped]

David McRitchie

unread,
Nov 9, 2002, 7:53:12 AM11/9/02
to
Hi Peter,
Basically same as Debra but with pictorial examples of Excel spreadsheet,
and resulting word document as a picture catalog, with a little more explanation.
Merge Pictures and Words - Oh My!, Cindy Meister (Word)
http://www.computorcompanion.com/LMMArticle.asp?ID=126

What do you mean by "fills the merge document with a photo", do
you perhaps mean like a watermark background for each page.

Q285055 - HOW TO: Create Watermarks in Word 2002
... For more information about how to add a watermark to a document, click Microsoft
Word Help on the Help menu, type add a background or watermark in the Office ...
http://support.microsoft.com/support/ kb/articles/Q285/0/55.ASP
http://support.microsoft.com/support/ kb/articles/Q211/3/24.ASP

Failed with:
http://support.microsoft.com/common/errors/default.aspx?404;http://support.microsoft.com/support/%20kb/articles/Q285/0/55.ASP

MS KB is being flakey, the above links may not work, and neither are the following,
try again on Monday. One billions links from web pages and search engines like
the above will fail between now and two years from now.

These also fail resulting in
The Knowledge Base (KB) Article You Requested is Currently Not Available

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Debra Dalgleish" <d...@contextures.com> wrote ...
[clipped]

> PeterM wrote:

David McRitchie

unread,
Nov 9, 2002, 8:00:10 AM11/9/02
to
the first two had spaces in them but still fail with space removed
http://support.microsoft.com/support/kb/articles/Q285/0/55.ASP
http://support.microsoft.com/support/kb/articles/Q211/3/24.ASP

The first of the following appears to be working now.

Reply all
Reply to author
Forward
0 new messages