Generate email with fields used on form

[Screaminxpert]

Hi,

Sorry if the title is not very clear, I was not sure how to simply word what I am trying to do so here is the longer version.

Currently we have an Access 2007 DB with a button on a form that opens up a new email with the subject and body filled in, all the user needs to do is click send in their default email application.

We now have discovered that although this email is helpful it really needs to contain some information from the form that has just been filled in. In particular there is a field called 'Business Name' and we would like the business name to appear in the subject of the email.

Is there anyway to do this with code, if we have to automate the email when the user clicks on the button rather than having to open up an email in their email client it does not bother me.

Please excuse me if what I am asking is not worded very technically but I am a novice with access.

Thanks

 

[KenHigg]

Can you post the code you are using to generate the email to this point?

 

[Screaminxpert]

Hi

I am currently using a Macro and using the SendObject action this allows me to specify the recipient, subject and body.

 

[KenHigg]

I'm sure you probably can do it a macro but I'd use the vba code version of sendobject where you can put whatever you want to in the body.

 

[Screaminxpert]

Ok thanks for the quick replies, as I said in my original post I am a bit of a novice with access and I am especially not good with VBA, could point me to a guide or give me some instructions?

 

[KenHigg]

To start with why don't you try referencing a form text box control in the macro 'message text' property. Something like:

forms!myFormName!myTextBoxName

And see if it makes it to the email body area...

???