I am in WAY over my head. I have very little training in what I've been asked to do... I have designed a form that posts a task to a public folder, and I want to be able to export from that folder into an Excel spreadsheet. I’m told that the reason I can’t show that folder in the Outlook import/export dialog window is because it is a public folder, and the only way to export from a public folder is through VBA. The work-around is to copy that folder down to my own folders, but when I did that, I was able to export... but only the fields defined by Outlook… my custom form fields do not show up.

Another work-around is to look at the folder in a table view, including all the fields of the form, then select all, copy, and paste into Excel. It’s a ‘dirty’ solution, though… text moves all over the place from where it is supposed to be, and I'd rather not have to clean up an Excel file.


HELP!