(Solved) – Office – VBA – Contact FileAs name

  • by

I used the below document to fix my existing contact’s FileAs entry, but it didn’t work for contacts that were just company names.


Because the Firstname and Lastname fields were blank, it made the FileAs entry blank(” ” ” ” ” “).

How can I adjust the code to run a for loop that looks for the blank FileAs field and sets the CompanyName field as the FileAs field?

Leave a Reply

Your email address will not be published. Required fields are marked *