Results 1 to 3 of 3
  1. #1
    Dscalf1 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2017
    Posts
    17

    Question Emailing Macro

    I need help creating a macro that emails out what is on a form. Here is what I want to happen. In my form I have a "assigned to" button on the assigned to its a drop down and you can pick a name that comes from a contacts table. In the table they have an email address section. is there anyway that when they submit a new action item the macro will get the email address of the person it was assigned to and then email them the information to let them know they had an action item assigned to them. Im not even sure where to begin with this..

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I'd start with SendObject, though I'd use VBA instead of a macro. You'll have more control.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    WendellS is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    10
    Is the email address going to show on the form? Try this. Put a button on your form and attach it to a macro.

    For the macro use
    EMailDatabaseObject

    For the "To:" section
    Use =me![field with email address]

    (I can't remember if the "=" is used or not, so try it both ways it's been years since I did this)

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

Similar Threads

  1. Problems with emailing a form by a Macro
    By Lou_Reed in forum Access
    Replies: 2
    Last Post: 03-09-2017, 03:39 PM
  2. Emailing a PDF
    By Gina Maylone in forum Access
    Replies: 4
    Last Post: 04-13-2015, 11:37 AM
  3. Emailing
    By fastebs in forum Access
    Replies: 2
    Last Post: 04-13-2012, 12:37 AM
  4. Emailing the available attahcment in table using macro.
    By Muralidaran in forum Sample Databases
    Replies: 3
    Last Post: 03-22-2012, 07:54 PM
  5. Macro to trigger emailing an updateable table
    By KOIBOY in forum Import/Export Data
    Replies: 5
    Last Post: 09-10-2011, 05:46 AM

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