Fields on custom forms are not kept after message is sent

[Cornfuzzled]

I'm designing a custom form using the mail template. I add some fields such
as yes/no and date. After publisiung the form and using it to send a
message, the data that was put into the custom fields is not present. How do
I get these fields to retain the data that is put into them before sending
the message? The ultimate goal is to link all of these custom messages in a
single folder and link into an access table.

 

[Sue Mosher [MVP-Outlook]]

Not present where?

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

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

 

[Cornfuzzled]

Hi Sue,
Since posting that, I've since learned that the fields that I added to the
form need to also be added to the folder. I did that, then the data had a
place to reside and it was visible while looking at the messages in that
folder. Then I linked and mapped a MS Access table to that folder. It was
then I learned that only the default outlook fields would be mapped and
brought over to Access. I have found some VB code that people claim works to
map custom fields and their data over to Access, but I have had no luck
making them work.
Can you suggest any other solution? Getting this solution would allow me to
streamline about 5 processes.

Thanks
Chip

 

[Sue Mosher [MVP-Outlook]]

While articles have been written on how to expand on the database link table method's obvious features, I've never been able to duplicate the results either. See http://www.outlookcode.com/d/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and Outlook together. You'll need to write code or use a third-party tool that does the heavy lifting.

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

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