Sending to different emails/distribution lists based on criteria

[pomomatthew]

I know this sounds really easy, but I haven't figured it out - I
basically have a custom form that could go to one of three internal
departments.

I just want to be able to send it to Email Address "A" if the Sales
Region is "A", Email Address "B" if the Sales Region is "B", etc. For
some reason, it always displays the current date at 0000 AM in the
"To" field.

I have tried it a number of ways,can someone give me an idea on how to
fix it?

Thanks

 

[Sue Mosher [MVP-Outlook]]

It's not inherently "really easy." Start with the questions you'd ask if you a staffer to do that kind of sending. What information on the message tells you whether the message is destined for a particular department? Once you know the department, where do you find information about the email addresses to use? If you can answer those questions, we might be able to help you.

 

[pomomatthew]

The form has been designed so that the first question at the top is
"Please select sales region" with an option for "Portland",
"Sacramento", or "Seattle". Beyond that question, there is nothing
else that would qualify where it needs to be sent. I want
(e-mail address removed) to be placed in the To: field if "Portland" is selected,
(e-mail address removed) if "Sacramento" is selected, or (e-mail address removed) if
"Seattle" is selected. The addresses are standard email addresses
like any other. I hope that clarifies what I am asking for...

Thanks!

 

[Sue Mosher [MVP-Outlook]]

Still not quite enough detail. That "first question" -- is it an unbound control or is it bound to an Outlook property? Which property? See http://www.outlookcode.com/article.aspx?ID=38 if you don't understand the difference. That page will also show you how to write code to respond to the user's interaction with your form.

Is there only one recipient per item?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


The form has been designed so that the first question at the top is
"Please select sales region" with an option for "Portland",
"Sacramento", or "Seattle". Beyond that question, there is nothing
else that would qualify where it needs to be sent. I want
(e-mail address removed) to be placed in the To: field if "Portland" is selected,
(e-mail address removed) if "Sacramento" is selected, or (e-mail address removed) if
"Seattle" is selected. The addresses are standard email addresses
like any other. I hope that clarifies what I am asking for...

Thanks!