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

Good Morning,

I create some pdf's and spreadsheets and save to a folder, then I have to send them to the same person. There is one pdf and sheet for each email, and they are named the exact same. Is there a way with a macro to create an email with the recipient being the same, attaching both files, and entering the subject line as the name of one of the files, doesn't matter which one since they are both names the same? Furthermore, would it be possible with one step to do this for multiple emails? Essentially I have about 60 files, 2 of each go on one email, so about 30 emails, that go to the same person.

Thanks!

Is there a way with a macro to create an email

A very common topic - try searching for some basic code.

I have, I'm not much a a VBA expert. I can add a basic create an email. This is a little bit more complex. I have one folder with 60 files, 30 excel, and 30 pdf. One excel corresponds with one pdf, they would have the same name. Example, there is one excel named "4-2017 Best Buy Statement" and one PDF named "4-2017 Best Buy Statement", there is one excel named "4-2017 Radio Shack Statement" and one pdf named "4-2017 Radio Shack Statement", and about 28 other sets. They all have to go to the same person, and each email subject would be titled the way the statement is named. So the first email will be to "same recipient", subject "4-2017 Best Buy Statement" and attach both best buy files, the second email would be "same recipient" , subject line " 4-2017 Radio Shack Statement", with both Radio shack statements, etc. So it would have to go and determine that there are two files with the same name, create one email for those and attach them, then address it to one person and attach both of those files, then send. Any ideas?

Thanks!

Never mind trying to get everything working to start with - you'll only confuse yourself.

Go find a thread to create an email (in the absence of any code you may have), for example the 3rd result from this search looks like a good candidate - once you get that working with a couple of attachments then you can concentrate on picking up the correct attachments.

Ok, I'll take a look at it. I know its a lot, but I figured there has to be a way, if only one step at a time. Thanks.

I've gotten this far, but its in excel, not outlook, not sure if it makes a difference. Successfully opens an email, attaches the file I specify, and sends.

Please Login or Register  to view this content.

Assuming you want to run this in Outlook...

Remove the 'New' keyword from the line

Please Login or Register  to view this content.

Not that is really matters as only 1 instance of Outlook can run but if this was in Excel (and referencing 'Excel.Application') it would start a 2nd instance of Excel. Might as well get it right to start with.

Actually, you can probably remove references to olApp and simply refer to the Application object - as you're running it in Outlook, that's the application

Please Login or Register  to view this content.

So should I open VBA from Outlook then insert a new module and apply this code?

I just added this in a module in VBA in outlook, and it ran successfully.