#1
|
|||
|
|||
Inserting a clipart to mail merge
I may have asked this before but I am still no nearer an answer. I have an excel database which I use to create labels with mail merge. I need to add little cliparts/photos to each row of data in the excel database so they appear on the labels but a clipart/photo is not recognised in a cell like a number or text is. How do I add cliparts/photos, some may be different for each row of data? Thanks. |
#2
|
||||
|
||||
In Excel, you need to have not the images, but their filenames (and, depending on your mailmerge approach), filepaths. You can then use the technique outlined here:
https://www.msofficeforums.com/mail-...els-excel.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
That link you provided has gone way over my head, I may have to forget this one.
|
#4
|
||||
|
||||
It's not that difficult - it just requires some care and patience.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
It is if you dont understand it and dont know where to start! I have an excel sheet with 4-5 columns of data, which will be 4-5 different fields on the labels. The little pictures are .pcx extensions. Could you talk me through it in laymens terms please? Thanks.
|
#6
|
||||
|
||||
In your Excel workbook, instead of (or as well as) the pictures, insert their filenames.
Then, in Word, insert a field coded as: {IF {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"} \d} {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"} \d}} where 'C:\Users\My Document Path\Pictures' is the path to those pictures and '«Image»' is a mergefield that points to whatever name you give the heading row that contains the image filenames. The filepath is probably something like: C:\Program Files\Microsoft Office\MEDIA\CAGCAT10 You can find the correct path for a given image via Insert|Clipart, selecting an image then choosing 'Properties'. If the images are in a variety of different folders, you'll need to add the filepaths to Excel as well. If you add them to the same cells that contain the filenames, the field construction in Word can be simplified to: {IF {INCLUDEPICTURE {IF TRUE «Image»} \d} {INCLUDEPICTURE {IF TRUE «Image»} \d}} If, however, you put the filepaths in a separate column, you'll need a field construction like: {IF {INCLUDEPICTURE {IF TRUE "«FilePath»\«Image»"} \d} {INCLUDEPICTURE {IF TRUE "«FilePath»\«Image»"} \d}} Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Quote:
|
#8
|
||||
|
||||
Each row in your data file needs to have the filename for the picture that row refers to. If you have more than one picture, you need to have a separate column with the name (and path, if they're not all the same) for each picture.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Ok then could you tell me what to put in a cell if the picture is in C:\Documents and Settings\MANAGER\Desktop\New folder and is called edp1058.pcx for example.
|
#10
|
||||
|
||||
In that case, if all your images are in 'C:\Documents and Settings\MANAGER\Desktop\New folder', In Excel you'd use:
C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx and, in the Word document, the third version of the field coding from my last post: {IF {INCLUDEPICTURE {IF TRUE «Image»} \d} {INCLUDEPICTURE {IF TRUE «Image»} \d}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Ok I think I got the first part but not the second 'and, in the Word document, the third version of the field coding from my last post:
{IF {INCLUDEPICTURE {IF TRUE «Image»} \d} {INCLUDEPICTURE {IF TRUE «Image»} \d}}' how do I put this in using the mail merge wizard? |
#12
|
||||
|
||||
Quote:
{IF {INCLUDEPICTURE {IF TRUE } \d} } After the 'IF TRUE ' use the mail merge wizard to insert the first «Image» field. you should now have: {IF {INCLUDEPICTURE {IF TRUE «Image»} \d} } Now move the cursor to the left of the last '}' and press Ctrl-F9 twice more, so that you get: {IF {INCLUDEPICTURE {IF TRUE «Image»} \d} { { } }} Complete the in-filling as already described. Note: At a minimum you should end up with the following spacing in the field code: {IF {INCLUDEPICTURE {IF TRUE «Image»} \d} {INCLUDEPICTURE {IF TRUE «Image»} \d}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
I have put a part number into excel in column A then in column B put C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx
I shut down then opened word and did the merge but when I went to print preview there was no picture just the wording C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx |
#14
|
||||
|
||||
That suggests you have an «Image» field that is outside the field code described above. As for the lack of a picture, unless you've managed to not implement the field code correctly, that suggests either your picture name and/or the file path is not what the "C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx" string points to.
Press Alt-F9 to toggle the field code display and confirm that it is exactly as described.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#15
|
|||
|
|||
Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
From a beginner: Mail Merge using Windows Mail | mhalpern705 | Mail Merge | 3 | 12-16-2011 04:58 AM |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
Inserting pages at the end of a mail merge | morten_lysgaard | Mail Merge | 3 | 07-25-2011 11:19 PM |
Inserting images into mail merge | lorraine_hamilton | Mail Merge | 0 | 10-19-2009 09:55 AM |