Emailing a field from form

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

Guest

Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
 
Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

Ofer said:
Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
 
Yes, try it there

--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

Ofer said:
Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
Click to expand...
 
When I enter the code, This piece show up in the Subject line of the email ""
& Me.[GLNumber],,False" Instead of that, I would just the GLNumber for that
record to show.

Ofer said:
Yes, try it there

--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

Ofer said:
Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


:

Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
Click to expand...
 
Can you post the full line?

--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
When I enter the code, This piece show up in the Subject line of the email ""
& Me.[GLNumber],,False" Instead of that, I would just the GLNumber for that
record to show.

Ofer said:
Yes, try it there

--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

:

Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


:

Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
Click to expand...
 
Here is what shows in the Subject line of the email:
My Subject - " & Me.[GLNumber],,False

Ofer said:
Can you post the full line?

--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
When I enter the code, This piece show up in the Subject line of the email ""
& Me.[GLNumber],,False" Instead of that, I would just the GLNumber for that
record to show.

Ofer said:
Yes, try it there

--
\\// Live Long and Prosper \\//
BS"D


:

Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

:

Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


:

Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
Click to expand...
 
I need the full line you are using to send the mail, not the resault
--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Here is what shows in the Subject line of the email:
My Subject - " & Me.[GLNumber],,False

Ofer said:
Can you post the full line?

--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
When I enter the code, This piece show up in the Subject line of the email ""
& Me.[GLNumber],,False" Instead of that, I would just the GLNumber for that
record to show.

:

Yes, try it there

--
\\// Live Long and Prosper \\//
BS"D


:

Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

:

Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


:

Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
Click to expand...
 
Sorry about that.

DoCmd.SendObject acSendNoObject, , , "Management Team", , , "My Subject - ""
& Me.[GLNumber],,False

Ofer said:
I need the full line you are using to send the mail, not the resault
--
\\// Live Long and Prosper \\//
BS"D


Doug_C said:
Here is what shows in the Subject line of the email:
My Subject - " & Me.[GLNumber],,False

Ofer said:
Can you post the full line?

--
\\// Live Long and Prosper \\//
BS"D


:

When I enter the code, This piece show up in the Subject line of the email ""
& Me.[GLNumber],,False" Instead of that, I would just the GLNumber for that
record to show.

:

Yes, try it there

--
\\// Live Long and Prosper \\//
BS"D


:

Hi Ofer,

Where do I place this code, in the OnClick event of my command button?

Thanks!

:

Try

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)",,,"My Subject -
" & Me.[FieldNameInTheForm],,False

It will include the field value from the form in the subject (or you can
move it to the detail section)
The false in the end indicate that you want to send the email without
updating it.


--
\\// Live Long and Prosper \\//
BS"D


:

Hello Everyone!

On my form I want to place a command button so when clicked, will
automatically send a standard email message. Along with this, can the email
be set up to grab information from one of the fields on the form (LS#) and
place it in the email automatically? So that what ever record you are on,
when you send the email it will drop the LS# from that record in the email.
Hopefully this makes sense.

Also, please simplify answer as I am not as literate in Access as you folks.

Thank you in advance for any help you can give!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top