Forum: Outlook and VBA
February 27th 09, 06:43 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 2
Views: 734
.ReminderTime inconsistancy
I don't understand it, but I have identified the fact that when creating a
new Task one must first set the ReminderTime and then The DueDate otherwise
it throws and error.
However, when performing...
|
Forum: Outlook and VBA
February 27th 09, 06:28 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 2
Views: 734
.ReminderTime inconsistancy
I have even tried hard-coding
..ReminderTime = Now()
and even that generates random dates with the current time?
QB
|
Forum: Outlook and VBA
February 27th 09, 06:12 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 2
Views: 734
.ReminderTime inconsistancy
Below is an extra of a function I am using to update a task item in Outlook
With olTask
.Subject = sSubject 'Reminder's subject line
.Body = sBody ...
|
Forum: Outlook and VBA
February 26th 09, 05:29 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 1
Views: 615
Edit Contact using EntryID
Hello,
I have the entryid for a contact item and am trying to find out how I can
use the Entryid to retrieve the contact item to update data and save it.
Below is an bit of my code to create a...
|
Forum: Outlook and VBA
February 25th 09, 07:30 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
Thank you so much. It worked like a charm! I had found another solution but
nowhere as simple as yours.
Please excuse my ignorance, but what exactly do these 2 lines accomplish?
Hopefull the...
|
Forum: Outlook and VBA
February 24th 09, 11:17 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
Revision to my previous statement. I just noticed that it is true that if
Outlook is launch by my function the task does not appear in the task list,
but if I open Outlook and wait 1-2minutes all...
|
Forum: Outlook and VBA
February 24th 09, 11:12 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
Here is my full function
************
Const olTaskItem = 3
Dim olApp As Object
Dim olTask As Object
On Error Resume Next
'Use late binding to connect to Outlook
Set olApp =...
|
Forum: Outlook and VBA
February 24th 09, 07:28 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
I did further testing and discovered that it returns an EntryId if Outlook is
already open and running. However, if my code launches outlook to add the
task and closes, it never returns a...
|
Forum: Outlook and VBA
February 24th 09, 07:11 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
I have gone to the extent of trying
.DueDate = DueDt
Debug.Print "'" & .EntryID & "'"
.Save
Debug.Print "'" & .EntryID & "'"
End With
Debug.Print "'" &...
|
Forum: Outlook and VBA
February 24th 09, 05:19 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
As such, should I not have been able to get the EntryID after the .save?
Such as:
.DueDate = DueDt
.Save
TaskId = .EntryId
End With
Why does this not work? What is...
|
Forum: Outlook and VBA
February 24th 09, 03:58 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 9
Views: 1,368
Get Task ID
I am using the following bit of code to create a task in Outlook from Access
Dim olApp As Outlook.Application
Dim olTask As Outlook.TaskItem
Set olApp =...
|
Forum: Outlook and VBA
December 8th 08, 07:04 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 1
Views: 471
Change Account Server/Port information
using vba, is it possible to switch a specific outlook profile's e-mail
account information ie: incoming/outgoing servers, incoming/outgoing server
ports?
Thank you
QB
|
Forum: Outlook and VBA
May 16th 08, 02:24 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 1
Views: 526
Iteration
I have a folder in my Inbox titled "Processing" that I need to iterate
through the mail items one by one and run another bit of code against but
can't seem to get my iteration to work?
Thank you...
|
Forum: Outlook and VBA
May 16th 08, 03:13 AM Posted to microsoft.public.outlook.program_vba
|
Replies: 4
Views: 505
Process E-mail attachements
Hello,
I have an e-mail with over 300 attachments (.eml format). I would need some
serious help to loop through each attachment file Grab the body content and
save it as a Text file with a unique...
|
Forum: Outlook and VBA
March 3rd 08, 03:30 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 3
Views: 464
add-in?
Ken,
Firstly, thank you or the response. In answer to your question, I am using
Outlook 2003 and was looking to program in vba. What is this COM addin your
mention and its difference to...
|
Forum: Outlook and VBA
February 29th 08, 06:55 PM Posted to microsoft.public.outlook.program_vba
|
Replies: 3
Views: 464
add-in?
Hello,
I would like to create a simple button to automate a currently manual task.
however, I then need to be able to easily deploy this 'add-in' (is that the
correct term) to other work...
|
Forum: Outlook and VBA
February 25th 08, 11:20 AM Posted to microsoft.public.outlook.program_vba
|
Replies: 3
Views: 488
Determine EntryID
Michael,
That is exactly my question. How can one do that, detrmine the EntryID of a
newly created contact item?
After the .save how can I determine and pass the EntryID for the newly
created...
|
Forum: Outlook and VBA
February 25th 08, 01:00 AM Posted to microsoft.public.outlook.program_vba
|
Replies: 3
Views: 488
Determine EntryID
Hello,
i am creating a new contact using vba
************
Set objFolder = myNameSpace.GetDefaultFolder(olFolderContacts)
Set objItems = objFolder.Items
With objItems.Add 'Create new...
|
Forum: Outlook and VBA
February 24th 08, 03:25 AM Posted to microsoft.public.outlook.program_vba
|
Replies: 2
Views: 526
Contact Listing
I managed to get the following function when I hard code the foldername, but
it will not take the select value from a combo box
Set myOlApp = CreateObject("Outlook.Application")
Set...
|
Forum: Outlook and VBA
February 24th 08, 02:50 AM Posted to microsoft.public.outlook.program_vba
|
Replies: 2
Views: 526
Contact Listing
Hello,
I'm trying to return a listing of contacts from a specific folder. I can
get it to work with the default Contact folder, but cannot get it to use
another folder. Below works, but only for...
|