Email address from field?

[Matticus]

Hello, is it possible to send an email after pressing a button to an email address which is within a field? If so where should I start?

 

[pr2-eugin]

Hello Matticus, Welcome to AWF..

You could start by explaining a little bit more on the requirement..

 

[David R]

Specifically what email program you're going to be using, do you want to just start the email or send it automatically/invisibly, are there attachments, etc...

 

[Matticus]

Thank you for the quick replies, I have a table with a list of people and their email addresses. I was hoping to have a form where you could select the person from a combo box or something and then click a button which would open a space to write and send an email with attachments, a friend of mine told me it was possible to do this all within Access otherwise I'd like to use Outlook.

 

[pr2-eugin]

It is possible with Access. The real question is are you strong with VBA? There are plenty of tutorial on Email from Access.. A simple Google search should get you several hits.. Go through some of them..

Step by step to achieve, Create a Form that will mimic the Email Window.. Then there should be a little bit of coding to achieve what you want to do..

 

[David R]

Any particular reason you want to build your own email interface rather than using Outlook? Do you need to track when/if the email was actually sent, within your database?

 

[Wayne]

Try this link. It has a form you can use to send e-mails right from Access, and you can populate the message box with info from your database, as well as the e-mail addresses. You'll have to tweak the code a little, but it works well.

Cheers


http://www.access-programmers.co.uk/forums/showthread.php?t=205417&highlight=send+email+form