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
.
|