• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter Pivot table by each customer and auto email invoices unpaid


New Member
Attached file.

after you step into the macros. once it filters invoices unpaid by the first customer, in the pivot.

It gives an error

I was not able to resolve this.

anyone able to help me run this code please.

Objective of this macro is automate: filter on pivot for each customer, that shows invoices unpaid. then email it to the customer..and so on for each customer

It gives error - Method mail envelope of object _worksheet failed

when it reaches this line - With r.Parent.MailEnvelope.Item