Software

Ask something
Discussion Locked

Importing Contacts into Outlook

0 helpful
10 replies

by kymmie

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have hundreds of contacts to import and would like them to import with the "File As" attribute being by Company, instead of the default Last, First.

I have already tried customizing the view in Outlook, sorting by Company, however this does not change the "File As" attribute. Any suggestion would be appreciated. Thanks.

10 replies

by dklippert

If you wanted to really work at it, you can export to Excel and then massage the data before importing.
If you'll send me a note, I'll give you a macro I found that changes all Contacts to the FileAs order you want.

Here is a location for all kinds of information on Contacts and Address books:

http://www.slipstick.com/contacts/index.htm

(There are no spaces in the URL)

by kymmie

Thanks. However I am unfamiliar with programming. Can you give me the steps to implement the macro?

by dklippert

As easy a way as any other is to go to Tools>Macros. In the Macro name box type any thing. Now click on the Create button. Select all of the text that appears and delete it. Now paste in the text from the macro. Close and Save your way back to Outlook. Now you can go to Tools>Macro and you'll find "AllFileAsCompanyAndFullName" as a macro name. run this macro and all your troubles should be over.
(BTW I'd export all of my Conacts first so that I could reconstruct if necessary)

by kymmie

Okay. I am getting further, however while running the macro I received a compile error "Only comments may appear after End Sub, End Function, or End Property". In addition it is not changing the File As order for these contacts.

Where should thecopy start and end for the FileAsCode.txt?

by dklippert

I've found a MS solution that may be easier to use:

(Type the Q number in the search box at support.microsoft.com)

How to Change the File As Field for All Contacts

Q269172

by shanghai sam

This article states that "If you change the format of the File As field by using the standard Outlook contact form, Outlook ensures that the format of this field does not affect other areas where this type of information is displayed (such as at thetop of a contact when you view it in the Address Cards view". I do want the heading of each card to reflect the "File As" field. So, I am not sure whether this will help.

I deleted the macro code you suggested and tried again and this time I received a "runtime error 91 object variable or with block variable not set". Any other ideas. Thanks.

This discussion is closed to new replies.