You probably could do that, but I would have thought mail merge would have been more appropriate.

If you can manage with a subject of "Please find attached your invoice ####", with the #### filled from a field in your data source and the 3-4 fields in the message body and the path of the attachment also listed in your data source thenhttps://www.gmayor.com/email_merge_addin.html should be able to manage that.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com