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

Best Fit Macro



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 6th 13, 05:24 AM
lms lms is offline
Junior Member
 
First recorded activity at Outlookbanter: Jun 2013
Posts: 8
Default Best Fit Macro

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
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
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


All times are GMT +1. The time now is 04:39 PM.


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.