View Single Post
  #2  
Old April 3rd 07, 01:47 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Form linked to Excel

You would have to write code behind the custom form to perform any such linking. However, using a custom form for messages to external recipients generally is a bad idea, because it can cause problems with attachments. A better approach might be to use VBA code in the Application_ItemSend event handler to set the built-in BillingInformation or Mileage property.

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

"Myriam" wrote in message ...
I need to track my e-mails by job# and then number each e-mail consecutively
as they are being sent out. I'm using Outlook 2003.
The route I'm taking is to create a form similar to the 'send e-mail'
template from Outlook, add a combo for job#s and link it to an Excel sheet.
Is this the best route to go? How can I link it to an Excel file?
Thanks in advance.

Ads