Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weekly email update
Does anyone know how can I automate
an email of an excel workbook(attached) to be sent out weekly? Thanks!! Michelle |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weekly email update
this link may assist you
http://www.cpearson.com/excel/ontime.htm -- Regards Corey wrote in message oups.com... Does anyone know how can I automate an email of an excel workbook(attached) to be sent out weekly? Thanks!! Michelle |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weekly email update
Corey wrote: this link may assist you http://www.cpearson.com/excel/ontime.htm -- Regards Corey wrote in message oups.com... Does anyone know how can I automate an email of an excel workbook(attached) to be sent out weekly? Thanks!! Michelle Okay so here's this frankenstein code I patched together. I keep getting an error about the Outlook.Appplication being not defined. I'm wondering if I could put this code in an outlook project... but how can I make it run if the workbook is closed? GAR! Sub Send_Msg() Dim objOL As New Outlook.Application Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) If today() = "Saturday" Then Exit Sub Else If today() = "Sunday" Then Exit Sub Else If today() = "Monday" Then Exit Sub Else If today() = "Tuesday" Then Exit Sub Else If today() = "Wednesday" Then Exit Sub Else If today() = "Thursday" Then Exit Sub Else If today() = "Friday" Then Application.OnTime ("24:00:00") With objMail .To = " .Subject = "Project Status Report" .Body = Range("A1:" & CurrentRegion) .AddAttachment "C:\Sales\Projects Status.xls" .Display End With End If End If End If End If End If End If End If Set objMail = Nothing Set objOL = Nothing End Sub Any help would be great!, thanks!!! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a payroll spreadsheet will update weekly? | New Users to Excel | |||
Chart displaying weekly data group in months without weekly labels | Charts and Charting in Excel | |||
Macro (I Think) To Update List in Workbook With Weekly Updates? | Excel Discussion (Misc queries) | |||
Entering New Weekly Data causes Summary Page to Update..How? | Excel Discussion (Misc queries) | |||
Weekly Email one sheet in workbook not saving contacts | Excel Worksheet Functions |