Results 1 to 4 of 4
  1. #1
    melody.anne is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    3

    e-mail currently open report using a form

    I've been looking for a while everywhere and I can't find a real answer to this. I made a program that creates various reports based on excel data. They are daily reports. I want to put a button on my report to email these reports. However, I want to be able to select who I want to send it to using a form. I have a directory of names and emails, and that form feeds off of that data, and with that I want to be able to have Access link the e-mail to the person(s) who's name(s) is currently selected.



    My problem is, since this form isn't directly on the report, I don't know how to make it e-mail the report that is currently open. How would I do this?

    This is what the form looks like:
    Click image for larger version. 

Name:	stuff.png 
Views:	6 
Size:	42.9 KB 
ID:	20143
    Where "Nombre" is where you select individual people by their name, "categorķa" is where you select a category and it sends it to those people in that category, and "oficina" is to send it to people by office.

    I want to send it only to those selected, and make it so you can only send it to people using one listbox at a time.

    PS: I want to use Lotus Notes 8.5

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The button is on the form.
    the form has the list of names and the list of reports.
    select 1 report in rpt box, and multi select the list of names from a name list box. Click send.

    the code builds the email using the 1 rpt ,gathers all names picked into the TO , then send.

  3. #3
    melody.anne is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    3
    Everything is correct, except that the form does not have a list of the reports. Do I have to add this?

  4. #4
    melody.anne is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    3
    I'm pretty sure my boss wants to email the currently open report and won't want to look through a list to do this.

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

Similar Threads

  1. Help on report to open form to open query...
    By saseymour in forum Programming
    Replies: 13
    Last Post: 07-16-2013, 08:11 AM
  2. Replies: 1
    Last Post: 09-14-2012, 10:27 AM
  3. Replies: 2
    Last Post: 05-11-2012, 11:52 AM
  4. Form Field open Default mail client
    By ducecoop in forum Access
    Replies: 4
    Last Post: 11-18-2010, 11:37 AM
  5. Open Outlook & populate e-mail
    By NISMOJim in forum Forms
    Replies: 7
    Last Post: 10-09-2010, 01:01 PM

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