Outlook Macro

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

excel2006

Thread Starter
Joined
Nov 1, 2007
Messages
1
Hi

want a mcro that allows me to send the same message out at a paticular time every week day to the same recipients. How can this be done?
 
Joined
Sep 4, 2003
Messages
4,916
You can use a VBS script with Outlook to create and send the email. Copy the code below into a text file and rename with the extension .vbs

Then use Windows built in task scheduler (found in Control Panel) to call the script at your predetermined times. You can also create an Outlook template file and use Visual Basic to open and send it automatically.

Code:
Dim Outlook 
  Set Outlook = CreateObject("Outlook.Application")
  Dim Message 
  Set Message = Outlook.CreateItem(olMailItem)
  With Message
    .to = "[email protected]"
    .subject = "This is your subject"
    .body = "This is the body"
    .Attachments.Add ("C:\TEST.xls")
    .Send
   end with
Regards,
Rollin
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top