Pasting a query in outlook mail body

[gsrajan]

Is there a way to paste a access query result in the outlook message body?. I do not want to attach the query result in the email.

Thanks for your help.

 

[pr2-eugin]

You need to work with recordset (VBA), to loop through the Query to extract fields and the put them in the body of the email; to get what you want.

 

[gsrajan]

Thanks for the reply. Can you please provide me a sample?

Thanks.

 

[pr2-eugin]

Thanks for the reply. Can you please provide me a sample?

Thanks.

I am sure I have helped another person with similar request. I will try to find the post, instead of me writing the code again. If it takes longer I will rewrite it.

 

[pr2-eugin]

Check out this thread ! Daily Sending of Email Notifications

 

[gsrajan]

Thank you very much, it works well.

 

[pr2-eugin]

Glad you got it working !

Just out of curiosity, are you from (South) India?

 

[gsrajan]

Sorry for the delay. Yes, you are right!.

 

[pr2-eugin]

Sorry for the delay. Yes, you are right!.

Not a problem. I am basically form South India too.