Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    setting who an email is from (access 2003)

    Is there a way to edit the code below to set who the email is from? The from in the email would be the same email address everytime. Obviuosly .from does not work. Any ideas? Thanks...

    Set objDoc = objWord.Documents.Open("c:tempword.doc")
    With objDoc.MailEnvelope.Item
    .To = Nz(srt, "")
    .Subject = strSubject
    '.From = "something@aol.com" Set emai address
    .Send

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

    Re: setting who an email is from (access 2003)

    This is not an Access question.

    I don't think you can set that with MailEnvelope.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: setting who an email is from (access 2003)

    Good point Hans. I use this so much I forgot. I think you are right though..

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

    Re: setting who an email is from (access 2003)

    Reposted in the VB/VBA forum. Please post all replies there; this thread is locked to avoid duplication.

Posting Permissions

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