DoCmd.SendObject Dcount

[tozey]

Hello all

is it possible to add the results of a dcount in a message body, I have tried many combinations of code and searched the net but cannot see if it is possible or not.

like this in the message body text:

DoCmd.SendObject acSendQuery, "my_query", acFormatXLS, "Joe Bloggs", , , "DCount("AccountNumber","table","[criteria] = 'please work'") & " " & "this is the total this week. Thanks",False

Thanks for looking

Alex

 

[namliam]

Just remove the extra and strangely placed quotes??!!
DoCmd.SendObject acSendQuery, "my_query", acFormatXLS, "Joe Bloggs", , , DCount("AccountNumber","table","[criteria] = ""please work""") & " " & "this is the total this week. Thanks",False

 

[tozey]

Thank you, attention to detail wins again!!!

Thank you...