I'm trying to write a VBA macro within Excel 97 that will post an Excel
workbook to a specific Exchange 5.0 public folder on a button push. The
Exchange client I'm using is Outlook 97 v8.01
The control "ActiveWorkbook.Post()" brings up a dialog box from which you
can select the desired public folder, but I want to have the post
automatically go to a specific pre-defined folder. No syntax for the
(expression) seems to work as a folder name.
I tried using ActiveWorkbook.SendMail Recipients:="Pub Fldr". This works
fine to mail the Excel document to the folder, but won't allow me to tie in
user-defined document properties from the spreadsheet as columns within the
public folder. This seems to be due to the attached file format of the
"SendMail" command embedding the Excel file in a message form, as apposed
to the posting being the document itself.
Any ideas? Anything different coming in Exchange 5.5? or is this an issue