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.
 
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
L Error when exporting Sent Mail to Excel Outlook VBA and Custom Forms 6
HarvMan Exporting IMAP OST file to PST Using Outlook 5
O Carriage Return - Line Feeds - exporting Calendar events Using Outlook 0
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
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 Using Outlook 0
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
P Email address auto-completes work fine on laptop, but no longer on desktop Using Outlook 2
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
Rupert Dragwater How to permanently remove an email address Using Outlook 9
Bardiferous Weird Contacts Behavior - Can't find any in any address book, but they're in there Using Outlook 3
L Specific Incoming Email Address Immediately Deleted Using Outlook 2
L Unable to Use Alias as From Address Using Outlook 2
H Preventing the 'email address fetch from Exchange' crashing email reading code Exchange Server Administration 0
D multiple email accounts - why do I have to choose the "from" account address?? Using Outlook 2
whizzard Change FROM address based on TO or CC address Outlook VBA and Custom Forms 8
C Outlook FROM ADDRESS -Outlook.com and Android Using Outlook 1
O What would be the recommended way to change an email address (family member)? Using Outlook 0
L Checking Sender Email Address for trusted domain from list on intranet Outlook VBA and Custom Forms 4
J How do you disable address search box when typing @ in body of email? Using Outlook 0
Victor.Ayala Automated way to check the option "Show this folder as an email Address Book" Outlook VBA and Custom Forms 2
D Wrong email address in Outlook 2003 "From" tab in new outgoing emails Using Outlook 4
M Gmail address associated with Outlook on new phone Using Outlook 9
e_a_g_l_e_p_i Outlook 2010 How to set default email address for website links Using Outlook 3

Similar threads

Back
Top