Reply
 
Thread Tools Display Modes
  #1   Report Post  
ScottAtMU
 
Posts: n/a
Default INCLUDEPICTURE --> able to include all images in a specific direct

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?
  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default

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.

--
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
"ScottAtMU" wrote in message
...
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?


  #3   Report Post  
ScottAtMU
 
Posts: n/a
Default

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?


"Doug Robbins - Word MVP" wrote:

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.

--
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
"ScottAtMU" wrote in message
...
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?



  #4   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default

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.

--
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
"ScottAtMU" wrote in message
...
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?


"Doug Robbins - Word MVP" wrote:

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.

--
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
"ScottAtMU" wrote in message
...
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
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
Large documents containing many images Javier Formatting Long Documents 0 January 12th 05 06:26 PM


All times are GMT +1. The time now is 02:20 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"