Results 1 to 9 of 9

Emailing Just ONE Record

  1. #1
    HLTAYLOR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Location
    Clinton, SC
    Posts
    13

    Emailing Just ONE Record


    We want to inlcude a button on a form that will open an Outlook message showing only that ONE record. I've seen lots of blogs about this out on the web, but they all involve VBA, and I'm a Macro Girl . I do not know how to work in VBA. Any help?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    Are you saying you are not going to use VBA you only want to use Macros or are you saying you need help with the VBA

  3. #3
    HLTAYLOR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Location
    Clinton, SC
    Posts
    13
    Thanks for your reply. I'm saying that I don't know how to use VBA, so I would rather use macros. But if the VBA were simple enough to where I could just substitute my form name into it, I think I could do it.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    I'm assuming you've got the record you want to send on your form when you click your button.

    Are you talking about sending a report, a file attachment or something like a screen shot of the record in the body of the email.

    The first two are relatively easy, the third I've never tried but may be possible.

    Is the email recipient always the same or is that meant to be filled out by the operator before the email is sent?

  5. #5
    HLTAYLOR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Location
    Clinton, SC
    Posts
    13
    I really want a pdf or some sort of "picture" of the form, since the email is a reminder to fill it out. The addressee will be filled in by the sender.

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    here's a method to create a screen shot file:

    http://stackoverflow.com/questions/2...ccess-with-vba

    The other method is to export your form to a PDF similar to what you'd do with a report, however you should be aware that if you are using a continuous form it'll print ALL the items in the subform, not just the one you've got your cursor on.

    as long as you're only sending one attachment per email you can use the SENDOBJECT command to send the email with an attachment fairly easily, here's a reference:

    http://www.fmsinc.com/microsoftacces...endobject.html

  7. #7
    HLTAYLOR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Location
    Clinton, SC
    Posts
    13
    My form is 2 pages long, so I wouldn't be able to use the screenshot, correct?

  8. #8
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    to email a single record or screen shot a single record, probably not

    You can likely pick the information you want from the record you want and email that rather than trying to screen shot/pdf a document though.

  9. #9
    HLTAYLOR is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Location
    Clinton, SC
    Posts
    13
    I got it! I made a report that looked exactly like the form. I made a button on the form that, when clicked, runs a parameter query for the info for that record, and puts it in my look-alike form. Then I used EmailDatabaseObject to create an email with an attached pdf of the form. Thanks for all the help!

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

Similar Threads

  1. Emailing example
    By pkstormy in forum Code Repository
    Replies: 4
    Last Post: 01-31-2014, 04:22 PM
  2. Emailing
    By fastebs in forum Access
    Replies: 2
    Last Post: 04-13-2012, 12:37 AM
  3. Emailing Last Record & exit handling
    By malamute20 in forum Programming
    Replies: 25
    Last Post: 08-24-2011, 05:14 AM
  4. Replies: 2
    Last Post: 08-02-2011, 07:25 AM
  5. Pop-up when emailing from Access
    By tgavin in forum Access
    Replies: 5
    Last Post: 05-02-2011, 10:56 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
  •  
Tech Forums: Microsoft Office Forums