Excel & Outlook Integration - Urgent!
 

Hi Shauna,

You can create a input form in Excel, then add the input
information to Outlook via VBA. For example, you can
access Outlook via the following code.

dim objOutlook as outlook.application
set objOutlook=Create("Outlook.application")

then, you can use the VBA function in Outlook to add the
information into your addressbook.

Best Regards

Bill


-----Original Message-----
Does anyone know how to use Excel, similar to Word's
Address Layout/Outlook Insert Address tool connection.

Eg. A user needs, in Excel, to insert information stored
in Outlook, such as Name, Address, Phone into a worksheet
for Vendor Information when thye generate a Purshase
Order. Like in Word, if an Address Layout AutoText entry
is created with the desired fields, a user clicks the
Insert Address tool, pick as name from the list and the
desired field information is inserted.

Thanks!
Shauna
.