Search results

dear sir ,it is not working, it is showing to address as "sEmail, here is my code: Private Sub cmddepthead_Click() Dim sEMail As String If [Report].[Location Brief] = "QC-Wires" Then sEMail = "xxxx" End If If [Report].[Location Brief] = "Blk wire drawing" Then sEMail = "uuuuu" End If...

Dear sir thank you so much for the quick reply, Could u pls show me the syntax for the same...I am starting to learn VBA in recent days.

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...