Ravi Kumar
Registered User.
- Local time
- Today, 17:55
- Joined
- Aug 22, 2019
- Messages
- 162
Criteria for sending the mail
Hello all,
I really need your help on this,
I have created a report called calibration instruments list and first column is location,it will be automatically filtered to particular location like"production"with the help of combo box in form filter.
Now using sendobject I need to send mail automatically to related person like if my first column field is production,when I click send button it should open outlook with to "xxxx" and if it is qc then for"yyyy".
Using vba if or anything else kindly tell me how to write the code....
Hello all,
I really need your help on this,
I have created a report called calibration instruments list and first column is location,it will be automatically filtered to particular location like"production"with the help of combo box in form filter.
Now using sendobject I need to send mail automatically to related person like if my first column field is production,when I click send button it should open outlook with to "xxxx" and if it is qc then for"yyyy".
Using vba if or anything else kindly tell me how to write the code....