Send an Email after completing a task

[Stevo360]

Hi Guys

I'm almost brand new to VBA coding in excel and was wondering if someone could assist with an e-mail task.

I need my macro to send an E-mail using outlook 2007+ to a group set up in outlook with only a predefined subject and a predefined signature.

the macro does the following:

1. upon clicking the button, it filters a range
2. locks the worksheet and workbook
3. saves it as a different name in a subdirectory on a remote drive
4. unlocks both worksheet and workbook
5. repeats steps 1 to 4 for other 3 filter criteria
6. finally, it removes the filter locks the worksheet and book and overwrites the main file with a comment in a specific cell

I need the macro to send a completion mail to all the sharedive users (an assigned group in outlook), informing them that the workbook is updated.

any assistance would be greatly appreciated

 

[RobMG]

Mail from Excel with Outlook (VBA)

Try this.