Search OutlookPower's 8,977 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
Running auto-respond rules when Outlook is closed
Running rules when Outlook is closed
Disappearing text that's not supposed to disappear
What to do when Outlook complains about a program you know you uninstalled
Nothing says new year better than emails from crazy people
Say goodbye to the Uh-Ohs. Long live the Tens.
How to have a clean inbox in 2010
OutlookPower News Center
US scientists get free cloud on-ramp
Leaky anti-virus defences letting malware through
Patch Tuesday Release Will Tie Microsoft's Record
Microsoft to Drop Linux, Unix Versions of Enterprise Search
Microsoft May Launch New Office Cloud License
Microsoft to Stop Selling Display Ads for Facebook
Microsoft to fix 26 flaws in Windows, Office
>> Read all the news
More from the ZATZ journals
Computing Unplugged: The iPad: Apple's latest heartbreaker
David Gewirtz Online: CNN commentary and analysis
DominoPower: Lotusphere 2010: mobility and collaboration
-- Advertisement --

BLOGGING AND PODCASTING WITH ONE EASY-TO-USE TOOL
Now you can publish your thoughts, opinions, and comments in your own blog or podcast.

  • Supports multiple authors and multiple blogs or podcasts.
  • Generate and publish RSS feeds for iTunes and other directories.
  • Post photos, images or animations.
  • Get feedback and have conversations with visitors to your site.

Personalize your blog or podcast with your own unique domain name -- or integrate it with your existing site by setting it up as a subdomain.

Tap here and get blogging or podcasting within minutes.

-- Advertisement --

Sent Items Organizer
When you need to file your sent email into their proper folders based on keywords or who it's to. It's also perfect for shared mailboxes.

It also adds a "Send And File" toolbar button while you're composing (similar to the way Lotus Notes used to work) for quick and easy filing.

Find out more!

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Outlook is a trademark of Microsoft Corporation.
Editor's Login