Creating custom view with VBA

Status
Not open for further replies.
D

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.
 
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
 
While you can use VBA to create some views, you'd need to install it on each computer and have the user run it. Calvin's method is the one most people use and is easier than trying to do it using VBA.
 
Status
Not open for further replies.
< Printing PDF attachments of Outlook message attachments | Change From address while sending a new mail >
Similar threads
Thread starter Title Forum Replies Date
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
2 creating custom stationery Using Outlook 2
Fozzie Bear Creating Custom Meeting Form Outlook VBA and Custom Forms 6
S Creating custom rule to move if "NAME" is in body but ignore the phrase "Hi NAME" in the search Using Outlook 2
P Creating custom contact forms Using Outlook 2
F Creating Meeting Request Custom form and distribute it to domain user HELP!!! Using Outlook 0
F Creating Meeting Request Custom form and distribute it to domain user HELP!!! Using Outlook 0
L Creating Custom Rule to Forward emails to a BCC Using Outlook 1
A Help creating custom Contacts form - what type is 'Email' control? Outlook VBA and Custom Forms 1
T Outlook 2010 Creating a email 'Group' in OL 2010 Using Outlook 2
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
R Creating a user defined function Outlook VBA and Custom Forms 3
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
O How to prevent CC from showing when creating a new mail? Using Outlook 1
N Creating a button or link to a form in the Organizational Forms Library Outlook VBA and Custom Forms 3
B Creating an email with the list of tasks Outlook VBA and Custom Forms 0
L Creating drafts when I thought I was sending Using Outlook 1
R Would creating a new profile cause Outlook to download all the old mails from the server? Using Outlook 1
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
T Outlook creating a folder named: "Unwanted" Using Outlook 3
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
A Are categories still recommended for creating local distribution lists? Using Outlook 3
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
N Creating New Profile Using Outlook 0
M creating email from contact file = 3 emails in To field Using Outlook 3
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
A Creating an outlook rule to forward an email with a specific message Using Outlook 1
I Creating meeting invite with disabled tentative button Outlook VBA and Custom Forms 5
E Creating email templates for organizational use Using Outlook 0
N Creating or changing the main new mail message template in Outlook 2010 Using Outlook 2
J Outlook creating unwanted rule on its own Using Outlook 1
R Creating a Room Mailbox with Exchange Online Outlook VBA and Custom Forms 0
A Creating a rule on “Deleted items” folder Using Outlook 1
CMG73 Creating templates with predefined subject and CC Using Outlook 1
G Creating Contact Sub Folders Using Outlook 2
Rupert Dragwater creating gmail account in Outlook 2013 Using Outlook 7
nathandavies Creating a Select Case for a directory of folders Outlook VBA and Custom Forms 1
A Help creating macro for conditional formatting settings Using Outlook 8
U Creating a (This computer only) folder within an IMAP account directory Using Outlook 1
A Creating archive rule on the clients by script/ Outlook VBA and Custom Forms 3
J Creating a URL from a message body excerpt before forwarding Using Outlook 2

Similar threads

Back
Top