Can I email different material to different people

[jefferyzhong]

I have a Quality control database, I record the information like this: department, manager, employee, errors...
I suppose to email out the employee errors to his manager every week, which means different manager only receive the employees errors under him.

Supply I have the Query name" QryError" which has the information I need to send out. "manager","date", "employee", "errors" are in the query, I need to send email to "manager" with the information of the "date", "employee", "errors"

can anyone help me about this problem?

thanks in advance

 

[jefferyzhong]

Can anyone help?

 

[MichaelRed]

There are numerous threads re e-mail from various VB(A) specific apps in these fora. Use Search and find what is available. The samplings range in complexity so you should be able to find several levels of possabilities to learn from.




MichaelRed

 

[jefferyzhong]

Can anyone give me more detail instruction?

 

[PHV]

Can anyone give me more detail instruction?
Click the Search button on top of your 1st post, in the textbox type email recordset, press Enter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jefferyzhong]

PHV
Thanks for the help.
I know how to send to multiple email address now, but how can I put different data ( due to query) to different person.

thanks a lot

Jeffrey

 

[AlanJordan]

You might try using a case statement such as

Select Case strManagersName
     Case "Robert Johnson"
          'Insert Code to process his data
     Case "Lana Turner"
           'Insert Code to process her data
     Case "Chris Evans"
            'Insert Code to process his data
End Select

 

[PHV]

You really don't found what you want in the "Hundreds of records matched your query of email recordset"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jefferyzhong]

PHV,
I am new with VBA, would you please help me with these code? would you mind to post the code in this thread?

thanks