Newbie to VBA - question about emailing workbooks based on workbook name

[srhstrby]

I'd like to know if there is a way to email a folder full of individual workbooks to each recipient based on the workbook name. EG., I use VBA to parse a large sheet based on the vcol (a name). This then sums up the worksheet into a summary sheet and the detailed sheet in a single workbook which is named based on the vcol. I'd like to know if there's something I can use or add to my existing vba to allow it to email said workbook to the person it's name for.

I have no clue how to build a database with their emails, though I do have a xlsx with everyone's name and email on it (their name being like it would be in my original worksheets) so it SHOULD reference. I just don't know how to make it reference. I'll attach my VBA here so you can see what I'm starting with.

Please Login or Register  to view this content.

Any help would be greatly appreciated. I'm using gmail now, but I could get my gmail to sync with outlook if need be. And please, dumb it down like you're talking to a kid... I had quite a bit of help writing the above. I made so many mistakes it was ridiculous. The main workbook I work with is usually between 35-50kb, depending on the month.

[Kenneth Hobson]

Welcome to the forum!

It is fairly simple using the Outlook object. One can use CDO to so it as well. The code at the end is a short example using Outlook. See Ron's site for more complex examples. In the example, .Attachments.Add "yourfullpathfilename.ext here" is used.

If you need more specific help, try making a simple obfuscated file and attach it. Explain what you expect to happen. Click Go Advanced button in lower right of a reply and click the Manage Attachments hyperlink below the reply box to browse and upload the example.

Please Login or Register  to view this content.