Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
Large documents containing many images | Formatting Long Documents |