Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro to automate sending of emails (2003)

    Is it possible to create a macro in VBA that will automatically send the same attachment to the same person at a specified time during the day?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro to automate sending of emails (2003)

    Please provide more detail - what email client, and what kind of attachment? It can be done with Outlook, provided Outlook is running when the macro is scheduled to run, or it can be done via other MS Office apps.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to automate sending of emails (2003)

    The attachments are 2 excel documents, email client is Outlook

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to automate sending of emails (2003)

    You could check out <post:=646,370>post 646,370</post:> and replies.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro to automate sending of emails (2003)

    Am I missing something or do these links lead to third party solutions?
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro to automate sending of emails (2003)

    If you would prefer to run this from Excel, start by reviewing Ron DeBruin's Sendmail page, and search the Excel Forum for examples of setting a time to run code. If from Outlook, search http://www.outlookcode.com for examples such as Sending attachments (a very basic example).

    Since your question was very general, and the answer is "yes", I'm not sure what further assistance you want, or if a third party solution is a viable alternative.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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