Email

[Del_Piero_3]

I need help big time, can someone plz help.

On a order form I want to send emails to everyone who works in that department. Basically when placing an order certain details are enter on the order form (see the attachment) including department, so when the send email button is clicked I want to send emails to everyone in that department.

Spare me bit of your time!!

Kind Regards.

 

[Del_Piero_3]

Relationship diagram.

 

[Ukraine82]

Look at the attached file.

hth,

Michael

 

[Del_Piero_3]

Look at the attached file.

hth,

Michael

Thanx, still having problem though. Its the SQL part where am really struggling. Cant get it right.

 

[Ukraine82]

Are you talking the event procedure VB code? If so, be sure to overwrite the sample database with the name of your table and fields.

hth,

Michael

 

[Del_Piero_3]

Are you talking the event procedure VB code? If so, be sure to overwrite the sample database with the name of your table and fields.

hth,

Michael

I've copied and pasted the code into my db, assigned it to click button procedure, changed the fields name etc, but the sql part is different, and I am beginner.

 

[Ukraine82]

Post your database. Let me know what form you want me to place the vb code.

Michael

 

[Del_Piero_3]

On my order form, it doesnt have email address's, so I need a sql (query) that finds every email address in the employees table that work in that department which is selected on the order form.

 

[Del_Piero_3]

Post your database. Let me know what form you want me to place the vb code.

Michael

Can you please pm ur email addy, the databse is about 600kb

 

[Ukraine82]

Add an extra field in your table that you made your Form from call it E-mail along with another field called SendTo have the Data Type set to yes/no.

Go to tblEmail in the attachment I sent you.

hth,

Michael