Form linked to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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,
 
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
 
Back
Top