Results 1 to 3 of 3

EMailDatabaseObject Macro "Template File" Field

  1. #1
    BWagner10 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2019
    Posts
    2

    EMailDatabaseObject Macro "Template File" Field

    I have an EMailDatabaseObject macro that currently works.


    Click image for larger version. 

Name:	Email.jpg 
Views:	14 
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 offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,268
    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 https://www.visuallizard.com/blog/355/outlook-email-templates. Another https://www.outlook-apps.com/outlook-template-emails/. 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: http://www.accessforums.net/showthread.php?t=70301 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
    Posts
    2
    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
  •  
Tech Forums: Microsoft Office Forums