how to apply vba code to OL2003 forms ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TimR - 17 Feb 2006 15:48 GMT

I want to try and experiment with Sue Mosher's code from her site (
http://www.outlookcode.com/d/code/convertfields.htm ) in my OL2003 contacts.
I need to import customer field data from time to time and I think this may
work. Can someone tell me how I go about applying Sues sample code to my
test contact folders ?

I haven't worked with vba code before !? There are third party vendors on
the Slipstick site...but the costs range from $300 to over $800....not in my
budget or reality for my needs.

Thanks, Tim

Reply to this Message

Sue Mosher [MVP-Outlook] - 17 Feb 2006 16:41 GMT

The first step is to understand what the code does: It loops through all the items in the folder that is currently displayed to the user and changes various property values. If that fits your needs, then to try it, all you have to do is display the folder you want to work with and possibly change what properties you want to change.

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

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.outlook.program_vba

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 want to try and experiment with Sue Mosher's code from her site (
> http://www.outlookcode.com/d/code/convertfields.htm ) in my OL2003 contacts.
[quoted text clipped - 7 lines]
>
> Thanks, Tim

Reply to this Message