Auto-correct Contact fields' formatting?

Status
Not open for further replies.
M

MarkAtHome

Member
Outlook version
Outlook 2019 32-bit
Email Account
POP3
Hi -- does anyone know of an Outlook 2010 add-in/utility which, when run, goes through your Contacts and corrects any formatting errors it finds in all fields?

The issue reared its ugly head after trying to sync Android with Outlook 2010 using HTC Sync.

HTC Sync did a job on my Contacts:

  • If a company contact has no contact person, it wipes out FileAs, showing <Unnamed> in place of the company name
  • Android does not use spaces in phone numbers, so HTC Sync removed spaces from all phone numbers in my contacts
  • Android does not use nicknames, so the app deleted them from Outlook
  • DisplayAs now shows Lastname, Firstname <email address>, instead of Firstname Lastname <email address> and randomly did the same reversal with FileAs.
I went round and round with HTC on this. They acknowledge the problem, but refuse to be responsible for fixing the damage done, simply stating that there is a new version coming out. Duh...

Upon receiving a link to complete a satisfaction survey, I left my phone number. The following week I received a call from some female who was in over her head. I was polite, thanked her and told her that while I like HTC phones, I will never recommend their software.

So, I need an auto-fix. There are simply too many records to go through every field, one by one and manually fix them.

Thoughts?
 
Diane Poremsky said:
The FileAs and display name can be fixed with VBA -

http://www.slipstick.com/outlook/contacts/bulk-change-outlook-contacts-file-as-format/

http://www.slipstick.com/contacts/emaildisplayname.asp

to fix the phone # (it's just formatting - outlook has the underlying number without spaces too) you need to touch the field but i don't have a macro for that.

nicknames are gone - outlook doesn't use them either. :)

If you have a backup, restoring from their would be the easiest fix.
Click to expand...

Fantastic! You have made my day. Thanks, Diane.
 
Diane Poremsky said:
nicknames are gone - outlook doesn't use them either. :)
Click to expand...
Ah, but they were used all the time via MSVC with my WM phone! There weren't that many nicknames, so they were easily restored.

I have not yet found a suitable way to use them with Android on my WM phone... ;)
 
Diane Poremsky said:
But its not outlook <g>
Click to expand...
I called it Outlook Micro, to distinguish it as being lighter than Mini. ;)

Diane Poremsky said:
How do you like the droid compared to the WM?
Click to expand...
That is a very good question, Diane.

It has been a slow, ongoing adventure.

After settling on the WM ROM I wanted (Dutty), and personalizing it with an exact, working replica of the analog watch my wife bought me when I became a sexagenarian (Oris Oscar Peterson Limited Edition), I was bored.

