Exporting IM Address field

Status
Not open for further replies.

Nan

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
I use the wizard to export a contact folder but I use the field mapping because I don't want most of the fields.
But one of the fields I DO want is the IM address (I used it for some info I wanted on each contact) and it doesn't seem to appear in the field mapping list anywhere unless I'm just missing it somehow.

So now that I put some info in that field, I can't seem to get it back out.
Any ideas?

(Please don't send general explanation of how to export. That part I have. I specifically want to know how to export the IM address field. Thanks.)

Exporting to Excel although it shouldn't matter to what file I'm exporting. That field doesn't seem to be available for field mapping.

Thanks.
 

Nan

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Thanks. I tried that and the paste was a mess. That's cause I was including the Notes field. Exporting handled the Notes field beautifully. The Notes column was a bit weird, HOWEVER, all Notes were in the same column and all rows were 'single' looking until I clicked on a Notes cell. Then the rows got very big in height, but...all the weird stuff about Notes was contained within the cell, but the correct cell. When I tried the copy paste approach, I ended up with the Notes causing wrapping to other rows, setting everything after it off so the only info in the correct columns was the first row and a few more after that. I think any Notes that had a paragraph mark in them caused all the next rows to be off their correct columns by causing wrapping. But export was able to contain the paragraph mark wrapping in the correct cell.

Luckily, what I had in the IM address fields was indicators of something for which there were only 4 choices and the info was originally at the beginning of the notes field. So since I don't use the IM address (doesn't seem to work for the intended purpose - I IM via Skype and don't try to see the online status via Outlook which is what I read it was for) I decided to use it for this other purpose for which Outlook has no functionality. I needed to put in one of the 4 choices so I had a way to sort on that info. So I exported to Excel, sorted by Notes which worked and since this choice of 4 indicators was at the beginning of the Notes field I was able to quickly fill in the IM Address column I created.

But I did still want to know how to export it for the future but I guess I can't. Had the info in IM address been different for each and every contact, like it was designed to be, it would have been impossible to type them all in again.

Is the 'wizard' the only way to export? I know in some situations there's a 'wizard' and then there's a more manual way of doing things, like setting up an email account in Outlook for example. We go into the 'manual settings'.
So then are you telling me that the list in field mapping in the wizard are THE only exportable fields? If so, I'll copy those down so going forward I'll know that if I want to export I better use one of those fields.
Problem was I wanted a field on the home screen of contacts.
The only other ones are a phone field but those are self-formatting so that doesn't quite work.
Or 'other address' but I didn't want to have to keep going back and forth with the down arrow to see the info.
IM address is perfect - shows, handles text correctly, isn't being used, doesn't require custom form.
What a shame it can't be exported.

Oh wait...I just thought of a combo of my way and your way. I guess I could export it all, sort Excel and Outlook on the same field, like last name, then copy and paste just the IM address field and last name field (since I have more than one person per company) into Excel right beside the last name column in Excel so I can see that the Outlook rows are truly aligned with the correct Excel rows, then delete the now duplicate last name column in Excel and voila! Wish I had thought of this yesterday but your copy and paste suggestion just triggered it....:) Oh well, next time I'll know for ANY field that doesn't export.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
C How to get SMTP out of email address when exporting contacts? Using Outlook 2
P Exporting group members from Outlook address group Using Outlook 11
GregS Exporting contacts Using Outlook 1
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
R Exporting recovered Deleted Items outside the Inbox Using Outlook 1
E Exporting email (.pst) Using Outlook 8
T exporting contacts names reversed in CSV file Using Outlook 8
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
D EXPORTING MS EXCHANGE EMAILS to another platform Exchange Server Administration 10
R Exporting contacts from 2010 to 2013 Using Outlook 1
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
A Exporting email in outlook 2013 with Office 365 Using Outlook 1
Diane Poremsky Fix the Outlook Folder Type after Exporting an IMAP Account New Slipstick.com Articles 0
V Unknown error when exporting to a PST Outlook Wishlist 2
V Exporting RSS Feed to OPML file Using Outlook 8
D Reoccuring appointment issues when exporting Calendar to Excel Using Outlook 3
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
Commodore Exporting all contacts to VCF files possible? Using Outlook 4
C Security Question - How to prevent users exporting .iaf files Using Outlook 5
M Error Messages when exporting Outlook 2010 Contacts to a CSV (DOS) or Excel Using Outlook 2
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
C extra characters added to email when exporting Using Outlook 2
H Exporting Outlook Forms to Access or Excel Outlook VBA and Custom Forms 2
F Outlook 2007 BCM Exporting Files BCM (Business Contact Manager) 2
T Automating Exporting to pst file Outlook VBA and Custom Forms 3
G exporting files from BCM BCM (Business Contact Manager) 1
G exporting from BCM BCM (Business Contact Manager) 1
D Exporting reports to Excel gives wrong numbers BCM (Business Contact Manager) 1
H Error in values when exporting report to Excel BCM (Business Contact Manager) 1
N contact list seen in Contact folder but knot in Address book or when 'TO' button is clicked in new email Using Outlook 0
C WARNING - DO NOT USE AN OUTLOOK.COM ADDRESS FOR GOOGLE ACCOUNT RECOVERY EMAIL Using Outlook 10
D Outlook Address Book Using Outlook 0
Terry Sullivan Sender Field Displays My E-Mail Address, Not My Name Using Outlook 1
L Email with correct To address but displaying name of a related person Using Outlook 0
1 Incorrectly Setup a Rule at Domain level to not allow address from outside domain Exchange Server Administration 2
D Is a sub folder under contacts necessary to be able to name an Address Book? Using Outlook 1
A Outlook replies not using "delivered to" address in From Using Outlook 1
T "Words In Recipient's Address" Rule Causes Outlook To Stop Processing Rules Using Outlook 3
B Extracting email addresses from a folder - how to also get the name of the person the address is for? Using Outlook 5
W Replyin to the reply-to email address Outlook VBA and Custom Forms 0
M Changing the preferred order for "Put this entry in" list for adding new contacts to the Address Book Using Outlook 1
B Change from Address Outlook VBA and Custom Forms 0
D Renaming Address Book Using Outlook 3
J Sent Items Folder NOT Showing Correct From Email Address Using Outlook 0
J Outlook Reply > From > Other Email Address... > Address Not Showing in Sent Items... From Email Outlook VBA and Custom Forms 0
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
C Outlook Autocomplete suggestions showing wrong person's name against an email address Using Outlook 0
O Address list - company and non-company ? Using Outlook 0
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
L Email not going to address displayed Using Outlook 4

Similar threads

Top