vba help needed

V

Vinod Lewis

I am creating a Leave application word form, where i need my users to click
the submit button and that sends an email out.

Application word 2007

This code works fine when the recepient clicks the submit button, the
recepient of the email is the one specified in the code.

ActiveDocument.SendForReview _
Recipients:="Your Email address here", _
Subject:="Your Subject here", _
ShowMessage:=False, _
IncludeAttachment:=True
MsgBox "Your Message has been sent!"

Help
====
In my form i have a combo box where the user selects a department in which
he is working, based on that department when the user clicks the submit
button. one email should go to the head of the selected department and one
email to the HR department. I need a code for that

Any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top