![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I created a list of Defined Views that each one shows different fields in the columns of the contact folder. I then found this macro that is perfect that I can use to adjust the view of the contacts and decide which Defined View to show...but the Defined View field areas are not saving the "Best Fit" area for each field.....Is there something to add to the macro or another macro to automatically best fit all columns automatically using the macro?
Sub GetAssignedView_Name_of__Fields() Dim objViews As Views Dim objView As View ' Applies view to select folder Set objViews = Application.ActiveExplorer.CurrentFolder.Views 'Get the view Set objView = objViews.item("View Defined View Name") 'apply the view objView.Apply End Sub |
Ads |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Run a macro | Bre-x[_2_] | Outlook and VBA | 1 | July 15th 09 09:47 PM |
Set off VBA macro on email receipt then that macro accesses the emailcontent | [email protected] | Outlook and VBA | 3 | February 5th 09 01:14 AM |
OL 2003 crashes on macro (Alt-F8) or macro editor (Alt-F11) | mikewillnot | Outlook - General Queries | 0 | May 5th 08 04:42 PM |
Outlook macro abends but Word macro runs successfully | Jreue | Outlook and VBA | 0 | December 14th 06 12:55 AM |
Call macro stored in Excel workbook from Outlook's macro | Gvaram | Outlook and VBA | 5 | October 4th 06 07:26 AM |