Results 1 to 4 of 4
  1. #1
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27

    Email button.


    Can I insert a button with a command specified to send an e-mail to several recipients containing the contents of a few fields entered in the form?

  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,640
    The simplest method would be to use SendObject. Check that out in VBA help and see how it goes.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    That sounds like it would almost do exactly what I'm looking for. Is there any way to send only two specific fields from a table? Or would I just have to make those two fields their own table and send it that way? Would I then be able to only send one record from the table as well, instead of the whole thing? Thanks.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    There are a lot of options. You mentioned data entered on a form, so you could simply add data from the form into the body of the email. This would be building a string variable that would then be used with SendObject:

    strBody = "Dear " & Me.FirstName & vbCrLf & "Thanks for buying a " & Me.ProductName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 6
    Last Post: 02-09-2010, 07:53 AM
  2. Access email button messing up numbers
    By ninjafly in forum Reports
    Replies: 3
    Last Post: 08-20-2009, 04:27 AM
  3. email contact button
    By nwalke in forum Programming
    Replies: 3
    Last Post: 07-02-2009, 07:11 AM
  4. Another email report question ...
    By valkyry in forum Reports
    Replies: 0
    Last Post: 05-23-2007, 11:42 PM
  5. email button in form
    By peterinbristol in forum Forms
    Replies: 0
    Last Post: 03-19-2007, 02:25 PM

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