|
sponsored links |
|
|
sponsored links
|
|
1
31st March 18:19
External User
Posts: 1
|
Form linked to Excel
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. |
|
|
|
2
3rd April 16:02
External User
Posts: 1
|
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 |
|
|
|
3
3rd April 16:02
External User
Posts: 1
|
Form linked to Excel
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, |
|
|
|
4
3rd April 16:02
External User
Posts: 1
|
Form linked to Excel
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx |
|
|
|
Linear Mode
