Sending All Worksheets Through Email Individually

[Chris Voptolous]

Hi everyone,

I'm looking to send all worksheets in a workbook through email as individual files.

I was using this sort of method to split the files but I would like to split and email them:
https://www.extendoffice.com/documents/excel/628-excel-split-workbook.html

Workbook has sheets A-F, A, B, C, D, E, F would be individual files in an email.

Any ideas?

Thanks,

Chris

 

[iliace]

What you need to do is create an Outlook object, then add a MailItem object in the instance of Outlook you created, and attach the necessary items to the MailItem.

The base requirements for an e-mail message are: recipient (To), recipients (CC, if any), Subject of the message, Body of the message. You also need a rule by which attachments are created.

So, once you split the files, how do you determine who gets which one? Who gets A-F, who gets A, B, C, etc?

 

[Fazza]

Googling for the subject title "Sending All Worksheets Through Email Individually" found https://www.rondebruin.nl/win/s1/outlook/amail5.htm

Google is your friend