Creating custom view with VBA

Status
Not open for further replies.

DanTheMan

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi all.

I have created a custom view that I now need to share with 30+ users.
I am hoping this can be done using VBA to save me from re-creating individually.

I'm new to VBA in outlook and am completely lost without the recorder.
Ideally I would like code that does the following.

Current folder>
  • add user-defined fields
  • allow in cell editing
  • remove unwanted default fields
  • save view
I would need three field types adding as follows

Name: Type1
Type: Text
Format: Text

Name: Type2
Type: Date/Time
Format: Best Fit

Name: Type3
Type: Formula
Formula: [Received]

Any help would be very much appreciated.

Many thanks,

Dan.
 

Calvin

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
In the past I've done this by copying the view in an empty PST. Then I've attached the PST to each user to copy the views. Not so fast, but better than recreate the views every time. I don't know if it's your case, I hope it helps. If you are dealing with Exchange mailbox maybe exfolders could help too.
good luck
 
Status
Not open for further replies.
Top