Form linked to Excel

[Myriam]

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.

 

[Sue Mosher [MVP-Outlook]]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Myriam]

Thanks for your response.
I need to study those properties, I'm not familiar with them.

(By the way, I just bought 2 of your books--very good!)
Thanks again.
Regards,

 

[Sue Mosher [MVP-Outlook]]

They're just text properties that you can use for whatever purpose you want.

You can get the books' code samples from the links in my signature.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers