Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Emailing non ACCESS objects within ACCESS (97 w/ NT4.0)

    I have been playing around with emailing(send Object) methods. I have just figured out a way to move information into a Word document using VBA. My question is that although it is easy to attach reports/forms etc to an email using send object, but is there a way to attach a word.doc from a folder on a computer using VBA? I would like it to be as seemless as the SendObject method for mailing a report. Any help or direction is greatly appreciated.

    Kevin
    Kevin

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Emailing non ACCESS objects within ACCESS (97 w/ NT4.0)

    I doubt that you can do it using SendObject because that is internal to Access. However, you should be able to do it using OLE, assuming the email app is OLE-compliant (Outlook is, Lotus Notes isn't <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>).
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Emailing non ACCESS objects within ACCESS (97 w/ NT4.0)

    Thank You, Any suggestions where I can search for the proper code to accomplish this? I really am not sure where to start looking with this one. I have a lot of the basic books, "Access 97 VBAPrograming" by Smith and Sussman and one of the "Unleashed books as well as the "Que" book by Jennings. None of which even hint on how to accomplish this.

    Thanks
    Kevin
    Kevin

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Emailing non ACCESS objects within ACCESS (97 w/ NT4.0)

    Since you're using 97, try to find the VBA Developer's Handbook, from Sybex. It was the companion volume to the Access 97 Developer's Handbook and it contains a lot of automation code.
    Charlotte

Posting Permissions

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