B
BSimpson
I'm looking to find out how to automate the emailing of documents. Within
each batch, they each document may go to one of 3 individuals, or the entire
batch may go to only 1 individual, or a mix thereof. Due to filing
requirements, each document MUST be emailed individually as an attachment,
not in the body of the message, ergo, "merge to email" is NOT an option, as
a merge operation may generate 1 or several dozen output documents.
What I'm looking for is a macro I could run with the documents opened (or
alternately it would include the coding to go to a specific folder and
handle each document therein), and loop until all the documents have been
processed.
Ideally, the macro would pick up the destination email address from within
the document itself, getting the address from a specific merge field, put
the address in the "To" line of the email (I use Outlook 2000), use the
filename of the document as the subject, and mail the document as an
attachment.
If it can't pick up the address from the document itself (maybe from a
document property variable set equal to the merge field that contains the
individual's name??), the I could just open up all the documents which are
to go to one individual and run a macro containing that individual's email
address in the coding itself. I have no problem with potentially having to
have 3 macros, one for each destination.
Best-case scenario: 1 macro, each document has the email address embedded
within it, the macro goes to folder X, processes each document retrieving
the address as appropriate, puts the file name in the Subject line of the
message, attaches the document, and VOOM - off it goes, thus allowing me to
sit back, feeling very smug at making my day go more easily, thus allowing
myself to plough through even MORE stuff each day! <grins!!!>
Anything's gotta be better than having to right-click|send to|mail
recipient|etc over and over and OVER again for each of several dozen
documents! (Remember: they must be mailed with only one attachment per each
email.)
Mucho Thanks!!!
Brian.
each batch, they each document may go to one of 3 individuals, or the entire
batch may go to only 1 individual, or a mix thereof. Due to filing
requirements, each document MUST be emailed individually as an attachment,
not in the body of the message, ergo, "merge to email" is NOT an option, as
a merge operation may generate 1 or several dozen output documents.
What I'm looking for is a macro I could run with the documents opened (or
alternately it would include the coding to go to a specific folder and
handle each document therein), and loop until all the documents have been
processed.
Ideally, the macro would pick up the destination email address from within
the document itself, getting the address from a specific merge field, put
the address in the "To" line of the email (I use Outlook 2000), use the
filename of the document as the subject, and mail the document as an
attachment.
If it can't pick up the address from the document itself (maybe from a
document property variable set equal to the merge field that contains the
individual's name??), the I could just open up all the documents which are
to go to one individual and run a macro containing that individual's email
address in the coding itself. I have no problem with potentially having to
have 3 macros, one for each destination.
Best-case scenario: 1 macro, each document has the email address embedded
within it, the macro goes to folder X, processes each document retrieving
the address as appropriate, puts the file name in the Subject line of the
message, attaches the document, and VOOM - off it goes, thus allowing me to
sit back, feeling very smug at making my day go more easily, thus allowing
myself to plough through even MORE stuff each day! <grins!!!>
Anything's gotta be better than having to right-click|send to|mail
recipient|etc over and over and OVER again for each of several dozen
documents! (Remember: they must be mailed with only one attachment per each
email.)
Mucho Thanks!!!
Brian.