Sending emails from Access

  • Thread starter Thread starter dawnecia
  • Start date Start date
D

dawnecia

Is it possible to send an email using code which allows the user to enter the
email address or select one for a table?

Thanks
 
If all you want to do is send an email, create a Macro. From the drop down
list select SendObject then go to the bottom and enter whatever criteria you
want. Save the Macro and name it. Go to your form and create a command
button. Open the button to it's properties and go to the Click Event. On the
drop down select the Macro you just created and close the properties table
and save. You should now be able to click the command button on your form and
a blank email should pop up.
 
Is it possible to send an email using code which allows the user to enter the
email address or select one for a table?

Thanks
Click to expand...

More context? You mean by selecting from a dropdown?
 
I would also like to send e-mail from access and I also am VERY new to the
program. You said to just create a macro and use sendto. I don't know how to
do that. Any where I can go to learn how? Thanks in advance for any help
 
I would also like to send e-mail from access and I also am VERY new to the
program. You said to just create a macro and use sendto. I don't know how to
do that. Any where I can go to learn how? Thanks in advance for any help






- Show quoted text -
Click to expand...

dig around in here... you can use SendTo, use Outlook automation, use
the CDOSys library... there are several ways. Depends on the
complexity of what you're trying to do and how much control you need.
 
Hi,

I am going to give it to you step by step it's really easy for a basic email
from your form. Please follow carefully.

1. Create a new Macro
2. In the Action column select SendObject from the drop down menu
3. After you select SendObject the bottom portion of the Macro opens and
give you criteria for your email. Don't worry about the first three choices
unless you are sending a specific report, form, spreadsheet etc on a constant
bases like daily or weekly. If you have a specific email address that you are
send to only you can place it in the To field and it will always prefill when
you open the email. Just follow the fields listed and use what you want. BE
SURE TO SET THE EDIT MESSAGE FIELD TO YES if you leave it as No, after click
the button the email will be sent without you seeing it. After you have done
all this save the macro and name it.
4. Go to your Form and open it in Design View.
5. Create a new Command Button and when the wizrd menu opens just click
Cancel.
6. Right click on the button and scroll fown to the properties and click.
7. You can now name the button something other than the default which is
Command something and called it Send Email or something
8. Scroll down to the On Click Event and click on it to open the drop down
menu.
9. When the menu opens, you should now see the Macro you created. Select it
and close the properties box and close the form and when it ask you to save
say Yes.
10. Now open the form again and click on the command button you just
created. Give it a second or two and an email should open. Enter the email
address, subject, message and click send and your done. REMEMBER TO MAKE SURE
YOUR EDIT MESSAGE FILED IN THE MACRO IS SET TO YES!

You should not have any problems at all. There are many ways to sned emails
from Access. This is the simplest most basic. Using VBA Code, you can create
more elaborate ways of send emails but I would wait until you get a little
more familar with Access.

Good Luck!!


If all you want to do is send an email, create a Macro. From the drop down
list select SendObject then go to the bottom and enter whatever criteria you
want. Save the Macro and name it. Go to your form and create a command
button. Open the button to it's properties and go to the Click Event. On the
drop down select the Macro you just created and close the properties table
and save. You should now be able to click the command button on your form and
a blank email should pop up.
 
Does this depend on the version of Access? I am using Acc03 sp2 and it is
not working. I get an error message that I may not be using the correct
version of Access
 
The version of Access doesn't matter because you are using an Access Macro
built in the Application. You have to be using Outlook as your email source.
If you are using outlook as your email, using the Macro is guarnteed. I
personally have never had a problem with any database I created. I'm not sure
what you are referring to with sp2 what is that?
 
Back
Top