Search OutlookPower's 8,351 Outlook and all-things-email article archive 
Home
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.
Twitter Feed Click here for the Twitter feed.
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.


Other articles you might like
Home > Using Outlook > Using Forms (3 articles)
   Working with Outlook forms: customize or use as-is?
   Adding a date stamp to the notes field
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent OutlookPower Articles
Can Outlook run when it's not running (and other mysteries)?
Exploring the dark side of social networks
How not to screw up when you send email
How to separate email accounts and still manage them
How to convert a PST file from an old format to a new format
Visnetic MailFlow can automate your organization's mail processing
How to make Outlook launch an app at a specific time?
OutlookPower News Center
Touch in Windows 7: Just for show?
Windows XP User: I'm No Thief
Windows 7 May Get Family Pack Discount
Microsoft Unleashes Five Service Packs for Its Enterprise Security Wares
Give an Old Desktop New Life
Europe won't pay more for Windows 7. Really!
IT wish list for SharePoint 2010: Keep it simple
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Eight steps to successful and reliable home backups
David Gewirtz Online: CNN commentary and analysis
DominoPower: What to look for in a Domino-based document management solution
-- Advertisement --

ONLINE GROUP CALENDAR - FOR UP TO 100 OF YOUR CLOSEST FRIENDS
Stay organized and in control with 24/7 access to all of your important events, projects and files --whether you're at work, at home or on the road.

You can share your calendar, projects and files so everyone in your office is up to date. Plus, search your entire group to find times when everyone is available to meet, manage company resources and much more.

Organize your entire team for as low as $9.95 per year (and yes, that's where the decimal place is supposed to be!)

Tap here to get started right away.

-- Advertisement --

BECOME CONFIDENT AND PRODUCTIVE WITH OUTLOOK 2007 IN SIX WEEKS
You can become a confident, productive user of Outlook 2007 in six weeks.

The Introduction to Outlook 2007 online course makes it happen in just twelve short lessons. The course features an instructor-led online discussion forum, regular assignments and quizzes, printable class notes, and a certificate of completion.

Learn more, then register today, at http://www.ed2go.com/courses/io7.
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
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