I started out running various SD(card)-based ROMs, where I had a lot of fun going to the market and downloading anything that I thought I might ever have a use for (I was brought up with ya' never know... !), until I settled on a few ROMs that I liked.

Then I installed a WM-based multi-boot utility that enabled me to have as many SD ROMs available to run, as the card's memory limit would permit. Upon boot-up (WM), I was presented with a boot menu that defaulted to WM after x-seconds, with three or four different Android SD ROMs to choose from.

The version of WM I was using was fast and stable, and unless a bug fix, for whatever, is released, this ROM is at its graceful end. It also began to look and feel like old technology after playing around with Android, so I bit the bullet, backed up my WM ROM along with all my apps, desktop settings, data, etc., and flash a NAND-based ROM that overwrote WM.

While I have not seriously considered (yet) returning to WM, getting control over Android is a challenge met with vigor at XDA-Developers, where I learn something new every day.

Seeing that I was no longer provider plan tied (I was free!), when WP7 arrived, I immediately left the confines of my abode to actually visit a physical store. As soon as I held the phone and began swiping here and there, I thought WOW! Fast and Fluid.

But... that was as far as it got. At_that_time, there was no local, USB sync and the phone could not be used for mass storage -- total deal breakers for me, but I was still watching Microsoft to see if they would detail the update/fixes they planned and when they would become available... silence.

At the same time, I was also watching the ebbing availability of HTC's HD2, and its cost, when Amazon made it easy for me by offering me two HD2 phones (my wife and I) with plan for two cents, no activation.

From what I have seen since, I have yet to find a more capable phone. I can run WM6.5.x, WP7, Android, Meego, Ubuntu and Windows 95 (... and who knows... soon iPhone?), all available, at least as dual-booted systems, and some multi-boot. The HD2 runs WP7 faster than any of the originally released WP7 phones by HTC, Samsung or LG, should I ever decide to revisit it.

Not sure if I answered your question... it's past my nap time. :eek:
 
Thanks! I got as close thinking about a droid but my daughter needed a blackberry for med school so I stayed with BB so i could get her one on a buy one, get one free (mine was free too, thanks to new every 2).
 
Diane Poremsky said:
Thanks! I got as close thinking about a droid but my daughter needed a blackberry for med school so I stayed with BB so i could get her one on a buy one, get one free (mine was free too, thanks to new every 2).
Click to expand...
If I didn't have an innate need to futz with my devices, and wasn't as enamored with having the largest screen my aged fingers could reach, BB would have been the most logical choice. I am security oriented and fairly private, which is why one of my incompleted tasks is to find a way to control Google's access to my phone. While this is being addressed by others, it still isn't as easy as clicking "keep Google out" (WP7 is not that dissimilar).
 
Status
Not open for further replies.
< Seperating email accounts, Syncronizing, and a few newbie questions | Outlook 2010 reloading messages that have already been loaded >
Similar threads
Thread starter Title Forum Replies Date
M Outlook 365 VBA Auto-Forward Only the first of Duplicate Emails Outlook VBA and Custom Forms 2
D Auto Remove [EXTERNAL] from Subject + ConversationTopic (WITHOUT Redemption plug-in) Outlook VBA and Custom Forms 5
P Email address auto-completes work fine on laptop, but no longer on desktop Using Outlook 3
C New pc, new outlook, is it possible to import auto-complete emailaddress Using Outlook 5
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 4
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 5
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
nmanikrishnan Auto-reply from default account Using Outlook 1
A Imap account not auto syncing inbox at startup Using Outlook 0
K Run a script rule to auto 'send again' on undeliverable emails? Outlook VBA and Custom Forms 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S Auto forward for multiple emails Outlook VBA and Custom Forms 0
DDB VBA to Auto Insert Date and Time in the signature Outlook VBA and Custom Forms 2
V Auto-complete stopped working Using Outlook 4
D auto forward base on email address in body email Outlook VBA and Custom Forms 0
M Replyall macro with template and auto insert receptens Outlook VBA and Custom Forms 1
R Auto Forwarding with different "From" Outlook VBA and Custom Forms 0
P auto-complete is hopelessly broken Using Outlook 0
R Auto Assign Category colours to Incoming Emails based on whom the email is addressed Outlook VBA and Custom Forms 3
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
V Auto-Submitted: auto-replied in header Using Outlook 0
R Auto display of new email does not work on non-default account Outlook VBA and Custom Forms 0
B Outlook 2016 Auto-archive creates new folder Using Outlook 3
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
Q Prompt button to auto turn on Out of Office Outlook VBA and Custom Forms 3
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
S Messages moved / deleted by auto-archive are not synchronized to exchange Exchange Server Administration 8
B Outlook 2010 is Auto Purging when not configured for that Using Outlook 1
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
A Auto Accept Meetings from the General Calendar Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
Ms_Cynic Auto-pasting email content in calendar appt? Using Outlook 2
R How Do I insert images in and Auto Reply Using Outlook 3
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
P Auto scroll to specific folder in Folder Pane Outlook VBA and Custom Forms 3

Similar threads

Back
Top