Results 1 to 7 of 7

Thread: Question

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Question

    How can I send one record to someone using e-mail?

    Create a button, then what do I do on next step? Please let me know, thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    There is all kinds of posts in this forum regarding this issue. See help with the SendObject function. As in DoCmd.SendObject .....

    The command would look something like this:

    Code:
    DoCmd.SendObject acSendReport, , DocFormat, Recipients, , , MailSubject, MailMessage, EditBeforeSendMail
    Customize the Report Preview tool bar to include a Send Mail button then associate this code to it via a function.


    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Sep 2005
    Posts
    28
    How can I set Automatically send the record by e-mail?

    Eg. The record is NOT approved, then send the record automatically using e-mail, and also if I don't get any approved of this record, then send it again automatically after 2 days, until we get approved of this record.

    Please help. Thanks.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19

    Question

    Something's strange here. It appears that either Accessman2 and Accessman3 are one and the same person, or they are two people doing the same exact project. A class project perhaps?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    He problely Just keeps forgeting this log in name LOL


    Why not Set up a New MSaccess front End And link the Tables in question

    Write a Query to filter the outstanding ones then


    use some vb to read the read the query and send the emails out

    I did the same thing on my Event Reporting System Wrote

    Then us the Scheduled teask to run it evey morning @ 7:30 The user started think i was starting early every morning

    Build a Maco Name Autoexec that Will Start when that .mdb file is open


    build a Function

    Function Send_Email()
    Dim db As Database
    Dim rs As Recordset

    Set db = CurrentDb

    Set rs = db.OpenRecordset("queryname")

    Do Until rs.EOF
    'bla
    'bla
    rs.MoveNext
    Loop

    Set db = Nothing
    Set rs = Nothing
    End Function


    know
    back to that macro

    add the line to
    RunCode

    the the Function name will be you Send_Email()

    then the Quit

    Done
    Last edited by myle; 09-25-05 at 18:31.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  6. #6
    Join Date
    Sep 2005
    Posts
    28
    Thank you so much.

    I have another question.

    If the database is open, then it will do automatic send, so it will open another application such as Outlook, Lotus Notes,,,etc (Have e-mail system), Then, I type e-mail address, and send it, right.

    Thanks.

  7. #7
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    IN the SendObject

    the last option should be set to True

    Read the Help

    Just full out the [to] bit in the SendObject

    From what I can rember think oput has to be runing on that machine
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •