INCLUDEPICTURE --> able to include all images in a specific direct

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ScottAtMU - 03 Jan 2005 16:03 GMT

I am creating a mailmerge document where I am trying to attached all the
images in a specific directory to the document. All the documents in the
specific directory are randomly named files.

Example: I have a client file 12345 and in that directory there is a
directory called Bills (i.e. c:\12345\bills). I want to be able to have a
mailmerge document to be able to attach all the files in the directory
c:\12345\bills to the letter. The client file changes for each letter and I
know I can use a mailmerge field the do that, but can't figure out if its
possible to attach all the files in a specific directory in a client's folder
to the mail merge. Any suggestions?

Reply to this Message

Doug Robbins - Word MVP - 04 Jan 2005 04:49 GMT

To use mailmerge to insert pictures into a document, you need separate
fields containing the folder\filename for each picture that you want to
include. And in addition. you need a separate { INCLUDEPICTURE {MERGEFIELD
[picturepathfilename] }} field for each picture.

If you have the same number of pictures for each record, there should not be
any problem, If they vary however, you will have to resort to a more
involved method.

Before heading off down that path, give us an idea if the "simple" approach
works.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I am creating a mailmerge document where I am trying to attached all the
> images in a specific directory to the document. All the documents in the
[quoted text clipped - 9 lines]
> folder
> to the mail merge. Any suggestions?

Reply to this Message

ScottAtMU - 04 Jan 2005 14:45 GMT

Doug ...

Thanks for the response. Let me get a little more detailed on what I'm
talking about. We bulk scan in a lot of documents for many different
accounts at one time. The scanner names the documents (i.e. IMAGE (1).TIF,
IMAGE (2).TIF, etc.). We then manually move those into the correct directory
for each account.

Meaning ... Account 12345 in the ATTACHMENT folder could have a list of
images such as:
IMAGE (1).TIF
IMAGE (19).TIF
IMAGE.TIF
ATTACHMENT.TIF

The file names are never the same name nor in any real logical order in name
any one accounts ATTACHMENT folder's files. There also could be 1 file to
attached or 3 or 6, all depending on how much activity each account has
generated.

Is there a *.* type macro that would allow all the files in the directory,
or even a *.tif, to be attached in a mail merge?

> To use mailmerge to insert pictures into a document, you need separate
> fields containing the folder\filename for each picture that you want to
[quoted text clipped - 21 lines]
> > folder
> > to the mail merge. Any suggestions?

Reply to this Message

Doug Robbins - Word MVP - 05 Jan 2005 05:13 GMT

With the variability of what you have to work with, you are in for some
pretty significant programming work if you want to automate this.

Signature

> Doug ...
>
[quoted text clipped - 54 lines]
>> > folder
>> > to the mail merge. Any suggestions?

Reply to this Message