Original code - change contacts in default folder | Change selected contacts in any folderĭim objContactsFolder As Outlook.MAPIFolder To save to your computer, right-click and choose 'Save Target as'. To use, open the text file and Select all (Ctrl+A), copy then paste into the VBA editor. To help eliminate errors, we have text files containing the VBA code samples available. You can run the macro later by pressing Alt+F8 (after selecting the Contacts folder) then choosing the macro and pressing Run. To use, select the Contacts folder in Outlook then return to the VBA Editor and press the Run button or F5 to run the macro. See Bulk change FileAs format to match Outlook's default setting for a version of this macro that reads the default setting in the registry and applies it to existing contacts. To test for a value (such as Company name) and use a different File As format if the value is empty, you need to use an If. See page 2 (or the text file below) for code sample 2 to change the FileAs format on selected contacts. (Uncomment the line by removing the apostrophe from in front of the strFileAs = command you wish to use.) Uncomment the strFileAs line that uses the format you desire before running it. Press Alt+F11 to open the VBA editor then copy and paste into ThisOutlookSession. The following code sample supports all 5 File As formats available in Outlook. Outlook will detect names separated by commas as Last, First format, regardless of the Fullname format setting. If you choose Last First format you don't need to use a comma to separate the names when you enter them and First Last1 Last2 correctly puts the name in the middle position into the last name field, not the middle name field. If the name order is wrong in FileAs ("Mary, Smith" when using last, first format), check this setting.
#Office 365 contacts sort last name full
This setting determines how the names populate the dialog when you press the Full name button.
The VBA code sample supports all 5 formats.Īlong with changing the File As order, you can change the order Outlook assumes you use when you enter the name. The file as format options are shown in the screenshot. You can do it using VBA or a utility (listed below). However changing the File As format on a large number of contact's is time-consuming when you need to change the contacts one by one. Outlook's Contact's offer a number of File As formats and this format can be used for the contact's name display in the Address Book.
0 kommentar(er)
