|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
March 21st 06, 07:39 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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? 
|
| Ads |
|
#2
March 22nd 06, 07:41 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How Do I Attach Notes to Contacts? | Bottomcat | Outlook - Using Contacts | 10 | March 21st 06 03:57 PM |
| Send mass email and attach file! | barryderay | Outlook and VBA | 1 | March 15th 06 08:01 PM |
| How do I attach a meeting request for someone else to send? | HelpNeeded | Outlook - Calandaring | 0 | March 14th 06 06:36 PM |
| How do you attach a vCard to a signature | Tecknomage | Outlook - Using Contacts | 7 | February 15th 06 11:47 PM |
| Can't Attach | Max | Outlook - Installation | 0 | February 12th 06 12:06 AM |
Linear Mode
