Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Send Object as email attachment (2002)

    I have the following code attached to the click event of a button in Access to send an email attachment through GroupWise to the person in the field called emailto. Note: the entire code is written all on one line.

    DoCmd.SendObject acReport, "emailLetter", "RichTextFormat(*.rtf)", emailto, "", "", "Registration Confirmation", "Please See the Attached Confirmation. Right click on it, choose open and MS Word will convert it from Rich Text Format", False, ""

    On some computers, this code works and the email message is sent immediately with the letter I want as an attachment.. On other computers the outgoing email message comes up on the screen with the attachment but without the email address or the message which must then be manually entered.

    Does anyone know of a setting that needs to be changed in Access or in GroupWise in order to make the code behave as it should.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send Object as email attachment (2002)

    I kept experimenting with various things to try to get this to work. When I tried copying a mapi32.dll file from the WindowsSystem32 folder of a computer that worked to one that didn't, that did the trick. It now works like it is supposed to do.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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