Sending to different emails/distribution lists based on criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pomomatthew@gmail.com - 05 Mar 2008 02:53 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 05 Mar 2008 14:58 GMT

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.

Signature

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

>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
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

pomomatthew - 05 Mar 2008 17:21 GMT

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
xxxx@xxxx.com to be placed in the To: field if "Portland" is selected,
yyyy@yyyy.com if "Sacramento" is selected, or zzzzz@zzzz.com if
"Seattle" is selected. The addresses are standard email addresses
like any other. I hope that clarifies what I am asking for...

Thanks!

On Mar 5, 6:58 am, "Sue Mosher [MVP-Outlook]" <sue...@outlookcode.com>
wrote:

> 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.
> --
[quoted text clipped - 19 lines]
>
> - Show quoted text -

Reply to this Message

Sue Mosher [MVP-Outlook] - 05 Mar 2008 19:15 GMT

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?

Signature

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

> 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.
>
[quoted text clipped - 14 lines]
>
> - Show quoted text -

Reply to this Message