Email form based on drop down value

Hello-

I want to have a drop down field in a form that has an employees
location, like "city A", "city B", "city C", etc. When filling out the
form, the rep will select their location. On the bottom of the form is
a "submit" button that will automatically send the email (I have this
step in action right now).

What I want to do is to have the code for the "submit" button
reference the drop down value to see who needs to be emailed.

If the value of the drop down is city A, the form emails to
joe.smith DeleteThis @mycompany.com, if the value is city B, the form emails
jane.doe DeleteThis @mycompany.com, etc

Can this be done? Thanks in advance for the help.

Scott

Assuming that by a drop down field you mean a DropDown FormField as used in
a document that is Protected for forms, have a macro that contains the
following code run on exit from the DropDown FormField:

Dim i As Long
Dim City As String, emailaddress As String
With ActiveDocument.FormFields("City").DropDown
i = .Value
City = .ListEntries(i).Name
End With
Select Case City 'Change the cases and the email addresses to suit
Case "New York"
emailaddress = "someone@newyork"
Case "Buffalo"
emailaddress = "someone@buffalo"
Case "Chicago"
emailaddress = "someone@chicago"
End Select
MsgBox emailaddress 'Use emailaddress in your code that sends the form.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Sabosis" <scott.sabo RemoveThis @henryschein.com> wrote in message
news:178220b2-8361-4216-b6d9-2e2df9b6c663@k37g2000hsf.googlegroups.com...
> Hello-
>
> I want to have a drop down field in a form that has an employees
> location, like "city A", "city B", "city C", etc. When filling out the
> form, the rep will select their location. On the bottom of the form is
> a "submit" button that will automatically send the email (I have this
> step in action right now).
>
> What I want to do is to have the code for the "submit" button
> reference the drop down value to see who needs to be emailed.
>
> If the value of the drop down is city A, the form emails to
> joe.smith RemoveThis @mycompany.com, if the value is city B, the form emails
> jane.doe RemoveThis @mycompany.com, etc
>
> Can this be done? Thanks in advance for the help.
>
> Scott