Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
Hello, All!
I am creating a picture directory using Outlook and mail merge. I have all of the pictures available on my hard drive so I can do the mail merge and then insert the respective picture for each directory entry. However, it would be nice if the MM feature from OL supported the graphic in the OL Contacts. Maybe it does and I haven't discovered how. So this prompts 2 questions: 1. Is there a way to mail merge the picture in each contact entry along with the other pertinent name/address/etc.? 2. Assuming there is not and I have to insert individual pictures into the finalized mail merge I have a different issue. I have to resize every individual picture after I insert it into Word. Is there a way to set up Word where the insert will be automatically sized to a predetermined size? Thanks, Colonel Blip. E-mail: |
#2
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
You can't insert the graphic from the Outlook database, but if you have the
graphics named appropriately you can merge them from the hard drive - see http://www.gmayor.com/mail_merge_graphics.htm As for sizing, merge them into a fixed width table cell (without border?). The graphic will adapt to the width of that cell (provided the graphic is larger than the cell). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Colonel Blip wrote: Hello, All! I am creating a picture directory using Outlook and mail merge. I have all of the pictures available on my hard drive so I can do the mail merge and then insert the respective picture for each directory entry. However, it would be nice if the MM feature from OL supported the graphic in the OL Contacts. Maybe it does and I haven't discovered how. So this prompts 2 questions: 1. Is there a way to mail merge the picture in each contact entry along with the other pertinent name/address/etc.? 2. Assuming there is not and I have to insert individual pictures into the finalized mail merge I have a different issue. I have to resize every individual picture after I insert it into Word. Is there a way to set up Word where the insert will be automatically sized to a predetermined size? Thanks, Colonel Blip. E-mail: |
#3
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
Hello, Graham!
You wrote on Fri, 25 Aug 2006 16:14:24 +0300: Graham, As far as I can tell I followed the web site info but for some reason the photo is not being picked up. If I just use the {mergefield "Last_Name"} in the table it works fine to show the last name of my directory entry. However, the picture is not being picked up. I have to send a screen print since I can't figure out how to copy the codes and paste them (altho I'm sure there is a way). BTW, I've tried both \\ and \ in the path with the same results. Can you see what might be wrong from this? Thanks, Colonel Blip. E-mail: GM You can't insert the graphic from the Outlook database, but if you have GM the graphics named appropriately you can merge them from the hard drive GM - see http://www.gmayor.com/mail_merge_graphics.htm GM As for sizing, merge them into a fixed width table cell (without GM border?). The graphic will adapt to the width of that cell (provided GM the graphic is larger than the cell). |
#4
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
Assuming the picture is named according to the content of the last_name
field eg Smith and is stored in the folder O:\TEMP, then for Smith.jpg, the syntax that is required is: {INCLUDEPICTURE "O:\\TEMP\\{Mergefield "Last_Name"}.JPG"} or {INCLUDEPICTURE "O:/TEMP/{Mergefield "Last_Name"}.JPG"} The quotes around Last_Name are optional. You must merge to a new document then select all (CTRL+A) and update (F9) of use the update macro at http://www.gmayor.com/installing_macro.htm Please do not post attachments, only those of us who access via NNTP will even have the opportunity to see them and that is severely discouraged in text based news groups. If you want to reproduce field constructions in a message, use the macro at http://www.gmayor.com/export_field.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Colonel Blip wrote: Hello, Graham! You wrote on Fri, 25 Aug 2006 16:14:24 +0300: Graham, As far as I can tell I followed the web site info but for some reason the photo is not being picked up. If I just use the {mergefield "Last_Name"} in the table it works fine to show the last name of my directory entry. However, the picture is not being picked up. I have to send a screen print since I can't figure out how to copy the codes and paste them (altho I'm sure there is a way). BTW, I've tried both \\ and \ in the path with the same results. Can you see what might be wrong from this? Thanks, Colonel Blip. E-mail: You can't insert the graphic from the Outlook database, but if you have the graphics named appropriately you can merge them from the hard drive - see http://www.gmayor.com/mail_merge_graphics.htm As for sizing, merge them into a fixed width table cell (without border?). The graphic will adapt to the width of that cell (provided the graphic is larger than the cell). |
#5
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
Hello, Graham!
You wrote on Sun, 27 Aug 2006 08:57:48 +0300: Thanks on both counts. I think I was missing the update (F9) part and should have known better. Working now. Thanks again, Colonel Blip. E-mail: GM Assuming the picture is named according to the content of the last_name GM field eg Smith and is stored in the folder O:\TEMP, then for Smith.jpg, GM the syntax that is required is: GM {INCLUDEPICTURE "O:\\TEMP\\{Mergefield "Last_Name"}.JPG"} GM or GM {INCLUDEPICTURE "O:/TEMP/{Mergefield "Last_Name"}.JPG"} GM The quotes around Last_Name are optional. GM You must merge to a new document then select all (CTRL+A) and update GM (F9) of use the update macro at http://www.gmayor.com/installing_macro.htm GM Please do not post attachments, only those of us who access via NNTP GM will even have the opportunity to see them and that is severely GM discouraged in text based news groups. If you want to reproduce field GM constructions in a message, use the macro at http://www.gmayor.com/export_field.htm |
#6
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
It is clearly stated in the linked article
However a graphic contained in the original page has not reproduced. I have now reinserted the image and hopefully the link should now be even clearer? It is uploading now. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Colonel Blip wrote: Hello, Graham! You wrote on Sun, 27 Aug 2006 08:57:48 +0300: Thanks on both counts. I think I was missing the update (F9) part and should have known better. Working now. Thanks again, Colonel Blip. E-mail: Assuming the picture is named according to the content of the last_name field eg Smith and is stored in the folder O:\TEMP, then for Smith.jpg, the syntax that is required is: {INCLUDEPICTURE "O:\\TEMP\\{Mergefield "Last_Name"}.JPG"} or {INCLUDEPICTURE "O:/TEMP/{Mergefield "Last_Name"}.JPG"} The quotes around Last_Name are optional. You must merge to a new document then select all (CTRL+A) and update (F9) of use the update macro at http://www.gmayor.com/installing_macro.htm Please do not post attachments, only those of us who access via NNTP will even have the opportunity to see them and that is severely discouraged in text based news groups. If you want to reproduce field constructions in a message, use the macro at http://www.gmayor.com/export_field.htm |
#7
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
Hello, Graham!
You wrote on Mon, 28 Aug 2006 09:26:41 +0300: It was indeed and I have some other forms that I update every week with Ctrl-A, F9. I was just so focussed on the right code that I missed (or ignored) other instructions. Thanks, Colonel Blip. E-mail: GM It is clearly stated in the linked article GM However a graphic contained in the original page has not reproduced. I GM have now reinserted the image and hopefully the link should now be even GM clearer? It is uploading now. GM -- GM GM Graham Mayor - Word MVP GM My web site www.gmayor.com GM Word MVP web site http://word.mvps.org GM GM Colonel Blip wrote: ?? Hello, Graham! |
#8
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Mail Merge and Graphic Insertion in OL/Word
If you hadn't raised the question, I wouldn't have rechecked my web page and
discovered the missing graphic -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Colonel Blip wrote: Hello, Graham! You wrote on Mon, 28 Aug 2006 09:26:41 +0300: It was indeed and I have some other forms that I update every week with Ctrl-A, F9. I was just so focussed on the right code that I missed (or ignored) other instructions. Thanks, Colonel Blip. E-mail: It is clearly stated in the linked article However a graphic contained in the original page has not reproduced. I have now reinserted the image and hopefully the link should now be even clearer? It is uploading now. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Colonel Blip wrote: Hello, Graham! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphics in mail merge Word 2000 | Mailmerge | |||
Printing Mail merge | Mailmerge | |||
Using graphic w/mail merge | Mailmerge | |||
How do I Mail Merge graphics into a document | Mailmerge | |||
Mail Merge is creating blank pages between form letters | Mailmerge |