Code to attach more than 1 document
 

I have created a form in excel and when you complete the form you can run a
macro that sends the form to the spcified mail recipient specififed in the
code. However, there maybe more than one document that the sender wants to
attach to that email...Is there any code to bring up a dialog box to allow it
to do this? i think that the people using excel wont really be hugely
advanced and I would rather give them a dialog box that allows them to search
for the document as you would normally in Outlook?

Code to attach more than 1 document
 

Am Tue, 21 Mar 2006 10:39:35 -0800 schrieb Jas:

As I don´t know your code I suppose: yes, probably you can add more
attachments.

Please look in Excel at the Application.FileDialog property. It should help
you finding the other files.

If you do have an Outlook MailItem object then simply add each file to its
Attachments collection.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I have created a form in excel and when you complete the form you can run
a
macro that sends the form to the spcified mail recipient specififed in the
code. However, there maybe more than one document that the sender wants
to
attach to that email...Is there any code to bring up a dialog box to allow
it
to do this? i think that the people using excel wont really be hugely
advanced and I would rather give them a dialog box that allows them to
search
for the document as you would normally in Outlook?