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
Cross Post:in excelguru ca
First, put your data into an Excel table. Excel tables are easier to manage.
Next I created a sheet (Agents) with pivot tables. The first PT is a list of customers. The second PT links addressees with the customers. Both lists are dynamic based on the data in the Data Table. However, if you add, delete or change data, you will have to refresh the pivot table - since both tables are built from the same data, refreshing one of them will refresh both.
The macro to run is SendMailNotice.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thank you so much, it helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks