Hello, I am looking for help to create an email message by selecting multiple rows in Excel and creating a Table of a few columns.
Data set is in the "Aging" Tab. Sample Table that I would like shown in the "Table" tab. Would like the ability to change/delete columns as needed. Body of email message would like to be able to add some text to message along with a Subject line such as Customer Name - Outstanding Balance.
We have PDF documents that would need to be linked to column E (Invoice Number) and would like to have those PDF's added to email message as an attachment.
Appreciate any help. Thank you.
Example would be to select Rows
Data Set:
Email Table:
Data set is in the "Aging" Tab. Sample Table that I would like shown in the "Table" tab. Would like the ability to change/delete columns as needed. Body of email message would like to be able to add some text to message along with a Subject line such as Customer Name - Outstanding Balance.
We have PDF documents that would need to be linked to column E (Invoice Number) and would like to have those PDF's added to email message as an attachment.
Appreciate any help. Thank you.
Example would be to select Rows
Data Set:
Email Table: