is there any option to send mail to specific person everyday at 3:00 PM sharp, even when the system is not connected to internet

[Rohith1324]

Hi,

I have a requirement that everyday sharp at specific time I want an email to be triggered from my outlook even when i'm not connected to internet.

Body of the mail remain same all the days
Receiver will remain same all the days

Regards,
Rohith

 

[MARK858]

If you are not connected to the internet what is it going to use to send

 

[Rohith1324]

If you are not connected to the internet what is it going to use to send

Just like few Addins we have in the outlook ...if you schedule the recurring message it automatically send the mail at specific time.

Not sure if I can take the name...but the addin is Boomerang

 

[MARK858]

Yes but if you have no connection what is it going to transmit via (a bit like having a landline phone and pulling out the phone line.. would you expect to make a call?)

 

[Rohith1324]

Yes but if you have no connection what is it going to transmit via (a bit like having a landline phone and pulling out the phone line.. would you expect to make a call?)

Yes, I really understand your question...but through the add I was able to setup the scheduler and even I was not connected it triggered the mail..

Not sure if the addin is used to store the message somewhre and release it at particular time.

 

[Rohith1324]

Yes, I really understand your question...but through the add I was able to setup the scheduler and even I was not connected it triggered the mail..

Not sure if the addin is used to store the message somewhre and release it at particular time.

but the addin is not affordable to send for recurring messages to I was thinking if we can do with the help of any VBA code

 

[MARK858]

As far as I know Boomerang doesn't send it at the time, it schedules it so it sits in your Outbox until you are online then it gets transmitted.

If that is all you are trying to do then the below code seems to do it if both Excel and Outlook are open (change the email address to a real email address).

Public Sub Example()
    Dim OutApp As Object
    Dim OutMail As Object

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    With OutMail
        .to = "me@whatever.com"
        .CC = ""
        .BCC = ""
        .Subject = "This is the Subject line"
        .Body = "Hi there"
        .DeferredDeliveryTime = DateSerial(Year(Now), Month(Now), Day(Now)) + #4:00:00 PM#
        .Send
    End With
    On Error GoTo 0

    Set OutMail = Nothing
    Set OutApp = Nothing
End Sub

Then use Windows scheduler to run the macro sometime before 3pm each day.

 

[Rohith1324]

As far as I know Boomerang doesn't send it at the time, it schedules it so it sits in your Outbox until you are online then it gets transmitted.

If that is all you are trying to do then the below code seems to do it if both Excel and Outlook are open (change the email address to a real email address).

Public Sub Example()
    Dim OutApp As Object
    Dim OutMail As Object

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    With OutMail
        .to = "me@whatever.com"
        .CC = ""
        .BCC = ""
        .Subject = "This is the Subject line"
        .Body = "Hi there"
        .DeferredDeliveryTime = DateSerial(Year(Now), Month(Now), Day(Now)) + #4:00:00 PM#
        .Send
    End With
    On Error GoTo 0

    Set OutMail = Nothing
    Set OutApp = Nothing
End Sub

Then use Windows scheduler to run the macro sometime before 3pm each day.

Thank you will try but I have 2 questions...

One you said excel to be open ? So what exactly I have to keep in excel

Second one you said window scheduler...I'm bit confused about this..

 

[MARK858]

One you said excel to be open ? So what exactly I have to keep in excel

An Excel file with the macro in (scheduler will open the file)

How To Automatically Run Excel VBA Macros Daily

Learn how to utilize a few programs you already have to create automation rules that will automatically open up your Excel files, run VBA code, save the changes, and then close the file. These automations can even be setup to run while you sleep!

www.thespreadsheetguru.com