Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / February 2006

Tip: Looking for answers? Try searching our database.

Import from excel into a custom form and fields  in Contacts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John - 01 Feb 2006 02:51 GMT
I have taken the default contact form and added and deleted some controls to
more represent a chain of retail stores.  Main concerns were to have

Store name
Store number
Region
Buying Office
Manager
Asst.Manager
District
etc, as well as the usual items

For each new item, I added a a label and textbox, opened the textbox
properties and change the name and created a new field (eg. txtStoreName) in
design mode

I designed and created enough fields to correspond with an Excel Spreadsheet
that I receive from the store chain corp office, which has each store in on
row... each column a seperate field.

I then published the new form to the folder, say, "retail stores", which was
under the contacts folder.  I set the properties of this folder to
Under the general tab - when posting to this folder use... I pick the new
form
Under the form tab - i associated the new form with the folder

One would think all was going well at this point.

Whenever I try to import the named range on the excel sheet, I get stuck at
the point where I need to map the fields.  The only fields available to map
to appear to be the standard fields... None of my new fields appear.

Can someone tell me why?  Please
Sue Mosher [MVP-Outlook] - 01 Feb 2006 14:37 GMT
See my response to your post in another group.

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 have taken the default contact form and added and deleted some controls to
> more represent a chain of retail stores.  Main concerns were to have
[quoted text clipped - 29 lines]
>
> Can someone tell me why?  Please
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.