I have an EMailDatabaseObject macro that currently works.
I am able to populate the pertinent fields from the database with no problem. The macro works fine to create a report, format and attach it to Outlook as a PDF. I also have an Outlook template that I used in the past to send the file; the template also contains a signature block. What I would like to do is use the Outlook template, populate the fields with the proper data, then be able to edit the final file before sending.
This may be a two part question: 1) How can this be accomplished? And 2) Is there an example of successfully using the "Template File" field of the EMailDatabaseObject macro?
Any help is greatly appreciated,