A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Retrieving sent items



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 8th 07, 03:43 PM posted to microsoft.public.outlook.program_vba
Maurice
external usenet poster
 
Posts: 48
Default Retrieving sent items

Hi,

specs: Outlook2003 WinXP

In my database I want to store the data I sent via Outlook. My plan is to be
able to retract certain appointments if necassary. I thought I use the
EntryID for this and add this to my database. The EntryID however is only
there when the appointment is delivered. So not a steady, reliable situation.
What kind of 'stamp' can I add to an appointment, mail or task so I can check
my Sent Items to maybe retract an appointment via my Access database.

e.g. Send an appointment via Access - Outlook. Record is saved in database.
Now I want to retract the appointment via the database. Record has some sort
of [stamp] or unique identifier which I can check the sent items folder with
to retract the appointment from the database with.

Hope this makes any sense otherwise let me know and i'll try to rephrase it.

Thanks for any help in advance..
--
Maurice Ausum
  #2  
Old October 8th 07, 04:12 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Retrieving sent items

If this is for Outlook 2003 or later you can use GlobalObjectID but that and
EntryID are only valid after an item is sent.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Maurice" wrote in message
news
Hi,

specs: Outlook2003 WinXP

In my database I want to store the data I sent via Outlook. My plan is to
be
able to retract certain appointments if necassary. I thought I use the
EntryID for this and add this to my database. The EntryID however is only
there when the appointment is delivered. So not a steady, reliable
situation.
What kind of 'stamp' can I add to an appointment, mail or task so I can
check
my Sent Items to maybe retract an appointment via my Access database.

e.g. Send an appointment via Access - Outlook. Record is saved in
database.
Now I want to retract the appointment via the database. Record has some
sort
of [stamp] or unique identifier which I can check the sent items folder
with
to retract the appointment from the database with.

Hope this makes any sense otherwise let me know and i'll try to rephrase
it.

Thanks for any help in advance..
--
Maurice Ausum


  #3  
Old October 8th 07, 05:00 PM posted to microsoft.public.outlook.program_vba
Maurice
external usenet poster
 
Posts: 48
Default Retrieving sent items

Hi ken,

My point exactly. It's for outlook 2003. I tried reading the EntryID but I
could obly get that when the item was actually sent. Strange thing is that
when I run the code
the message is immediatly set in the sent items folder but it doesn't have
an EntryID yet.

I tried sending a mail to myself. The mail was immediately in sent items. I
went through sent items via VBA and it did recognize the mail as being there
but it didn't have an EntryID until I received the mail. Strange, so Outlook
must do some updating by itself when the mail is actually delivered because
it looks like that's the moment when the EntryID is designated to the sent
item.

What would your advise be in this case, create an own unique key. If so how
can I designated that to let's say a mail?

Thanks for the info so far...
--
Maurice Ausum


"Ken Slovak - [MVP - Outlook]" wrote:

If this is for Outlook 2003 or later you can use GlobalObjectID but that and
EntryID are only valid after an item is sent.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Maurice" wrote in message
news
Hi,

specs: Outlook2003 WinXP

In my database I want to store the data I sent via Outlook. My plan is to
be
able to retract certain appointments if necassary. I thought I use the
EntryID for this and add this to my database. The EntryID however is only
there when the appointment is delivered. So not a steady, reliable
situation.
What kind of 'stamp' can I add to an appointment, mail or task so I can
check
my Sent Items to maybe retract an appointment via my Access database.

e.g. Send an appointment via Access - Outlook. Record is saved in
database.
Now I want to retract the appointment via the database. Record has some
sort
of [stamp] or unique identifier which I can check the sent items folder
with
to retract the appointment from the database with.

Hope this makes any sense otherwise let me know and i'll try to rephrase
it.

Thanks for any help in advance..
--
Maurice Ausum



  #4  
Old October 8th 07, 09:25 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Retrieving sent items

An item should always have EntryID after it's sent, I've never seen it not
have one. However, why not just save the item first and then send it. Of
course if it's an Exchange mailbox then EntryID would change when the item
is moved to Sent Items, in a PST file EntryID wouldn't change.

Are you positive that no EntryID is on the item right after it's sent and
moved to Sent Items? I'd run an ItemAdd handler on that folder to verify
that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Maurice" wrote in message
news
Hi ken,

