Email contents in form

N

Neil Greenough

Don't know if this is possible.

I am currently using email to bid for potential work. What i'd like if
possible, is for certain parts of my email to automatically go into
designates fields in a table / form. So for example, in my email I write
'cost' 'date' etc.... and then when i click send, this also sends the
information to my database.

Is this possible?
 
T

Tony Toews

Neil Greenough said:
I am currently using email to bid for potential work. What i'd like if
possible, is for certain parts of my email to automatically go into
designates fields in a table / form. So for example, in my email I write
'cost' 'date' etc.... and then when i click send, this also sends the
information to my database.
Click to expand...

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command as the body of the email. For more
details including sample air code see my Tips page on this topic at
http://www.granite.ab.ca/access/email/formatted.htm.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top