outlook post form thru excel
 

I have been trying to create a macro in excel vba. When run, it will open a post form that is kept in the public folders of Outlook. That post form has already been created. Once I am able to open the post form I want to populate it's text fields with data from the excel sheet. I have been able to open a blank word email from excel, but have not been able to figure out how to open an existing post form stored in public folders.