• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Immediate send of VB created email versus delayed

C

ccarruth

Member
I see many examples of using Excel info, with VB, to create and send emails via Outlook object (instance). The developer has coded this, using .oft files versus using a body reference in the code (which is good), but have simple question...

Is there a difference in code between sending an email immediately and placing email in the Outbox so it is subject to the "send" settings that Outlook contains? Right now it sends it directly, bypassing the Outbox.

I need control over when it is sent..for now. Don't want the emails being sent without being reviewed.

And no I can't post the code..if no straight answer will see if possible...thanks all.

Chris
 
Not really, it will display the mail for you to review before sending.

Otherwise just use ".Save" it will save mail in drafts.
 
Is there a way to "save" it to Outbox? Saving in drafts not so helpful. Want to use Outbox "send" setting in Outlook to manage when sent, including intervals between sending each email. If saved to drafts have to go in and manually move to Outbox. Doable but if that step could be eliminated much better.

C
 
Try using ".SaveAs" with path then.

But even if in drafts. You can set macro in Outlook to send emails from there.
 
You must log in or register to reply here.
Back
Top