how can I get Outlook VBA to auto send an email out each Friday at 2PM?

[Marijke]

Hi,

I'm fairly new with this and just getting started, but could not find the information I was looking for.
I have managed to create a test mail, but thsi requires me to actually slect the macro i want to have run.
But that is the step i was looking to avoid, as now i still need to remember to send the email.
Is there some way to do this?

And how can i get my own signature included on those type of emails?

Thanks.

[Naveed Raza]

Is it what your looking for

try this.......

Please Login or Register  to view this content.

[Marijke]

Not exactly Naveed, or perhaps I'm not using it correctly....

This does indeed allow me to setup the em,ail, but how can I set a date/time in there so it runs automatically?
And I've tried including my mail into the Body of the email, but when i hit the enter button, it automatically shortens the body to the 1st line.

Thanks

[Naveed Raza]

can u provide what u have added to that code ?

[HaHoBe]

Hi, Naveed Raza,

you know that the question is asked in Outlook, not in Excel? AFAIR there is no timer available in the Outlook-Application (I might be wrong with that as the Office version of 2013 doesnīt have Outlook). And please make clear if the code you posted isnīt your own creation (looks very much like Ron de Bruin to me).

Ciao,
Holger

[Marijke]

so, although I can create a VBA project, it will always be manual, is that correct?
No way to auto trigger VBA to send emails at a certain time?