Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
|
|||
|
|||
Merging pictures
Hello, Doug!
Doug, Tried the code as follows per your suggestion but result was no pictures in merged file. Here is my code to be sure I didn't miss something: { IF { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE { IF TRUE "O:\\Pictures\\2009 Original Church Pictures\\NoPictureAvailable.jpg" } } } Anything obviously messed up that I've missed? You wrote on Thu, 6 Aug 2009 11:29:35 +1000: DRW {IF {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 Original Church DRW Pictures\{ Mergefield "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE DRW "O:\Pictures\2009 Original Church Pictures\{ Mergefield DRW "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 DRW Original Church Pictures\NoPictureAvailable.jpg"}} } DRW Note that only a single \ is used as the path separator in the above DRW construction. DRW -- DRW Hope this helps. DRW Please reply to the newsgroup unless you wish to avail yourself of my DRW services on a paid consulting basis. DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, All! ?? I have a directory I print for the church. In it I have insert a ?? picture of the family with the code {INCLUDEPICTURE ?? "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield ?? "Full_Name"}.JPG" }. I would like to insert a standard ?? NoPictureAvailable.jpg file if there is no picture for the family in ?? question. Is there a way to do this? ?? ?? Thanks, ?? ?? Colonel Blip ?? E-mail: colonel.blip.at.bigfoot.com ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com |
#2
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
|
|||
|
|||
Merging pictures
Note that I said:
Note that only a single \ is used as the path separator in the above. You still have \\ as the path separator. -- 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, originally posted via msnews.microsoft.com "colblip" colonel.blip.at.bigfoot.com wrote in message ... Hello, Doug! Doug, Tried the code as follows per your suggestion but result was no pictures in merged file. Here is my code to be sure I didn't miss something: { IF { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE { IF TRUE "O:\\Pictures\\2009 Original Church Pictures\\NoPictureAvailable.jpg" } } } Anything obviously messed up that I've missed? You wrote on Thu, 6 Aug 2009 11:29:35 +1000: DRW {IF {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 Original Church DRW Pictures\{ Mergefield "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE DRW "O:\Pictures\2009 Original Church Pictures\{ Mergefield DRW "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 DRW Original Church Pictures\NoPictureAvailable.jpg"}} } DRW Note that only a single \ is used as the path separator in the above DRW construction. DRW -- DRW Hope this helps. DRW Please reply to the newsgroup unless you wish to avail yourself of my DRW services on a paid consulting basis. DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, All! ?? I have a directory I print for the church. In it I have insert a ?? picture of the family with the code {INCLUDEPICTURE ?? "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield ?? "Full_Name"}.JPG" }. I would like to insert a standard ?? NoPictureAvailable.jpg file if there is no picture for the family in ?? question. Is there a way to do this? ?? ?? Thanks, ?? ?? Colonel Blip ?? E-mail: colonel.blip.at.bigfoot.com ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com |
#3
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
|
|||
|
|||
Merging pictures
Hello, Doug!
I mis-understood - thought you were pointing out you only used one \ for ease of typing and I should use \\. I have corrected that and now when I Alt-F9 I get a message in the code area "Error! File Name not specified". I've checked the code more times than I care to admit. I've double checked I have a picture "NoPictureAvailable.jpg" so I don't know what might be the problem. BTW, it has been too long since I worked in field codes. I recall there was some way to copy or print out these lines of code so one could paste them as text. What is it? Sorry for all of my trouble. Thanks again for the help. You wrote on Fri, 7 Aug 2009 06:39:43 +1000: DRW Note that only a single \ is used as the path separator in the above. DRW You still have \\ as the path separator. DRW -- DRW Hope this helps. DRW Please reply to the newsgroup unless you wish to avail yourself of my DRW services on a paid consulting basis. DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, Doug! ?? ?? Doug, ?? ?? Tried the code as follows per your suggestion but result was no ?? pictures in merged file. Here is my code to be sure I didn't miss something: ?? ?? { IF { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church ?? Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE {IF TRUE ?? "O:\\Pictures\\2009 ?? Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { ?? INCLUDEPICTURE { IF TRUE "O:\\Pictures\\2009 Original Church ?? ?? Pictures\\NoPictureAvailable.jpg" } } } ?? ?? Anything obviously messed up that I've missed? ?? ?? You wrote on Thu, 6 Aug 2009 11:29:35 +1000: ?? DRW {IF {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 Original Church DRW Pictures\{ Mergefield "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE DRW "O:\Pictures\2009 Original Church Pictures\{ Mergefield DRW "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 DRW Original Church Pictures\NoPictureAvailable.jpg"}} } ?? DRW Note that only a single \ is used as the path separator in the above DRW construction. DRW -- DRW Hope this helps. ?? DRW Please reply to the newsgroup unless you wish to avail yourself of DRW my services on a paid consulting basis. ?? DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, All! ?? I have a directory I print for the church. In it I have insert a ?? picture of the family with the code {INCLUDEPICTURE ?? "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield ?? "Full_Name"}.JPG" }. I would like to insert a standard ?? NoPictureAvailable.jpg file if there is no picture for the family in ?? question. Is there a way to do this? ?? ?? Thanks, ?? ?? Colonel Blip ?? E-mail: colonel.blip.at.bigfoot.com ?? ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com |
#4
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
|
|||
|
|||
Merging pictures
This will also be applicable to your response to Macropod in the other
thread that you have started. It is better not to do that. What do you have in the data source for the records where there is no "full name".jpg? If you have NoPictureAvailable.jpg then, the following information previously posted by macropod should get you going: When embedding a mailmerge field in an INCLUDEPICTURE field for the purpose of merging graphics: 1. the filepaths to the fields ordinarily need to have the separators expressed as '\\' or '/' instead of the usual '\'; 2. the pictures usually won't show until you refresh the fields (eg Ctrl-A, then F9); and 3. even after updating the images, they remain linked to the image files, which can be an issue if you need to send the merged output to someone else. The following field construction addresses all three issues: {IF {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"}} {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"}}} or {IF {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\{MERGEFIELD Image}"}} {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\{MERGEFIELD Image}"}}} After running a mailmerge coded this way, you'll have the correct, unlinked image for each record. If your path separators are already expressed as '\\' or '/', that will work too. If the path data are included with in the image field, you can use: {IF {INCLUDEPICTURE {IF TRUE "«Image»"}} {INCLUDEPICTURE {IF TRUE "«Image»"}}} or {IF {INCLUDEPICTURE {IF TRUE "{MERGEFIELD Image}"}} {INCLUDEPICTURE {IF TRUE "{MERGEFIELD Image}"}}} 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. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. -- 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, originally posted via msnews.microsoft.com "colblip" colonel.blip.at.bigfoot.com wrote in message ... Hello, Doug! I mis-understood - thought you were pointing out you only used one \ for ease of typing and I should use \\. I have corrected that and now when I Alt-F9 I get a message in the code area "Error! File Name not specified". I've checked the code more times than I care to admit. I've double checked I have a picture "NoPictureAvailable.jpg" so I don't know what might be the problem. BTW, it has been too long since I worked in field codes. I recall there was some way to copy or print out these lines of code so one could paste them as text. What is it? Sorry for all of my trouble. Thanks again for the help. You wrote on Fri, 7 Aug 2009 06:39:43 +1000: DRW Note that only a single \ is used as the path separator in the above. DRW You still have \\ as the path separator. DRW -- DRW Hope this helps. DRW Please reply to the newsgroup unless you wish to avail yourself of my DRW services on a paid consulting basis. DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, Doug! ?? ?? Doug, ?? ?? Tried the code as follows per your suggestion but result was no ?? pictures in merged file. Here is my code to be sure I didn't miss something: ?? ?? { IF { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church ?? Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE {IF TRUE ?? "O:\\Pictures\\2009 ?? Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { ?? INCLUDEPICTURE { IF TRUE "O:\\Pictures\\2009 Original Church ?? ?? Pictures\\NoPictureAvailable.jpg" } } } ?? ?? Anything obviously messed up that I've missed? ?? ?? You wrote on Thu, 6 Aug 2009 11:29:35 +1000: ?? DRW {IF {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 Original Church DRW Pictures\{ Mergefield "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE DRW "O:\Pictures\2009 Original Church Pictures\{ Mergefield DRW "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 DRW Original Church Pictures\NoPictureAvailable.jpg"}} } ?? DRW Note that only a single \ is used as the path separator in the above DRW construction. DRW -- DRW Hope this helps. ?? DRW Please reply to the newsgroup unless you wish to avail yourself of DRW my services on a paid consulting basis. ?? DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, All! ?? I have a directory I print for the church. In it I have insert a ?? picture of the family with the code {INCLUDEPICTURE ?? "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield ?? "Full_Name"}.JPG" }. I would like to insert a standard ?? NoPictureAvailable.jpg file if there is no picture for the family in ?? question. Is there a way to do this? ?? ?? Thanks, ?? ?? Colonel Blip ?? E-mail: colonel.blip.at.bigfoot.com ?? ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com |
#5
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
|
|||
|
|||
Merging pictures
Hi colblip,
There's some macro code for converting between field codes and the textual representations of them at: http://www.wopr.com/index.php?showto...#entry320 421 -- Cheers macropod [Microsoft MVP - Word] "colblip" colonel.blip.at.bigfoot.com wrote in message ... Hello, Doug! I mis-understood - thought you were pointing out you only used one \ for ease of typing and I should use \\. I have corrected that and now when I Alt-F9 I get a message in the code area "Error! File Name not specified". I've checked the code more times than I care to admit. I've double checked I have a picture "NoPictureAvailable.jpg" so I don't know what might be the problem. BTW, it has been too long since I worked in field codes. I recall there was some way to copy or print out these lines of code so one could paste them as text. What is it? Sorry for all of my trouble. Thanks again for the help. You wrote on Fri, 7 Aug 2009 06:39:43 +1000: DRW Note that only a single \ is used as the path separator in the above. DRW You still have \\ as the path separator. DRW -- DRW Hope this helps. DRW Please reply to the newsgroup unless you wish to avail yourself of my DRW services on a paid consulting basis. DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, Doug! ?? ?? Doug, ?? ?? Tried the code as follows per your suggestion but result was no ?? pictures in merged file. Here is my code to be sure I didn't miss something: ?? ?? { IF { INCLUDEPICTURE {IF TRUE "O:\\Pictures\\2009 Original Church ?? Pictures\\{ Mergefield "Full_Name"}.JPG"} } { INCLUDEPICTURE {IF TRUE ?? "O:\\Pictures\\2009 ?? Original Church Pictures\\{ Mergefield "Full_Name"}.JPG"} } { ?? INCLUDEPICTURE { IF TRUE "O:\\Pictures\\2009 Original Church ?? ?? Pictures\\NoPictureAvailable.jpg" } } } ?? ?? Anything obviously messed up that I've missed? ?? ?? You wrote on Thu, 6 Aug 2009 11:29:35 +1000: ?? DRW {IF {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 Original Church DRW Pictures\{ Mergefield "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE DRW "O:\Pictures\2009 Original Church Pictures\{ Mergefield DRW "Full_Name"}.JPG"}} {INCLUDEPICTURE {IF TRUE "O:\Pictures\2009 DRW Original Church Pictures\NoPictureAvailable.jpg"}} } ?? DRW Note that only a single \ is used as the path separator in the above DRW construction. DRW -- DRW Hope this helps. ?? DRW Please reply to the newsgroup unless you wish to avail yourself of DRW my services on a paid consulting basis. ?? DRW Doug Robbins - Word MVP, originally posted via msnews.microsoft.com DRW "colblip" colonel.blip.at.bigfoot.com wrote in message DRW ... ?? Hello, All! ?? I have a directory I print for the church. In it I have insert a ?? picture of the family with the code {INCLUDEPICTURE ?? "O:\\Pictures\\2009 Original Church Pictures\\{ Mergefield ?? "Full_Name"}.JPG" }. I would like to insert a standard ?? NoPictureAvailable.jpg file if there is no picture for the family in ?? question. Is there a way to do this? ?? ?? Thanks, ?? ?? Colonel Blip ?? E-mail: colonel.blip.at.bigfoot.com ?? ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com ?? With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging pictures | Mailmerge | |||
Mail Merging Pictures | Mailmerge | |||
Merging pictures along with data... | Mailmerge | |||
Mail merging pictures from Access to Word | Mailmerge | |||
Merging pictures - maybe one for Graham? | Mailmerge |