Im using Excell 2000 as a realestate database, I have 50+ rows of property
information including a cell with a photo number (i.e.: 174 means
C:\...Nicon0174.JPG) and I would like to print out "flyers" of each property
for investors. I use Word form with mail merge and want to include the
actual picture in the merged documents. All the other information comes over
from Excel fine. How can I get the actual picture into the merged document?
Thanks, JJA

Hi ?B?SkpB?=,

Im using Excell 2000 as a realestate database, I have 50+ rows of property
information including a cell with a photo number (i.e.: 174 means
C:\...Nicon0174.JPG) and I would like to print out "flyers" of each property
for investors. I use Word form with mail merge and want to include the
actual picture in the merged documents. All the other information comes over
from Excel fine. How can I get the actual picture into the merged document?

you'll find steps for including pictures in a mail merge in the Mail Merge FAQ
on my website (special merges section). Basically, in your case, the
IncludePicture field code mentioned would look like this:

{ IncludePicture "C:\\Nicon0{ Mergefield Photo }.jpg" }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

See http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


JJA wrote:
Im using Excell 2000 as a realestate database, I have 50+ rows of
property information including a cell with a photo number (i.e.: 174
means C:\...Nicon0174.JPG) and I would like to print out "flyers" of
each property for investors. I use Word form with mail merge and
want to include the actual picture in the merged documents. All the
other information comes over from Excel fine. How can I get the
actual picture into the merged document? Thanks, JJA

[Nicholas]

I have followed the instructions in the link.

I have a couple of questions for my project.

I am trying to build a photo member directory, ideally, I want to have only
2 columns on 8X11 paper (portait) with unknown amount of records.

1. If, I don't have a picture of the "cat", but I do a generic picture, how
can I get that to populate instead?
2. Also, how do I get this layed out to be in 2 comlums. (and don't have to
create a layout for each record.

Thanks in advance

"Graham Mayor" wrote:

See http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


JJA wrote:
Im using Excell 2000 as a realestate database, I have 50+ rows of
property information including a cell with a photo number (i.e.: 174
means C:\...Nicon0174.JPG) and I would like to print out "flyers" of
each property for investors. I use Word form with mail merge and
want to include the actual picture in the merged documents. All the
other information comes over from Excel fine. How can I get the
actual picture into the merged document? Thanks, JJA

[Suzanne S. Barnhill]

I'll let Graham follow up on the specifics, but, to help him help you, do
you want the entire directory to be in two snaking columns, or do you want
each record to be in two columns, one for the picture and one for the
address information? If the former, you just format the mail merge main
document as two columns; if the latter, insert a one-row, two-column table
with your photo mergefield in one cell and the address mergefields in the
other.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Nicholas" wrote in message
...
I have followed the instructions in the link.

I have a couple of questions for my project.

I am trying to build a photo member directory, ideally, I want to have
only
2 columns on 8X11 paper (portait) with unknown amount of records.

1. If, I don't have a picture of the "cat", but I do a generic picture,
how
can I get that to populate instead?
2. Also, how do I get this layed out to be in 2 comlums. (and don't have
to
create a layout for each record.

Thanks in advance

"Graham Mayor" wrote:

See http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


JJA wrote:
Im using Excell 2000 as a realestate database, I have 50+ rows of
property information including a cell with a photo number (i.e.: 174
means C:\...Nicon0174.JPG) and I would like to print out "flyers" of
each property for investors. I use Word form with mail merge and
want to include the actual picture in the merged documents. All the
other information comes over from Excel fine. How can I get the
actual picture into the merged document? Thanks, JJA

[Doug Robbins - Word MVP]

Assuming that the Image mergefield contains the path\\filename of the
picture, you should be able to use

{ IF { Mergefield Image } "" "{INCLUDEPICTURE {IF TRUE "{Mergefield
Image}"} \d }" "{ INCLUDEPICTURE { IF TRUE "Path\\filenameofdummyimage"}
\d" }


--
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

"Nicholas" wrote in message
...
I have followed the instructions in the link.

I have a couple of questions for my project.

I am trying to build a photo member directory, ideally, I want to have
only
2 columns on 8X11 paper (portait) with unknown amount of records.

1. If, I don't have a picture of the "cat", but I do a generic picture,
how
can I get that to populate instead?
2. Also, how do I get this layed out to be in 2 comlums. (and don't have
to
create a layout for each record.

Thanks in advance

"Graham Mayor" wrote:

See http://www.gmayor.com/mail_merge_graphics.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


JJA wrote:
Im using Excell 2000 as a realestate database, I have 50+ rows of
property information including a cell with a photo number (i.e.: 174
means C:\...Nicon0174.JPG) and I would like to print out "flyers" of
each property for investors. I use Word form with mail merge and
want to include the actual picture in the merged documents. All the
other information comes over from Excel fine. How can I get the
actual picture into the merged document? Thanks, JJA