Send email code gives error message 1

[SeadnaS]

I'm using this code with a button:

On Error GoTo Err_email_Click

Dim stDocName As String

stDocName = "MONTH_REPORT"
DoCmd.SendObject acSendReport, stDocName, "SnapshotFormat(*.snp)", "ssmallwood@maspac.local", "", "", [PM], "Hello, these are the PM's for the next month.", False, ""

Exit_email_Click:
Exit Sub

Err_email_Click:
MsgBox Err.Description
Resume Exit_email_Click


I keep getting this error message:

Microsoft Access can't find the field "|" referred to in your expression.

Don't understand why i'm getting that, any help appreciated!

 

[PHV]

What is [PM] ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

Its meant to be the email Subject (probably in the wrong place or something). Its short for preventative maintenance.

 

[SeadnaS]

Yep, it was the square brackets. Doh!

Thanks.