Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sendobject command (97 sr2)

    I am using the sendobject command and I want to be able to choose a name from a dropdown on a form and have that name automatically enter into the to line of the e-mail(which is lotus notes). Forms![Form: Main Menu]![CBORep] is showing up instead. I have confirmed that the correct name is in that field, it just won't put the name into the to line. Can this be done?? Here is my code.

    DoCmd.SendObject acReport, "Rpt: Over/Under by rep individual", "RichTextFormat(*.rtf)", "Forms![Form: Main Menu]![CBORep]", "Cathy Knoll", "", "REPORTS", "", True, ""

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sendobject command (97 sr2)

    You shouldn't put quotes around Forms![Form: Main Menu]![CBORep], so try

    DoCmd.SendObject acReport, "Rpt: Over/Under by rep individual", "RichTextFormat(*.rtf)", Forms![Form: Main Menu]![CBORep], "Cathy Knoll", , "REPORTS", "", True

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sendobject command (97 sr2)

    Thank you very much.

    I was hoping it was something simple.

    Cathy

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: sendobject command (97 sr2)

    If you are running Lotus Notes on your PC can you just use SendObject to send an email from Access?

Posting Permissions

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