Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Alan - Love in Action, Uganda
 
Posts: n/a
Default How do I insert pictures into mail merge doc from a database filen

I have an access database with names & addresses and a field with the
filename of a picture. I want to send a mail merge letter to everyone by
email with each seeing the picture whose file name is in the database. Can
this be done?
Thanks

I am using Office 2003
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default How do I insert pictures into mail merge doc from a database filen

It is usually feasible as long as Word knows how to insert the type of
picture you have (.jpg etc.), but there are often problems.

To insert the picture, try using a nested INCLUDEPICTURE field such as

{ INCLUDEPICTURE "{ MERGEFIELD picturefilename }" }

where picturefilename is the field containing the picture file name, and the
{} are inserted using ctrl-F9.

You may also need to
a. double up the backslashes in the picture path names in your database
(although off the top of my head, I don't think you do)
b. check Word Tools|Options|Print|Update Links/Update fields
c. uncheck Word Tools|Options|general|Web options|Files|Update links on
save
d. use the \d switch, and possibly the graphic converter switch in the
INCLUDEPICTURE field (see Word help for details)

Peter Jamieson
"Alan - Love in Action, Uganda" Alan - Love in Action,
wrote in message
news
I have an access database with names & addresses and a field with the
filename of a picture. I want to send a mail merge letter to everyone by
email with each seeing the picture whose file name is in the database. Can
this be done?
Thanks

I am using Office 2003


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 02:53 PM
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
Mail Merge - Parameter prompts twice... TL Mailmerge 6 June 17th 05 02:58 PM
Problem with mail merge and works database techman Mailmerge 2 December 1st 04 04:47 PM
Word mail merge doesn't pick up the addresses in Access database. Julie Tables 1 November 24th 04 01:26 AM


All times are GMT +1. The time now is 02:03 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"