Ixandantilus
IS-IT--Management
I have written a good deal of VBA for Access and Excel, although it has been a few years since I was deep into it. What I am trying to do now is write a macro that will attach attachments to the active (unsent) Outlook e-mail message. We have e-mail users that need to attach pdf files to e-mail several times a day, usually each e-mail will have 15-30 attachments needed. The key is the file names will always be in a range, ex: 99981.pdf thru 99999.pdf. Instead of manually typing each one, or clicking thru a directory that has 1,000's of these files, I would like the user to merely type the fist and last number into an input box and have the macro automatically attach the files. Is this kind of thing possible with Outlook / VBA?
