Designing Email Triggers

[lynthel]

I am having some difficulties insert fields within an email trigger. I have created a table to pull from to design an email body.



Is there an easy way to do this on an insert SendEmail?

Would having a word document on the server using mail merge (pulling form the DC) be easier? If so, can someone point me to a tutorial or step by step directions for either of the above ideas?

Thanks

[June7]

What do you mean by 'email trigger' - a command button?

What method are you using to send email - SendObject?

What is 'insert SendEmail'?

[lynthel]

email trigger...an after insert or after update...I have both set up to send an email...I am using SendEmail...I am trying to pull in data from fields to create the email...

[June7]

I still don't know what you mean by SendEmail - is this the command from the External/Export tab on ribbon?

Are you using a macro or VBA? Post code for analysis.

Referencing fields/controls of open form and concatenating into a string is simple, like:.

strBody = "The value '" & Me.texboxname & "' is data from a field of current record on form."