My point exactly. It's for outlook 2003. I tried reading the EntryID but I
could obly get that when the item was actually sent. Strange thing is that
when I run the code
the message is immediatly set in the sent items folder but it doesn't have
an EntryID yet.

I tried sending a mail to myself. The mail was immediately in sent items.
I
went through sent items via VBA and it did recognize the mail as being
there
but it didn't have an EntryID until I received the mail. Strange, so
Outlook
must do some updating by itself when the mail is actually delivered
because
it looks like that's the moment when the EntryID is designated to the sent
item.

What would your advise be in this case, create an own unique key. If so
how
can I designated that to let's say a mail?

Thanks for the info so far...
--
Maurice Ausum


  #5  
Old October 9th 07, 02:06 AM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Retrieving sent items

Also keep in mind that the appointment itself is never sent, only an
invitation/update/cancelation is.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Ken Slovak - [MVP - Outlook]" wrote in message
...
An item should always have EntryID after it's sent, I've never seen it not
have one. However, why not just save the item first and then send it. Of
course if it's an Exchange mailbox then EntryID would change when the item
is moved to Sent Items, in a PST file EntryID wouldn't change.

Are you positive that no EntryID is on the item right after it's sent and
moved to Sent Items? I'd run an ItemAdd handler on that folder to verify
that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Maurice" wrote in message
news
Hi ken,

My point exactly. It's for outlook 2003. I tried reading the EntryID but
I
could obly get that when the item was actually sent. Strange thing is
that
when I run the code
the message is immediatly set in the sent items folder but it doesn't
have
an EntryID yet.

I tried sending a mail to myself. The mail was immediately in sent items.
I
went through sent items via VBA and it did recognize the mail as being
there
but it didn't have an EntryID until I received the mail. Strange, so
Outlook
must do some updating by itself when the mail is actually delivered
because
it looks like that's the moment when the EntryID is designated to the
sent
item.

What would your advise be in this case, create an own unique key. If so
how
can I designated that to let's say a mail?

Thanks for the info so far...
--
Maurice Ausum




  #6  
Old October 9th 07, 08:19 PM posted to microsoft.public.outlook.program_vba
Maurice
external usenet poster
 
Posts: 48
Default Retrieving sent items

Ken,

I'll rerun the code several times to double check. By head the code runs
well, sending the item and directly looping through the sent items folder to
check for the sent item. I'll post the code so you can take a look at it..

Thanks for the replies..
--
Maurice Ausum


"Ken Slovak - [MVP - Outlook]" wrote:

An item should always have EntryID after it's sent, I've never seen it not
have one. However, why not just save the item first and then send it. Of
course if it's an Exchange mailbox then EntryID would change when the item
is moved to Sent Items, in a PST file EntryID wouldn't change.

Are you positive that no EntryID is on the item right after it's sent and
moved to Sent Items? I'd run an ItemAdd handler on that folder to verify
that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Maurice" wrote in message
news
Hi ken,

My point exactly. It's for outlook 2003. I tried reading the EntryID but I
could obly get that when the item was actually sent. Strange thing is that
when I run the code
the message is immediatly set in the sent items folder but it doesn't have
an EntryID yet.

I tried sending a mail to myself. The mail was immediately in sent items.
I
went through sent items via VBA and it did recognize the mail as being
there
but it didn't have an EntryID until I received the mail. Strange, so
Outlook
must do some updating by itself when the mail is actually delivered
because
it looks like that's the moment when the EntryID is designated to the sent
item.

What would your advise be in this case, create an own unique key. If so
how
can I designated that to let's say a mail?

Thanks for the info so far...
--
Maurice Ausum



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow retrieving items from Outlook Simon Maystre Outlook and VBA 11 December 17th 08 06:57 PM
help with retrieving info gena Outlook Express 6 June 22nd 07 03:05 PM
error retrieving folder.items.count kappe79 Outlook and VBA 3 September 19th 06 01:29 PM
Retrieving information from incomming mail items. Jan G. Thorstensen Outlook and VBA 1 September 18th 06 05:45 AM
Retrieving messages peterson89 Outlook - General Queries 5 August 23rd 06 12:10 PM


All times are GMT +1. The time now is 05:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.