Results 1 to 12 of 12

Thread: [RESOLVED]Email with Access Macro or VBA?

Hybrid View

  1. Jun 19th, 2006, 09:01 AM #1
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Email with Access Macro or VBA?

    oh no.. dont use macros! they are EVIL!

    to send an email:
    VB Code:
    1. DoCmd.SendObject acSendReport, "rptName", , "TO here", "CC Here", "BCC Here", "Subject Here", "Message"
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  2. Jun 19th, 2006, 09:15 AM #2
    lilmark
    lilmark is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2006
    Posts
    367

    Re: Email with Access Macro or VBA?

    I tried using the following code...

    VB Code:
    1. DoCmd.SendObject acSendReport, "rptBldrSvrSDNewAcct", acFormatDAP, "[email protected]"

    acFormatDAP is for SnapShot, right?

    But, I get an error message saying...
    "The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry."
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width