Macro to auto filter range and send details in body of email to respective addresses

Suji

New member
Joined
Mar 14, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Hi All,

Can someone help me on this query?

I got stuck in between code where I need to bring the dynamic range to the body of email along with "Dear Action party, Below are the set of invoices which needs your support in the workflow..

My excel range is dynamic based on selection and based on to address in A1 cell it gets Auto-filter from Data Sheet from there it needs to send email to respective addresses.

Thanks in advance
 

Attachments

  • Email Macro2.xlsm
    29.2 KB · Views: 8
Last edited:
Back
Top