If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging Picture with Mail Merge
I am creating a phone book/directory for my church. I have created an
Excel spreadsheet with all the information I need, including a column which contains the path to the location of a picture (jpeg) of the individual/family. I can get all of the fields correctly except for the photo. This is what I have done: { INCLUDEPICTURE "/Users/my/path/to/{ MERGEFIELD Photo}" \* MERGEFORMAT } I have also tried: { INCLUDEPICTURE "Macintosh HD:Users:myath:to:{ MERGEFIELD Photo}" \* MERGEFORMAT } Neither of the above worked. I get the following when merge the data: { INCLUDEPICTURE "/Users/my/path/to/Picture.jpg" \* MERGEFORMAT } or the same with ":" between the directories. I have tried updating the fields by pressing "F9", but that didn't change anything. I am using Word and Excel 2004 for Macintosh. I was told there are some really great experts on this mailing list that would be able to solve the problem. Can anyone help me? Thanks, Jeremy |
#2
|
|||
|
|||
Merging Picture with Mail Merge
Jeremy: Perhaps you only need to STOP viewing field codes? Tools--Options,
View tab and uncheck field codes. For Mac, it's probably File--Preferences... something. I forget. ************ Anne Troy www.OfficeArticles.com wrote in message ups.com... I am creating a phone book/directory for my church. I have created an Excel spreadsheet with all the information I need, including a column which contains the path to the location of a picture (jpeg) of the individual/family. I can get all of the fields correctly except for the photo. This is what I have done: { INCLUDEPICTURE "/Users/my/path/to/{ MERGEFIELD Photo}" \* MERGEFORMAT } I have also tried: { INCLUDEPICTURE "Macintosh HD:Users:myath:to:{ MERGEFIELD Photo}" \* MERGEFORMAT } Neither of the above worked. I get the following when merge the data: { INCLUDEPICTURE "/Users/my/path/to/Picture.jpg" \* MERGEFORMAT } or the same with ":" between the directories. I have tried updating the fields by pressing "F9", but that didn't change anything. I am using Word and Excel 2004 for Macintosh. I was told there are some really great experts on this mailing list that would be able to solve the problem. Can anyone help me? Thanks, Jeremy |
#3
|
|||
|
|||
Merging Picture with Mail Merge
Nope that doesn't help. Now I just get:
Error! Filename not specified. Any other ideas? Thanks, Jeremy |
#5
|
|||
|
|||
Merging Picture with Mail Merge
I have asked in the Mac group, and they gave me the suggestions I
tried. But they didn't work. They told me to ask Cindy, an MVP specializing in mail merges on this list and she would know the answer even though I am on my Mac. Thanks, Jeremy |
#6
|
|||
|
|||
Merging Picture with Mail Merge
Cindy has not been dropping in so often recently.
Try the following: In a plain document Insert field includepicture and insert the path and filename you want to insert into the appropriate box. Insert the field and toggle the display to see the construction. Use that syntax in your merge document, substituting your mergefield for the appropriate part of the filename. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote: I have asked in the Mac group, and they gave me the suggestions I tried. But they didn't work. They told me to ask Cindy, an MVP specializing in mail merges on this list and she would know the answer even though I am on my Mac. Thanks, Jeremy |
#7
|
|||
|
|||
Merging Picture with Mail Merge
Graham,
I did what you said and was able to see a picture. I found out you have to escape the directory delimiters in the file path. Doing your suggestion made me understand the format for the INCLUDEPICTURE merge. Then I tried merging all of the pictures. In the merged document, all of the file paths were there and when I said "Toggle Field Codes", they all changed to a picture, but they all changed to the SAME picture. Every picture shown was the first picture in the list. I wonder if the INCLUDEPICTURE field doesn't get reset between entries? Does any of this make sense? Thanks for all your help. Jeremy |
#8
|
|||
|
|||
Merging Picture with Mail Merge
All changing to the same picture is normal as the field conversion is a two
stage process and not automatic. Merge to a new document and then select all Ctrl+A and update F9 to show the correct images. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote: Graham, I did what you said and was able to see a picture. I found out you have to escape the directory delimiters in the file path. Doing your suggestion made me understand the format for the INCLUDEPICTURE merge. Then I tried merging all of the pictures. In the merged document, all of the file paths were there and when I said "Toggle Field Codes", they all changed to a picture, but they all changed to the SAME picture. Every picture shown was the first picture in the list. I wonder if the INCLUDEPICTURE field doesn't get reset between entries? Does any of this make sense? Thanks for all your help. Jeremy |
#9
|
|||
|
|||
Merging Picture with Mail Merge
Graham (and others),
Sounded like a good idea; however when I update, the pictures (of the same person) disappear and a blank space is left. I can click on the blank space and it acts like a picture, but it doesn't display a picture. Does this seem as strange to you as it does for me? Thanks, Jeremy |
#10
|
|||
|
|||
Merging Picture with Mail Merge
I don't know about the inner workings of Mac Word but see if tools options
view picture placeholders is now checked. It shouldn't be! Toggle the display with ALT+F9 to see if the correct filenames are in place. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote: Graham (and others), Sounded like a good idea; however when I update, the pictures (of the same person) disappear and a blank space is left. I can click on the blank space and it acts like a picture, but it doesn't display a picture. Does this seem as strange to you as it does for me? Thanks, Jeremy |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
NO CODE - mail merge to Outlook with attachment with CC | GillianHG | Mailmerge | 3 | February 10th, 2010 02:53 PM |
Embed picture in excel mail merge into word? | Donna | General Discussion | 1 | March 29th, 2005 10:45 PM |
Mail Merge picture in label | TomC | Setting Up & Running Reports | 4 | March 3rd, 2005 12:59 AM |
Mail merge conversion from Word to .NET code. | mutton | Mailmerge | 1 | November 17th, 2004 02:09 AM |
Lost mail merge capability after copying | Boog | Mailmerge | 1 | November 16th, 2004 05:40 PM |