set user-defined email fields

[Guest]

I want to establish a user defined field in my email view and set it as a
date (mm/dd/yy) that is derived from the date-time stamp of the recieved
field. I added the field but i dont know how to update it - can anyone help?
am after a view that shows me all messages for a day then grouped by user

 

[Sue Mosher [MVP-Outlook]]

You can update it by displaying the mail folder in a table view with in-cell editing turned on.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sue,

Can you point me to the help link where display folder in table view and
in-cell edit could be found or some other resource?

thanks,

joel

 

[Sue Mosher [MVP-Outlook]]

Just use the View menu to drill down to the Customize Current View or Define Views command. In-cell editing settings are in view settings under Other Settings.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sue - thanks that certainly got the field out there and got it to where it is
updatable but i am also looking to set it -hopefully automatically /
programatically to the month day and year of the date time stamp of the
received field - is there a way to do that ?

 

[Sue Mosher [MVP-Outlook]]

Sorry, I missed the indications in your earlier posts that you wanted something to happen automatically, and it's still not clear to me exactly what you want to happen that's different from what the Received field already does. Can you explain in more detail?

In the meantime, since you're probably going to have to write VBA code to do whatever it is you have in mind, you might start at http://www.outlookcode.com/d/vbabasics.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

sue,

thanks here's what i am trying to do:

I want to create a view in outlook 2003 for my email messages that groups all
messages by date (mm/dd) and then by from so:

april 5
John
message 1
message 2
message 3
sally
message 1
message 2
message 3
april 6
Don
message 1
John
message 1

if i use recieved it doesnt summarize by day

thanks,

joel

 

[Brian Tillman]

if i use recieved it doesnt summarize by day

It does if you group by date.

 

[Sue Mosher [MVP-Outlook]]

Not quite. It might group by Outlook 2003's Today, Yesterday, etc. but would go to Last Week after the first few days.

For what Joel needs, he'd have to run VBA code to put a date into either of the standard text fields that Outlook doesn't normally use -- Mileage or BillingInformation. We need to wait to hear whether he feels up to that and what version of Outlook he's using, since that will determine what code to use.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Brian,

if i choose the arrange by date feature it doesnt seem to let me choose a
secondary grouping on FROM - if there's a canned way to do this i would
prefer it over writing code

thanks,

joel

 

[Brian Tillman]

if i choose the arrange by date feature it doesnt seem to let me
choose a secondary grouping on FROM - if there's a canned way to do
this i would prefer it over writing code

True, groups aren't tiered, but if you sort by sender, then group by date,
it should come close. You should consider taking Sue's advice as well, for
a more exact solution.

 

[Guest]

outlook 2003 11.8002.6408 service pack 1
can you point me to a code shell to use ?

 

[Sue Mosher [MVP-Outlook]]

This code in the built-in ThisOutlookSession module should process all incoming items and stamp the BillingInformation field with the date value (not the time details) from the Received date:

Private Sub Application_NewMailEx(ByVal EntryIDCollection As String)
Dim arr() As String
Dim i As Integer
Dim m As MailItem
On Error Resume Next
arr = Split(EntryIDCollection, ",")
For i = 0 To UBound(arr)
Set m = Application.Session.GetItemFromID(arr(i))
m.BillingInformation = CDate(Format(m.ReceivedTime, "dd mmm yyyy"))
m.Save
Next
End Sub

For Outlook VBA basics, see http://www.outlookcode.com/d/vbabasics.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

outlook 2003 11.8002.6408 service pack 1
can you point me to a code shell to use ?

 

[Guest]

Sue,

Works like a charm for new entries any way to write a code snipet to update
my inventory of 6000 emails with the same update?

thanks,

joel

 

[Sue Mosher [MVP-Outlook]]

Iterate the folder that contains the items, set the property, and save. See http://www.outlookcode.com/d/code/convertfields.htm for an example using the Contacts folder.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Sue,

Works like a charm for new entries any way to write a code snipet to update
my inventory of 6000 emails with the same update?

thanks,

joel

 

[Guest]

This really helped me, thanks a lot. There is something I would like to ask,
though... is there any way that a field can be edited through a drop-down
menu? That is... I have some fields for which I would like to have a few
options, and not letting the user write anything on it...

And yet something else. Is there any way in which only this fields I have
created can be edited? Because the in-cell editing option you talk about in
this thread, lets you actually edit any field...

Thanks in advance

 

[Sue Mosher [MVP-Outlook]]

No, Outlook does not support custom drop-down lists in views, and users can edit any fields using in-cell editing.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers