Sending an Excel Doc to an Exchange Folder

  • Thread starter Thread starter Kathryn
  • Start date Start date
K

Kathryn

Hello All ~

I have a little Excel 2000 form that I want to have sent
to an Exchange Folder (Outlook 2000) after it is
completed. In other forms, I use the
ActiveWorkbook.SendMail but it requires the sender to
choose the recipient. I would prefer to have the form
move directly to an Exchange folder. Any thoughts? (Not
sure if this question is best for the Outlook group or the
Excel group so I am sending to both...)

Thanks so much!
Kathryn
 
Is this an Exchange public folder or a folder in a mailbox? If it's a
public folder it will have an email address unless the folder is
hidden from the address book. Say the folder is named MyExcel, then
the email address of the folder would be (e-mail address removed)

If the folder is a mailbox folder just code in the address of the
person whose mailbox it is.
 
Thanks, Ken! It is an Exchange public folder so I have
the email address. The question I have now is that using
SendMail, is it possible to designate the recepient so
that the user doesn't get the email dialogue box?

This is what I currently use for forms that are mailed by
only one person who enters recepients name through the
dialogue box....

Sub mcrEmailRequest()
ActiveWorkbook.SendMail "", _
"FoundationPower Programming
Request"
End Sub

Is it possible to have it send w/o the dialogue?

Thank you!
Kathryn
 
Back
Top