Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Importing variable images into a mail merge
Using Word and Excel 2003, I need to import a number of different jpeg files
into the mail merge. Ideally the image would be a field and then linked into the main document. Is this possible, or alternatively could Access be used for the same purpose? If the latter, how do you place a jpeg file in Access, to pull through into a Word document? Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Importing variable images into a mail merge
Save each jpg as a separate file with a pathname that can be constructed
from data in your Excel sheet. e.g. if all your jpgs are in c:\myjpegs\ then you can put the file name (mypic1.jpg etc.) for each image in a column in the appropriate row in Excel. Let's call the column "jpgfile" Then use the following nested Word fields in your Mail Merge Main Document: { INCLUDEPICTURE "c:\\myjpegs\\{ MERGEFIELD jpgfile }" } (all the {} have to be the special field codes you can enter using ctrl-F9. notice that the folder pathname backslashes are doubled up. Ensure you don't have any spaces that should not be in the full path name of the file) Merge to a new output document, select it (e.g. ctrl-A) and press F9 to update all the images. -- Peter Jamieson http://tips.pjmsn.me.uk "McFox" wrote in message ... Using Word and Excel 2003, I need to import a number of different jpeg files into the mail merge. Ideally the image would be a field and then linked into the main document. Is this possible, or alternatively could Access be used for the same purpose? If the latter, how do you place a jpeg file in Access, to pull through into a Word document? Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge into columns with variable length data? | Page Layout | |||
Inserting variable images into a mail merge | Mailmerge | |||
Mail Merge with variable lines per page | Mailmerge | |||
Mail Merge with variable lines per page | Microsoft Word Help | |||
Mail Merge - importing documents | Microsoft Word Help |