I have a macro in my workbook which gives me a report in a particular format (as seen in the data sheet of the attached workbook).
I need to send daily emails to the party listing them their outstanding dues. I'm looking for a macro which can sort out all the data pertaining to a specific party, select all the pertaining data and send that specfic table via MS Outlook email by pasting the selected table in the body of the email. The email ids can be automatically extracted by vlookup or similar function since the email ids are available in the contacts sheet of the workbook.
Thanks in advance.
Bookmarks