Access 2003 - Need an email button prefilled with info from the fo

[Randy Star]

I have a form containing three fields that I need to use for an email.

"Company", "EmailAddress", and "Program Contact".

I'm hoping this is simple - I've never used Visual Basic or anything so I
would REALLY appreciate someone walking me through this as if I were the
idiot that I really am

I just want a button that pops up an email, pre-filled with the email
address, a subject like "Welcome to <Company>" (company pulled from the field
I mentioned above) and, if possible, pre-filled with our standard text in the
body (including the contact name) so I can just click SEND, attach any
documents I need to depending on what they need, and be done.

 

[Steve Schapel]

Randy,

Make a macro (from your Database Window, select the Macro tab, and then
click New), and enter the SendObject action in the Action column. Press
F1 to read the Help topic for this action. This macro will be saved,
and assigned on the On Click event property of the Command Button on
your form. In the macro arguments (the bit down the bottom of the
screen), you can do like this...

Object Type, Object Name, etc leave blank.
To: =[EmailAddress]
Subject: ="Welcome to " & [Company]
Message Text: ="Congratulations to " & [Program Contact] & " on your
achievement."
Edit Message: Yes

 

[Randy Star]

BEAUTIFUL! Thank you so much

Randy,

Make a macro (from your Database Window, select the Macro tab, and then
click New), and enter the SendObject action in the Action column. Press
F1 to read the Help topic for this action. This macro will be saved,
and assigned on the On Click event property of the Command Button on
your form. In the macro arguments (the bit down the bottom of the
screen), you can do like this...

Object Type, Object Name, etc leave blank.
To: =[EmailAddress]
Subject: ="Welcome to " & [Company]
Message Text: ="Congratulations to " & [Program Contact] & " on your
achievement."
Edit Message: Yes

--
Steve Schapel, Microsoft Access MVP

I have a form containing three fields that I need to use for an email.

"Company", "EmailAddress", and "Program Contact".

I'm hoping this is simple - I've never used Visual Basic or anything so I
would REALLY appreciate someone walking me through this as if I were the
idiot that I really am

I just want a button that pops up an email, pre-filled with the email
address, a subject like "Welcome to <Company>" (company pulled from the field
I mentioned above) and, if possible, pre-filled with our standard text in the
body (including the contact name) so I can just click SEND, attach any
documents I need to depending on what they need, and be done.

 

[Susy Lingle]

Steve, does the code change if you are going to do this in Access 2002. I
want to do the same thing but in 2002 you don't need the quotes to get the
simple text to print. I need to add a field and can't get it to work.

ex:
Subect: PC Replacement & [Install Date]

This prints out exactly as above and doesn't include the Install Date field.

Randy,

Make a macro (from your Database Window, select the Macro tab, and then
click New), and enter the SendObject action in the Action column. Press
F1 to read the Help topic for this action. This macro will be saved,
and assigned on the On Click event property of the Command Button on
your form. In the macro arguments (the bit down the bottom of the
screen), you can do like this...

Object Type, Object Name, etc leave blank.
To: =[EmailAddress]
Subject: ="Welcome to " & [Company]
Message Text: ="Congratulations to " & [Program Contact] & " on your
achievement."
Edit Message: Yes

--
Steve Schapel, Microsoft Access MVP

I have a form containing three fields that I need to use for an email.

"Company", "EmailAddress", and "Program Contact".

I'm hoping this is simple - I've never used Visual Basic or anything so I
would REALLY appreciate someone walking me through this as if I were the
idiot that I really am

I just want a button that pops up an email, pre-filled with the email
address, a subject like "Welcome to <Company>" (company pulled from the field
I mentioned above) and, if possible, pre-filled with our standard text in the
body (including the contact name) so I can just click SEND, attach any
documents I need to depending on what they need, and be done.

 

[Steve Schapel]

Suzy,

No, regardless of version you would have to do it like this...
="PC Replacement " & [Install Date]

In fact, you may also need to control the appearance of the date in this
instance, for example...
="PC Replacement " & Format([Install Date],"dd\-mmm\-yy")

 

[Susy Lingle]

No - it puts in exactly what is typed in the subject action arguments of the
macro

Suzy,

No, regardless of version you would have to do it like this...
="PC Replacement " & [Install Date]

In fact, you may also need to control the appearance of the date in this
instance, for example...
="PC Replacement " & Format([Install Date],"dd\-mmm\-yy")

--
Steve Schapel, Microsoft Access MVP

Steve, does the code change if you are going to do this in Access 2002. I
want to do the same thing but in 2002 you don't need the quotes to get the
simple text to print. I need to add a field and can't get it to work.

ex:
Subect: PC Replacement & [Install Date]

This prints out exactly as above and doesn't include the Install Date field.

 

[Steve Schapel]

Susy,

Can you show us please exactly what did you type in the macro argument?