Reply
 
Thread Tools Display Modes
  #1   Report Post  
Thomson Ncube
 
Posts: n/a
Default How do I use mail merge?

I need to have jpeg photos inserted through mail merge for each page that
contains specific details which will be merged in word from an excel database.
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

Do you mean that you want a different jpeg for each record in Excel? If so,
let's suppose your Excel sheet hasa a column called picturefile with the
file name (say, mypicture.jpg) and that all the files are in a folde called
c:\mypictures. Then insert the following nested field in your Word mail
merge main document:

{ INCLUDEPICTURE "c:\\mypictures\\{ MERGEFIELD "picturefile" }" }

(You need to use e.g. ctrl-F9 to insert the special field braces {} )

You may need to check Tools|Options|Print|Update links and/or Update fields,
and if you are outputting to a new document you may need to select the
entire document (e.g. ctrl-A) and press F9 to update all the fields after
the merge.

Peter Jamieson

"Thomson Ncube" Thomson wrote in message
...
I need to have jpeg photos inserted through mail merge for each page that
contains specific details which will be merged in word from an excel
database.



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
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 01:31 PM


All times are GMT +1. The time now is 05:00 AM.

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"