Ability to email from excel vba code

[bosco2]

Hello All -
I am using the following code to break up a large file into individual files based on the first column.

Please Login or Register  to view this content.

I was wondering if anyone knew a way to be able to not only add the new file to the designated path but also email the file to the person in columnA? Column A which the file is separating on is a username for an email?

Example Data:
asmith field1 field2 field3 etc.
asmith field1 field2 field3 etc.
asmith field1 field2 field3 etc.
jjones field1 field2 field3 etc.
jjones field1 field2 field3 etc.
jjones field1 field2 field3 etc.
jjones field1 field2 field3 etc.
twilson field1 field2 field3 etc.
twilson field1 field2 field3 etc.
twilson field1 field2 field3 etc.
twilson field1 field2 field3 etc.

So currently this would create 3 files:
TEST_asmith.xlsx
TEST_jjones.xlsx
TEST_twilson.xlsx

Thank you in advance

[Leith Ross]

Hello Bosco2,

The code to send the workbook is in bold below. You will need to add a suitable subject line.

Please Login or Register  to view this content.