Importing into custom form and fields from CSV file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 06 Jul 2005 23:37 GMT

I know nothing about programing or VBA and everyone tells me "it's easy".
I've tried ACT! for a few days and don't like it so I'm going to try writing
a script to import a CSV file into my custom form in Outlook 2002.
My question is, what is my first step? I can get some sample scripts from
Sue Mosher's site, but what then? Help save me from having to use ACT!
Allen

Reply to this Message

Sue Mosher [MVP-Outlook] - 07 Jul 2005 12:45 GMT

If you're new to Outlook VBA macros, these web pages should help you get started:

http://www.winnetmag.com/Articles/Index.cfm?ArticleID=21522&pg=1
http://www.outlookcode.com/d/vb.htm

The sample import scripts should show you

a) how to read data from a .csv or other type of file
b) how to create a new Outlook item, set its property values, and save it

The next step is to modify the script, adapting those techniques to your particular data so that you include the path to the correct file and put the right csv data into the right Outlook property.

If you don't understand how the scripts work, then you won't be able to do the next step. Ask questions! Experiment! Or just buy a tool to do it for you.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I know nothing about programing or VBA and everyone tells me "it's easy".
> I've tried ACT! for a few days and don't like it so I'm going to try writing
> a script to import a CSV file into my custom form in Outlook 2002.
> My question is, what is my first step? I can get some sample scripts from
> Sue Mosher's site, but what then? Help save me from having to use ACT!
> Allen

Reply to this Message