Create emails and attach several attachments

**Pederpa** · 09-25-2017, 03:23 AM

Hello,

I want to create an email and attach several attachments from a path based on a criteria using VBA.

I have a list of unique codes in column F and the following email in column H.

Capture.PNG

I also have several files all stored int he following path: "C:\Users\Username\Desktop\TestFolder". All files end with an unique five digits code to the right. See below:

- Project Brown 11111.xlsx
- Project Red 22222.xlsx
- Project Green 11111.xlsx
- Project Blue 11111.xlsx

I want the code to look for the unique five digit value and for each unique code create an email and attach all files with the same unique code.

I have tried with the code below, but it only attachs one file to each mail.

Can anyone help me?

Please Login or Register  to view this content.

**Keebellah** · 09-25-2017, 03:34 AM

Hi, welcome to the forum.
As your code goes, there is only ONE attachment per mail in your table.
Please be alittle more specific,

**Pederpa** · 09-25-2017, 03:54 AM

Thank you for you rapid response.

I will try to be more specific. I`m trying to get my code to go through my table where I can only find unique values and attach files from a folder based on the unique value.

Example, the first value in column F is "11111."

I then want my code to go through the files and add all files which contains the unique value. In this example I want the code to add 3 attachments (Project Brown, Green and Blue).

- Project Brown 11111.xlsx
- Project Red 22222.xlsx
- Project Green 11111.xlsx
- Project Blue 11111.xlsx

Is this sufficient?

**humdingaling** · 09-25-2017, 04:07 AM

Please Login or Register  to view this content.

something like this?

ps .display would be better than .save when testing the code i would have thought

**Pederpa** · 09-25-2017, 05:07 AM

Hi,

Thank you for this, much appreciated

This is almost what I need. I found some challenges. When I tried the code it only attached files to the first of my unique values (Value: "11111").

I have three unique values where two of them have files I want to attach.

"11111" = 3 files
"22222" = 1 file
"33333" = 0 files (Prefferably no mail generated)

The code creates 4 emails but only one of them contains attachments(only code "11111" get the files attached, Brown, Green and Blue". Attachment "Project Red 22222.xlsx" tounique code "22222" is therefore missing.

- Project Brown 11111.xlsx
- Project Red 22222.xlsx
- Project Green 11111.xlsx
- Project Blue 11111.xlsx

Do you have a workaround?

I see from your code that it creates an email and then start searching for the attachments. Is it possible to create a code that closes the email doesn`t include any attachments?

Thank you for the .display tips. Very helpful.

**Keebellah** · 09-25-2017, 02:48 PM

Just skip that part of the code

**humdingaling** · 09-25-2017, 09:49 PM

put in code to reset the loop for filenames

rearranged the code to do filenames first
added "chk" boolean to check if email is required

Please Login or Register  to view this content.

changes should be easy to follow, let me know if anything requires additional explanation

**Pederpa** · 09-26-2017, 02:33 AM

Thank you, this works perfectly. Much appreciated!

**humdingaling** · 09-26-2017, 03:44 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Create emails and attach several attachments

LinkBack

Thread Tools

Rate This Thread

Display

Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Re: Create emails and attach several attachments

Thread Information

Users Browsing this Thread

Similar Threads

Using .attachments.add to attach an excel file to an outlook email

Macro to create emails, attach files, add recipient and add subject line

Send multiple emails with different attachments if attachments found

[SOLVED] Loop Through Folder, Create Emails with Sub Folder Names in Subject, Attach files in sub

How to add a box that allow to attach attachments in excel

Delete attach in mange attachments

[SOLVED] Need Macro that will create & send emails w/ attachments from a list in Excel

Bookmarks

Bookmarks

Posting Permissions