Outlook reminder automation

Microsoft OFFICE

    Sponsored Links


  • 1. Excel Loop VBA, Extract And Compile Data
    I am looking for a vba loop that does the following. First it looks at a cell(A5) in an excel sheet (sheet name = "Report") then goes to another sheet(sheet name="Raw Data") and looks in the first column(A:A) for the value in Report'!A5, Each time it finds a match (there are going to be multiple else vlookup would have been a viable option) it cuts and pastes a range (Raw Data!B:F) from that row and pastes it into a range ("Report!A:E"). Any help would be greatly appreciated. Thanks in advance.
  • 2. Running SQL queries in ADO
    I have an an Excel spreadhseet that connects via ADO to a Access database, see code: Dim conAccessConnection As ADODB.Connection Set conAccessConnection = New ADODB.Connection conAccessConnection.Provider = "Microsoft.Jet.OLEDB.4.0" conAccessConnection.Open DATABASE_FILE I run a SQL qury as string Dim r As Recordset Set r = conAccessConnection.Execute(SQL_QUERY) Everything works fine until I use SUM and GROUP BY statements in SQL_QUERY when I get a <Method 'Execute' of object '_Connection' failed> I am using MDAC 2.7 on Windows XP Professional SP1 Any ideas?
  • 3. Removing table autoformatting - Isn't this group monitored?
    I was under the impression that paid MS employees monitor these groups and help MSDN subscribers who post here. Was I mistaken? I wrote: > Hello, > > Assume there is a table in a document with AutoFormat properties applied. > > Can I remove the AutoFormat properties without changing the table's current appearance > (basically "freezing" the table's current format)? > > Thanks. Best regards, Alex. -- Address email to user "response" at domain "alexoren" with suffix "com"
  • 4. Controlling menus of hosted MS-Word
    Hello people, I can easily manipulate the MS-Word menu items using Application.CommandBars.ActiveMenuBar.Controls. It works without problems both from COM add-ins and VBA macros. However, if the Word window is hosted in another application it no longer works. Try it yourself: 1) Open a Word document in Internet Explorer 2) display Application.CommandBars.ActiveMenuBar.Controls(1).Caption You get "&File", which is the first menu item. 3) Application.CommandBars.ActiveMenuBar.Controls(1).Delete Notice that the menu in IE did not change. 4) Sanity check: display Application.CommandBars.ActiveMenuBar.Controls(1).Caption again Now it is "&Edit", the 2nd menu item. So Word thinks that the menu item has been deleted but IE does not know anything about it! Same problem trying to add, enable/disable or show/hide menu items. No effect. Zilch. Nada. Here's what I am trying to do: I have a Word add-in written in C# that inserts its own menus. Some times I need to disable (or hide) them based on the current state of the document. Unfortunately, if the Word window is hosted in another application (IE, DsoFramer, you name it) it does not work. Any help is appreciated! Thanks, Alex. -- Address email to user "response" at domain "alexoren" with suffix "com"

Outlook reminder automation

Postby YmlsbEBzZW1wZi5uZXQubm9zcGFt » Wed, 21 Sep 2005 23:01:05 GMT

I need to send a reminder email to people other than whom an Outlook task is 
assigned when the task comes due.  Thoughts?


Similar Threads:

1.Using Automation to find and update a Task/Reminder in MS Outlook

Actually, all I need is VBA code sample for what is in the subject


"CBenac" wrote:

> I'm looking for VBA code to do the following:
> 1.Search for a task by [Subject] and add it if it doesn't exist
> 2. Add (append) text to the body of the task referecend above. 
> Thanks
> -- 
> CBenac

2.Outlook Automation Automation Problem Out of Memory

I'm not sure if I am posting to the right forum but I am having a problem 
with accessing Contacts with Outlook Automation.  The program works perfect 
in Outlook 2003 but gives an error on another computer with Outlook 2002. 
When I try and access the .Body I get an OLE Dispatch Error Code 4096 From 
Microsoft Outlook Out Of Memory.  I'm not sure if the problem is with 
Outlook, the computer or perhaps I could change my programming code and how 
I access the body in Outlook Contacts.

The code that gives the error is in VFP but it should be similar to VB so 
here's a snapshot if it helps.  I don't think it is a coding problem but I'm 
thinking perhaps there might be another way to access the body which might 
not give this error.

loOutlook = createobject('outlook.application')
loNS  = loOutlook.GetNameSpace('MAPI')
loDF  = loNS.GetDefaultFolder(olFolderContacts)
loItems = loDF.items

loItem = loItems.item(1)
? loItem.Body

Also, does anyone know offhand how to access the Email field(s).


3.How to set Outlook Importance property and Follow Up Reminder from VB .NET using CDO

This sample code demonstrates how to send an email message using CDO and
have it set the Outlook Importance property and the Outlook Follow Up
reminder attributes in the recipient's InBox.

The "Follow Up" reminder flag is set to one hour ago which causes the
received message's From, Subject and Date to immediately display in red
color in the recipient's Outlook InBox.

'Add references to:
'--Microsoft Active Data Objects (ADO)
'--Microsoft CDO for Exchange 2000
Dim oMsg As CDO.Message
Dim oFields As ADODB.Fields
Dim oField As ADODB.Field
  'Get reference to CDO message object
  oMsg = New CDO.Message
  oMsg.To = " XXXX@XXXXX.COM "
  oMsg.From = " XXXX@XXXXX.COM "
  'The Message object's default item property is read-only, however,
  'the ADODB Field object it returns to
  'has read/write access to the specific property
  'you requested
  'Get a reference to the "importance" property
  oField = oMsg.Fields.Item("urn:schemas:mailheader:importance")
  'Assign the property a "high" value
  oField.Value = "high"
  'This property specifies what type of Follow Up flag
  oMsg.Fields.Append("urn:schemas:mailheader:x-message-flag", _
            ADODB.DataTypeEnum.adVarChar, -1, _
            ADODB.FieldAttributeEnum.adFldFixed, "Follow Up")
   'When to Follow Up
   ' This sets the follow up time to one hour ago.
   ' This causes the message line in the Outlook InBox to be set to red
   ' as soon as the message is received.
   oMsg.Fields.Append("urn:schemas:httpmail:reply-by", _
              ADODB.DataTypeEnum.adVarChar, -1, _
              ADODB.FieldAttributeEnum.adFldFixed, DateAdd("s", -3600, Now))
   'Update the fields
   'Send the message
Catch ex As Exception
   Throw ex
    oMsg = Nothing
End Try

//End of Message//

4.Using the Calendar's "reminder" feature in Outlook

I would like to know if there is a way to configure my Outlook so that a
calendar event that I have a reminder set for will activate the reminder
even if Outlook isn't open. I normally use Outlook express, and find the
Outlook program slow and cumbersome, not to mention, it doesn't have a
newsreader, so I don't often have it open, and end up missing the reminders.
If this is not possible, does anyone know of a good program that can be used
to similiarily schedual events on a calendar, and be reminded of them at a
prescribed time before the event, by some sort of noise, etc. Thank you to
all who respond.


5.Handling Reminder in Outlook 2000

In Outlook 2000, how can I supress the Reminder Form/Window (using code)  
from popping up after the Reminder event?


6. only one vba script subject and attachment reminder in outlook 200

7. Set Reminder in Outlook (2007) from Excel VBA (2007)

8. Talking Outlook reminders, VBA, Free Talking Alarm Clock, source code

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 46 guest