VBA to filter and send mail in Outlook

[Revathi Kannan]

Hi all,

I have been looking for the solution for the below requirement.

1. I need to filter the details based on the Column C and need to paste the filtered table from A to M in the body of the email and send it to the respective person as mentioned in the file for "To" and "cc".

I have attached my file . Please assist me.

 

[BobBridges]

You can create emails within Excel, but the Outlook object model is very different from that of Excel so you'd have to learn basically a whole new skill. I do this sometimes, enough that I'm confident I can show you how, but it'll seem strange to you at first. If you want to learn, I suggest you contact me by email—a lot easier to do that than formatting messages here. I'm at robhbridges (it's a gmail account).