Code to attach more than 1 document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top