Okay, so YOU, wnicole, are the user.
Sam, the technician, is (in this example) the recipient of the email.
The email is about a job that Sam is supposed to do.
If the job is a "govt" job, then one specific attachment will always be sent.
That "govt" attachment will always be stored in one specific place.
If the job is some other kind of job, either a different attachment or no attachment will be sent.
Do I have that all correct?
If so, then let's assume that the attachments will be stored on your LAN somewhere on the U drive. Let's also assume that your dropdownbox on your form is called lstArea, and that the two values for lstArea that have attachments on the U drive are "govt" and "misc". Replace this code:
Code:
If Left(Me.Mail_Attachment_Path, 1) <> "<" Then
.Attachments.Add (Me.Mail_Attachment_Path)
End If
with this code:
Code:
SELECT CASE Me.lstArea
CASE "govt"
'attach the government attachment
.Attachments.Add ("U:/FullPathToGovtTAttachment.PDF")
CASE "misc"
'attach the miscellaneous attachment
.Attachments.Add ("U:/FullPathToMiscAttachment.DOC")
CASE ELSE
'nothing to do
END SELECT
Obviously, you need to use the exact name of the dropdownbox, the exact value of the values of the dropdownbox, and the exact path to the attachments for each value, in the above code. That's the spots I've marked in bold italic red.