Selecting text for Emailing

  • Thread starter Thread starter Stockwell43
  • Start date Start date
S

Stockwell43

Hello,

I have question that maybe someone could help me with. I have a database
where on the form I placed a command button to send emails. Works great and
in fact, I even got it to pull the information from selceted fields on the
current record. What I would like to know is:

Is there a way to pick up the name of the field and have the information
that was inputted in that field appear next to the name in the email?

For Example:

Currently my email body picks up only the information so the loan number
field only shows the loan number and the Date In field only show a date.

123456789
11/28/2007

I would like for the email to pick it up like this:

Loan Number: 123456789
Date In: 11/28/2007

Is this possible without getting to difficult? If so, please explain in
simple terms as my coding knowledge is limited.

Thank you!!!
 
Hello,

I have question that maybe someone could help me with. I have a database
where on the form I placed a command button to send emails. Works great and
in fact, I even got it to pull the information from selceted fields on the
current record. What I would like to know is:

Is there a way to pick up the name of the field and have the information
that was inputted in that field appear next to the name in the email?

For Example:

Currently my email body picks up only the information so the loan number
field only shows the loan number and the Date In field only show a date.

123456789
11/28/2007

I would like for the email to pick it up like this:

Loan Number: 123456789
Date In: 11/28/2007

Is this possible without getting to difficult? If so, please explain in
simple terms as my coding knowledge is limited.

Thank you!!!
Click to expand...

if you can display fldSomeNumber, then can't you also display:
fldSomeNumber.name & ": " & fldSomeNumber ?
 
Hi OldPro!

You did it again my friend, the code worked great!! I didn't think about the
..Name but then again I never did anything like that before but I wrote it
down and save it with my other code for future reference.

Thank you so much for your help, most appreciated!!!!
 
Back
Top