Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Integration with Outlook: Mail Item objects from .msg files | Excel Discussion (Misc queries) | |||
Word/Excel Integration Problem | Excel Discussion (Misc queries) | |||
Excel integration with databases | New Users to Excel | |||
IF function for scheduling tool with outlook integration | Excel Worksheet Functions | |||
Outlook Integration | Excel Discussion (Misc queries) |