Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
colblip colblip is offline
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
colblip colblip is offline
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging pictures colblip Mailmerge 19 August 20th 09 09:26 PM
Mail Merging Pictures Té Mailmerge 1 June 23rd 09 07:13 AM
Merging pictures along with data... Evan Lapka Mailmerge 12 June 22nd 07 08:03 PM
Mail merging pictures from Access to Word Hammond-Wandsworth Mailmerge 1 December 11th 06 06:09 PM
Merging pictures - maybe one for Graham? ShaneS Mailmerge 2 July 1st 05 02:46 AM


All times are GMT +1. The time now is 09:39 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"