Custom Subject using Sendobject Macro (1 Viewer)

[manix]

Hi All,

Trying to use the sendobject macro to simply send an email with a subject line that is both text and data from the loaded form fields.

So for example: "Concern" [45] "has been raised by" [Harry]",please respond"

where the "" is the set text and [] is data from the fields.

I have tried using "Concern" &Me.ConcernNo, but this does not seem to work.

Can anyone help?

 

[manix]

It's OK I have managed to find a related thread here:http://www.access-programmers.co.uk/forums/showthread.php?t=231270

It is simply:

="Blah blah blah " & [Forms]![frm_ChangeRequest]![Responsible Owner].[column](3) & " report is late blah blah blah"