Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   IM Address won't map (http://www.outlookbanter.com/outlook-vba/42035-im-address-wont-map.html)

aazar February 27th 07 12:19 PM

IM Address won't map
 
I realise this is not a VB script group and apologize in advance but
need help with following.

1. I am trying to import some contacts into Contacts folder of Outlook
2003 but the stupid field mapping is missing the IM address in the
outlook contacts' list of fields, any ideas? How do I set up a custome
import template?

2. If I were to import it into a User Field could anyone point me to
where I can find a script to move the data from the User field (say
User 1) to another field (IM Address)? Not a VB script writer if
anyone can help with how to do it, I will be grateful.

Data I am trying to import are contacts in an Excel spreadsheet (why
anyone would use Excel as database is beyond me but that is what they
do, least path of resistance).


Sue Mosher [MVP-Outlook] February 27th 07 03:28 PM

IM Address won't map
 
1) You'd need to write your own import code or use a third-party tool. See http://www.outlookcode.com/d/customimport.htm

2) http://www.outlookcode.com/d/code/convertfields.htm might be what you're looking for. See http://www.outlookcode.com/d/vbabasics.htm if you need VBA essentials.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"aazar" wrote in message ups.com...
I realise this is not a VB script group and apologize in advance but
need help with following.

1. I am trying to import some contacts into Contacts folder of Outlook
2003 but the stupid field mapping is missing the IM address in the
outlook contacts' list of fields, any ideas? How do I set up a custome
import template?

2. If I were to import it into a User Field could anyone point me to
where I can find a script to move the data from the User field (say
User 1) to another field (IM Address)? Not a VB script writer if
anyone can help with how to do it, I will be grateful.

Data I am trying to import are contacts in an Excel spreadsheet (why
anyone would use Excel as database is beyond me but that is what they
do, least path of resistance).


Ken Slovak - [MVP - Outlook] February 27th 07 04:52 PM

IM Address won't map
 
There is no way of customizing the import mapper to use fields it does not
support. The only alternatives would be to either use code to read the Excel
sheet and do the import completely using code or after using the importer
going back using code to the sheet and reading any columns not imported and
adding that data to either built-in properties not supported or user
properties.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"aazar" wrote in message
ups.com...
I realise this is not a VB script group and apologize in advance but
need help with following.

1. I am trying to import some contacts into Contacts folder of Outlook
2003 but the stupid field mapping is missing the IM address in the
outlook contacts' list of fields, any ideas? How do I set up a custome
import template?

2. If I were to import it into a User Field could anyone point me to
where I can find a script to move the data from the User field (say
User 1) to another field (IM Address)? Not a VB script writer if
anyone can help with how to do it, I will be grateful.

Data I am trying to import are contacts in an Excel spreadsheet (why
anyone would use Excel as database is beyond me but that is what they
do, least path of resistance).




All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com