Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Help: Using Includepicture to display graphics in mail merges
Here is the situation:
I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture €ś{image}€ť} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture €śimage€ť}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point Im losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isnt a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? -- Michael Weber |
#2
|
|||
|
|||
Did you use Ctrl+F9 to insert the field delimiters { }?
Have you tried doing a Ctrl+a (select all) and then F9 (update fields) on the document created by executing the merge. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael Weber" wrote in message ... Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? -- Michael Weber |
#3
|
|||
|
|||
Hi Michael,
The correct syntax would be: {INCLUDEPICTURE "{MAILMERGE ImageName}"} where the field braces (i.e. '{ }') are created in pairs via Ctrl-F9 and ImageName represents the full image path (including the drive), plus the filename and extension. If Excel only holds the filename and extension, you'd express the field as: {INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}"} or {INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}.jpg"} if Excel only holds the filename. Use your own drive and path, of course, with *double* backslashes as separators (though you can use single forward slashes instead) and, in the last example, specifying the file type. Cheers "Michael Weber" wrote in message ... Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? -- Michael Weber |
#4
|
|||
|
|||
See http://www.gmayor.com/mail_merge_graphics.htm which explains how to do
this. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael Weber wrote: Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? |
#5
|
|||
|
|||
Mailmerge? You mean Mergefield
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Michael, The correct syntax would be: {INCLUDEPICTURE "{MAILMERGE ImageName}"} where the field braces (i.e. '{ }') are created in pairs via Ctrl-F9 and ImageName represents the full image path (including the drive), plus the filename and extension. If Excel only holds the filename and extension, you'd express the field as: {INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}"} or {INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}.jpg"} if Excel only holds the filename. Use your own drive and path, of course, with *double* backslashes as separators (though you can use single forward slashes instead) and, in the last example, specifying the file type. Cheers "Michael Weber" wrote in message ... Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? -- Michael Weber |
#6
|
|||
|
|||
Thanks for the help. I did follow the instructions at the site prior to posting a note here. It appears my problem stems from the use of a test box to display the image in. Once I formatted the document to not use a test box for the image location I was able to get it working just fine. Does anyone have advice on how to get this working inside a text box so I can have finer control of the location of the graphic? Thanks again! -- Michael Weber "Graham Mayor" wrote: See http://www.gmayor.com/mail_merge_graphics.htm which explains how to do this. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael Weber wrote: Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? |
#7
|
|||
|
|||
Use a table cell instead. Text boxes are not in the text plane of the
document and so fields they contain are problematical. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael Weber wrote: Thanks for the help. I did follow the instructions at the site prior to posting a note here. It appears my problem stems from the use of a test box to display the image in. Once I formatted the document to not use a test box for the image location I was able to get it working just fine. Does anyone have advice on how to get this working inside a text box so I can have finer control of the location of the graphic? Thanks again! See http://www.gmayor.com/mail_merge_graphics.htm which explains how to do this. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael Weber wrote: Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? |
#8
|
|||
|
|||
touché!
"Graham Mayor" wrote in message ... Mailmerge? You mean Mergefield -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Michael, The correct syntax would be: {INCLUDEPICTURE "{MAILMERGE ImageName}"} where the field braces (i.e. '{ }') are created in pairs via Ctrl-F9 and ImageName represents the full image path (including the drive), plus the filename and extension. If Excel only holds the filename and extension, you'd express the field as: {INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}"} or {INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}.jpg"} if Excel only holds the filename. Use your own drive and path, of course, with *double* backslashes as separators (though you can use single forward slashes instead) and, in the last example, specifying the file type. Cheers "Michael Weber" wrote in message ... Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? -- Michael Weber |
#9
|
|||
|
|||
Tables worked like a charm. Thanks! -- Michael Weber "Graham Mayor" wrote: Use a table cell instead. Text boxes are not in the text plane of the document and so fields they contain are problematical. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael Weber wrote: Thanks for the help. I did follow the instructions at the site prior to posting a note here. It appears my problem stems from the use of a test box to display the image in. Once I formatted the document to not use a test box for the image location I was able to get it working just fine. Does anyone have advice on how to get this working inside a text box so I can have finer control of the location of the graphic? Thanks again! See http://www.gmayor.com/mail_merge_graphics.htm which explains how to do this. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Michael Weber wrote: Here is the situation: I have an Excel worksheet as the data source and have a Word merge document to display the information. We have just added some renders of the items and I would like to add the graphics to the word merge document. I have tried to use the {includepicture "{image}"} command to display the images at the paths specified in the Excel worksheet but have had no luck in doing so. The command I am using is: {includepicture "image"}. The image field in the Excel sheet has a full path to the filename (c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it simply deletes the command in my merge template. I have followed the instructions in both of the primers that are commonly cited and have finally hit my frustration level. At this point I'm losing time trying to get this working and would have been better off actually typing the documents by hand and pasting in the photos. Of course that isn't a scalable solution like that one I envision and I would like to get this working. Does anyone have any suggestions? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphic display in word | Microsoft Word Help | |||
Nested IncludePicture troubles in header table | Page Layout | |||
WORD 2002 will not display ASPX clip files. | Microsoft Word Help | |||
Different graphic for each record | Mailmerge | |||
Unchecking 'different first page' in header removes graphic from first page | Page Layout |