Sending an Excel Doc to an Exchange Folder

[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

 

[Ken Slovak - [MVP - Outlook]]

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.

 

[Guest]

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

 

[Ken Slovak - [MVP - Outlook]]

What dialog box? You mean the security prompt that a program is trying
to send email? Look at
http://www.slipstick.com/outlook/esecup.htm#autosec for ways around
that. I'm afraid you're going to have to recode what you are doing and
avoid using SendMail, which uses Simple MAPI and is subject to the
security prompts.