Add multiple attachments to email

[Groovicles]

Hi everyone,

I have the following code:

Please Login or Register  to view this content.

As you can see I'm able to attach a 2nd document to the email I'm sending. What I'm trying to do is be able to attach more than 2, say up to 10or so. I worked out a code for this, but when I ran it File explorer would open 10 times regardless of whether you wanted to select a file or not.

Any ideas how I can dynamically select attachments for the PA without having to be limited tby a maximum number?

Thanks!!

[Norie]

If the user selects more than one file through GetOpenFilename then an array will be returned.

You could then loop through that array to attach each of the selected file.

First you would need to change the declaration of Attachment2 to Variant.

[Groovicles]

Hi Norie,

I can certainly declare Attachment2 as Variant, but I'm not sure how I could loop the array as you suggested. Could you give me an example or show me how I could write it?

Thanks,

[Norie]

Something like this.

Please Login or Register  to view this content.

[Groovicles]

hi Norie,

I tried your suggestion but it still only lets me attach a single additional document. Any ideas?

[Norie]

Oops, forgot you had to set the MultiSelect argument.

Please Login or Register  to view this content.

[Groovicles]

Hi everyone,

Unfortunately I'm getting an error message using Norie's suggestion. I'm trying to have the user attach multiple documents into the same email.

What I'm trying to do is have the ExtraAttachments.Show userform show up each time a document is attached so the user is asked whether they want to attach another document or not? Here's the code thus far:

Please Login or Register  to view this content.

Any ideas?

[Groovicles]

Bump. Anyone?

[Norie]

What exactly is the problem?

By the way, do you really want to display the userform for each attachment?

Would you consider a userform with a list of the attachments?

That list would be in the form of a listbox which would be set up so each attachment had a checkbox next to it and the user would be able to select multiple attachments.

[Groovicles]

hi Norie,

The user needs to be able to select the attachments from anywhere they can get to in File explorer. Right now they can attach one and the email is sent. I need to get it so the user can select multiple attachments from various folders and have all of those sent in the email. That's really the final result. Any ideas?

[Norie]

Did you try the code I posted in post #4 with the correction in post #6?

[Groovicles]

Hi Norie,

I certainly did. However, I got an error with the correct Attachment2 = Application.GetOpenFilename(MultiSelect:=True). Since the user may be attaching documents from various folders in the drive, I'm thinking that the userform would need to keep popping up until the user indicates there are no other attachments.

[Norie]

What error did you get?