How do I email all the information in a NOTES field in ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database where in the form, I have an email button attached.

The problem I am having is that the comments do not all get copied to the
email message.

How can this be corrected?
 
If the email function already exists, then you need to use the vba editor and
make changes to the coding. right-click on the e-mail button and open the
on_click event to access the code. Then copy it and post it back here so we
can look it over and suggest how to modify it appropriatly.

Daniel
 
In the Message Text box I have =[Comment]

The information all stores right in my table. However, the email message
area does not have everything.

I hope this helps.
 
Right-Click on the button and select properties.
Select the Event Tab
The 'On Click' event should have an entry. If you click on the line (make
sure not to change it) so as to select it, a button with 3 dot '...' should
appear at the end of the line.
Click on that button (it will bring you to the vba code that controls that
action).
Copy it and paste it back here.

Daniel

hjyoungii said:
In the Message Text box I have =[Comment]

The information all stores right in my table. However, the email message
area does not have everything.

I hope this helps.

Daniel said:
If the email function already exists, then you need to use the vba editor and
make changes to the coding. right-click on the e-mail button and open the
on_click event to access the code. Then copy it and post it back here so we
can look it over and suggest how to modify it appropriatly.

Daniel
Click to expand...
Click to expand...
 
Back
Top