Email:   
Home
In This Issue
Email a Friend
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
THIS WEEK'S POWERTIP
Importing custom data into Outlook
By Diane Poremsky

This week a reader has a question about importing data into Outlook's forms:

I have bought a political database on MS Excel with more and different fields to those available in Outlook, into which I want to import it. I am not a technical wizard by any stretch of the imagination, but I would like to know if there is a publication or a simple development tool that would help me.
-- Lord Duncan McNair, West Sussex, UK

Thanks for writing, Duncan. As you've already discovered, you can't import custom fields into Outlook using the Import/Export Wizard. All is not lost, however.

You'll need to create a custom forms and can use VBA (Visual Basic for Applications) code to handle the import/export chores for your custom form. It's usually easiest to do it in VBA in either Outlook or the target or source program, such as Excel or Access.

Fortunately, you don't need to be an expert programmer as its not difficult code to write and many samples are available on the Internet that you can adapt for your needs. If you'd like to try your hand at writing your own code, you'll find links to helpful sites at http://www.slipstick.com/dev/customimport.htm and if you run into trouble, you can always visit Sue Mosher's Outlookcode.com for help.

If you really aren't a code writing kind of guy, there are some tools available that may do just what you need. You'll find several to choose from at http://www.slipstick.com/dev/customimport.htm.

Diane Poremsky is the president of CDOLive LLC and a Microsoft Outlook MVP. She's author of Teach Yourself Outlook 2003 in 24 Hours (Sam's, 2003) and coauthor of OneNote 2003 for Windows (Visual QuickStart Guide). For questions or suggestions for future columns, write her at outlook@cdolive.com.


ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
-- Advertisement --

EASY DEDICATED AND VIRTUAL DEDICATED SERVERS FOR AS LOW AS $67.99 PER MONTH
Customize and configure your own dedicated server. Simply choose one of our popular plans or select your own Linux or Windows server and plan options.

NO LONG WAITS. Server provisioned within hours.

Tap here now and be up and running with your own server tonight.

-- Advertisement --

Five Email Mistakes That'll Make You Look Like a Clown
Have you ever made any of these mistakes?

  • Forgotten to send an attachment you promised in a message
  • Replied-to-all, annoying everyone
  • Forgotten to Reply-to-All, annoying everyone
  • Sent emails using the wrong email account
  • Said something you oh-so-knew-better than to say

Send Guard can keep you looking good by saving you from yourself.

Tap here to download a fully-functional 30-day trial.

The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2009, ZATZ Publishing. All rights reserved worldwide.
Outlook is a trademark of Microsoft Corporation.
Editor's Login