IM Address won't map

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aazar - 27 Feb 2007 11:19 GMT

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).

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Feb 2007 14:28 GMT

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.

Signature

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

>I realise this is not a VB script group and apologize in advance but
> need help with following.
[quoted text clipped - 12 lines]
> anyone would use Excel as database is beyond me but that is what they
> do, least path of resistance).

Reply to this Message

Ken Slovak - [MVP - Outlook] - 27 Feb 2007 15:52 GMT

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.

Signature

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

Reply to this Message