Include a table and default signature to an email sent from excel.

[Richard U]

This is a mockup of what I want to send.

Account	Name	Cust Status	Invoice	Account Note	Date	Amount	Days Aging	Comments
12345	Richard's Customer	STandard	54321	XYZ	1/14/2021​	$ 140.00	30	Send reminder
12345	Richard's Customer	STandard	54321	XYZ	1/14/2021​	$ 1,320.00	17	No action
12345	Richard's Customer	STandard	54321	XYZ	1/14/2021​	$ 840.00	36	Send past due notice
12345	Richard's Customer	STandard	54321	XYZ	1/14/2021​	$ (260.00)	28	In Dispute, review in 7 days
12345	Richard's Customer	STandard	54321	XYZ	1/14/2021​	$ 1,650.00	97	Send final notice

Sincerely,

Richard U
Collections agent for ABC corporation.


In other words, send the table, and append my default signature from outlook.

I know how to send a table, and I know how to use HTLMBody to include the signature, but I cannot figure out how to do both.

Any pointers would be much appreciated.

 

[severynm]

I assume you're using a With block to populate the email fields. If so, I found that the best way to get the default signature in an email is adding .Display as the very first line in the block before populating any more of the parameters. After that you can finish with the .To .HTMLBody .Send, etc.