Results 1 to 3 of 3
  1. #1
    BWagner10 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2019

    EMailDatabaseObject Macro "Template File" Field

    I have an EMailDatabaseObject macro that currently works.
    Click image for larger version. 

Name:	Email.jpg 
Views:	16 
Size:	31.1 KB 
ID:	39453

    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,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Apparently the Template File would be a text file with HTML coded text. Per MS: "The path and file name of a file you want to use as a template for an HTML file. The template file is a file containing HTML tags." So what do you do with an HTML template file? Review Another Actually, none of those really make clear to me how to use template file. And sorry, not finding a sample db.

    I don't use macros anyway. I would use VBA.

    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    BWagner10 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2019
    Thanks for your reply, it is greatly appreciated. I had tried that approach with no success; it is possible I was missing something in the HTML encoding. I don't have a good handle on VBA so wasn't sure how to go about making it work.
    Again, thanks for answering my post; it is yet another way I am trying to learn to be better at Access.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 19
    Last Post: 03-09-2017, 09:48 AM
  2. Replies: 1
    Last Post: 01-25-2017, 10:59 AM
  3. Replies: 20
    Last Post: 11-13-2013, 10:22 AM
  4. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  5. Replies: 1
    Last Post: 04-07-2010, 08:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums