Set Up an Email Field

[teetertotter57]

Hi,

I have an Email field on a form. Is it possible to send an email by clicking on the email address? Now, I only have a vague familiarity with VBA as I've taken an Access Intermediate class. We were just introduced to it at the end of the class, so you may have to walk me through it like a 6 year old. I went to a site that said a macro was needed in either the After Update, After Delete, or After Insert. With that said, I know where to go, but I don't know exactly how to write the code. I have outlook set up on my computer and am operating Windows 8.1 and Access 360, if this helps.

Thank You,
Regina

 

[jdraw]

With Access you can set it up to send an email from msAccess to Outlook.
Here's a sample

But, you mention Access 360, and I have no experience or knowledge of it.

 

[teetertotter57]

Jdraw,

Thanks for the reply. Office 360, I should have said, is on the cloud, I think. We can load it on all our computers and it's updated automatically with all kinds of benefits. We subscribe annually.

I checked the sample out, and I'll need to study it a bit. I may need a little help. At first glance, it appears I'll need to create a form. Is that correct? Then, I assume I would link to that form via and event procedure? As I said, I'm learning.

Thanks,
Regina

 

[jdraw]

That was just one of the links I found when googling.
You'll find others on the internet. I'm not sure what techniques are available to you when working with
Office 360 --- you may or may not be able to use vba??? I don't know Office 360, so you may have to do some research before getting too deep into a "solution" that may not be applicable to Office 360.
I think it may be Office 365???
see http://office.microsoft.com/en-ca/office365home/

 

[jdraw]

I found some info re: Office365

What about Office 365 - how does that fit in?

In creating a Web App, we have the choice of hosting it on SharePoint or on Office 365. Office 365 is different than SharePoint. It's Microsoft's hosted version of SharePoint and Office rolled into one. It's a subscription to the Office Suite that we're familiar with, but the applications are hosted online and streamed to our computers, and with our subscription we can have access to the Office 365 applications from any location or device (again, Microsoft's high-level goal is being able to access everything from anywhere). So basically, it's Office through a webpage.

O365 has a number of subscription levels available, each varying in cost and in what features and applications are provided. Some O365 subscriptions allow the creation/hosting of Access Web Apps, some don't. (note to self, find a decent link of the comparisons and put it in here).

SharePoint is absolutely required to have Access Web Apps, as SharePoint's Access Services is what ultimately hosts the App and does all the magic. With an O365 subscription of the correct license level, O365 takes care of the SharePoint stuff for us so we don't have to worry about it.

This is from http://www.dymeng.com/blog/WebAppPrimer
by Jack Leach

 

[teetertotter57]

Yea, I told you I was new at this. It's 365...lol. I still have another week in my class, as well. My instructor also provided a link. I'll work on this, but you may hear back from me as I run into problems with the execution.

Hay, Jdraw, Thanks a Bunch,
Regina