Re: Exporting a range of cells in Excel to Outlook 2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: DennisF (DennisF_at_discussions.microsoft.com)
Date: 07/15/04


Date: Thu, 15 Jul 2004 01:27:03 -0700

Thx Karl. However, i gave some misleading info. I actually did import to the To: address as well as CC: address and BCC: address. None of this worked...also "values" is the name given to the right pane of the mapping custom fields popup. That is why I used this term. I know I am being stupid here...because if others can do this...certainly it is user brain failure. Pls review my process again and let me know if you see anything wrong based on my reply. Thanks

-- 
Thanks for your help
"Karl Timmermans" wrote:
> Email addresses should be imported to the appropriate "Email Address" field
> (there are 3 to choose from) - not the name field in a contact folder.Also,
> instead of mapping field "values" - suggest you map the field <names> and
> not the values.
> 
> Karl
> 
> -- 
> __________________________________________
> Karl Timmermans - The Claxton Group
> ContactGenie - Importer 1.3 / DataPorter 2.0
> "Power contact importers for MS Outlook '2000/2003"
> http://www.contactgenie.com
> 
> "DennisF" <DennisF@discussions.microsoft.com> wrote in message
> news:BADB6F1B-E95B-4885-9E64-F8C7598CB3AA@microsoft.com...
> > Hi, I read all the posts...let me make this as simple as possible. I
> created an excel doc with email addresses only in cell range A1-to A100...i
> named this range "Address". I closed the workbook and opened outlook.
> Created a folder called Addresses in my personal folders Directory. Chose
> import from another program or file. Chose Microsoft Excel as the source.
> Chose the exact file Address.xls. Allowed duplicates..Chose the target
> folder Addresses. Checked the box next to "Import "Address" into folder:
> Addresses. Choosing finish gave me 100 empty entries in the Addresses
> folder. I then tried same and instead...chose Map Custom Fields...I drag the
> first Value( an email address from cell A1) into the To:(Name) field...I can
> click next and drag as many as I want...the OK option remains greyed out
> meaning I can not finish the operation. I am fairly certain I am following
> the exact instructions as you would agree I am sure...however the effort
> remains in vain.
> >
> > Thanks for your help
> 
> 
> 


Relevant Pages

  • Re: Exporting a range of cells in Excel to Outlook 2003
    ... "Power contact importers for MS Outlook '2000/2003" ... Created a folder called Addresses in my personal folders Directory. ... Chose Microsoft Excel as the source. ... I then tried same and instead...chose Map Custom Fields...I drag the ...
    (microsoft.public.outlook.contacts)
  • Re: importing
    ... Is the contact in the folder you actually imported the contacts into? ... have multiple PST files with duplicate folder ... Karl Timmermans - The Claxton Group ... "Power contact importers for MS Outlook '2000/2003" ...
    (microsoft.public.outlook.contacts)
  • Re: User-defined fields in this item vs. folder
    ... Please refer to my original response regarding to the "user-defined ... indicates when a field gets added to the Folder and Items list). ... Karl Timmermans - The Claxton Group ...
    (microsoft.public.outlook.contacts)
  • Re: use customizedform for the exsisting contacts
    ... Karl Timmermans - The Claxton Group ... Sue Mosher, Outlook MVP ... folder MCls property shows as "read-only" or am I missing something ...
    (microsoft.public.outlook.program_vba)
  • Re: Outlook 2003 - CONTACTS - Unable to display folder folder is f
    ... Created Contacts1 folder and information is ... "Overview of Outlook e-mail Profiles" ... existing PST file before is done so that you always have a copy ... Karl Timmermans - The Claxton Group ...
    (microsoft.public.outlook.contacts)