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

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

Guest

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.
 
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
 
BEAUTIFUL! Thank you so much :-)

Steve Schapel said:
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


Randy said:
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.
Click to expand...
Click to expand...
 
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 said:
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


Randy said:
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.
Click to expand...
Click to expand...
 
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")
 
No - it puts in exactly what is typed in the subject action arguments of the
macro

Steve Schapel said:
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

Susy said:
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.
Click to expand...
Click to expand...
 
Back
Top