Results 1 to 2 of 2
  1. #1
    Don is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Apr 2009
    Posts
    1

    Macro to send a report to an email address in a form


    If I use the sendobject macro command to send a report to a client, it appears that I have to type in the clients address in the To: field. What I want to do is design a macro that will look in a form to get the address rather than have to type it in every time. I am capable of creating a form that looks at the report and matches that to an address, which will then appear on the form; however, I can not get the address from the form to the To: field of the sendobj macro command. What else can I do.
    Don

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Don View Post
    ...I am capable of creating a form that looks at the report and matches that to an address, which will then appear on the form...
    Why don't you show us how you do this and maybe we'll be able to offer a suggestion for your issue?

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

Similar Threads

  1. Email a report of the current record.
    By jonudden in forum Reports
    Replies: 4
    Last Post: 08-21-2023, 07:37 AM
  2. Beginner trying to send email with attachment
    By ahm in forum Programming
    Replies: 2
    Last Post: 03-24-2009, 08:51 PM
  3. Email Report for each Vendor
    By dennisg in forum Reports
    Replies: 0
    Last Post: 09-29-2008, 02:43 PM
  4. Another email report question ...
    By valkyry in forum Reports
    Replies: 0
    Last Post: 05-23-2007, 11:42 PM
  5. Net Send from a button on an Access form
    By Deb4995 in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 10:19 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