Windows 10: Introducing Send Email in Access 2013 web apps

Brink · Jan 12, 2015

One of the top feature requests we’ve heard from customers using Access 2013 web apps hosted inside Office 365 is the need to be able to send emails from their apps. We listened and today we’re proud to announce that a new feature called “Send Email” is available to all of our customers using Office 365 with Access Services. Now you can send emails from your Access 2013 web apps to other members of your organization! Look for this feature in your web apps soon and try it out.

In order to see and use this new feature, you need to update Access: you must be using Access 2013 that has a minimum build number of 15.0.4649.1000. Once your Office 365 site has the new Send Email feature work turned on, and you’re using the minimum Access 2013 build, you’ll see the new SendEmail macro action in the Action Catalog when you’re designing data macros.

How does the Send Email feature work?

You can use the new SendEmail action when you’re working with data macros—both named data macros and data macros attached to table events (On Insert, On Update, and On Delete). When you’re working with named data macros, which you can run from control events on views displayed in your web browser, you can, for example, send an email about a specific record you’re viewing. In this scenario, you could create a command button or a custom Action Bar button on a view that uses the RunDataMacro action in the On Click event to run your saved named data macro that includes the new SendEmail action.

When you’re working with data macros attached to table events, you can send emails when new records are added, existing records are edited, or records are deleted. In this scenario, it makes it easy to alert relevant users within your organization when new records are created, modified, or deleted. To get started, you just double-click SendEmail in the Action Catalog to add it to the macro logic defined for that table event and fill in the required parameters.

Let’s take a closer look at how this works in an example of sending an email from a table event, in this case an On Insert event of an Orders table in an Access 2013 web app. As you can see in the following screenshot, the new SendEmail macro action is available within the Action Catalog.

[/URL]

Let’s discuss what the other data macro actions defined in this On Insert table event are doing before we discuss the new SendEmail action.

First, the existing defined macro actions look up the email address and first name of the employee for the new order entered into the app and assigns that information to local variables that are used later in the data macro.

Next, the data macro looks up the company name for the order and assigns that to a local variable as well.
The next three SetLocalVar actions build up various parts of the body of the email message, using HTML tags to add further customization to the message body. For example, if you want to include a line break in the message, you can use a <br> tag in the message.

The last action in the macro logic for this example is the new SendEmail macro action. To add the new action to the macro design window, just double-click SendEmail in the Action Catalog. The SendEmail macro action takes five arguments: To, Cc, Bcc, Subject, and Body.

Argument-Required-Description
To - Yes - The recipients of the message whose names you want to put on the To line in the message. Separate the recipient names that you specify in this argument (and in the Cc and Bcc arguments) with a semicolon ;.

Cc - No - The message recipients whose names you want to put on the Cc (carbon copy) line in the message.

Bcc - No - The message recipients whose names you want to put on the Bcc (blind carbon copy) line in the message.

Subject - Yes - The subject of the message. This text appears on the Subject line in the message.

Body - Yes - The text that you want to include in the main body of the mail message.

For the To, Cc, and Bcc arguments, you can currently send emails only to people within your Office 365 organization. The email addresses used must be within the same company site or belong to guests of the site. For example, if your Office 365 company name is Contoso, the email addresses used with the SendEmail action must correspond to users of the Contoso site. Typically, they would be formatted as user@contoso.com[/I"]user@contoso.com"]user@contoso.com[/EMAIL][/I[/EMAIL]].

Each of the arguments in the SendEmail action accepts the use of expressions. If you want to use an expression for one of the arguments, first type an equal sign (=), followed by the expression you want to use. When you type the equal sign, Access displays the Expression Builder button on the right side of the argument text box. You can click this button and use the Expression Builder dialog to help you build the expression, or combination of expressions, you want to use.

Using expressions, you can create custom emails that display relevant data from the app. In the following screenshot, you can see an example of the Expression Builder dialog displaying the expression we used for the Body argument of the SendEmail action for this table event. In this example, the Concat function is used in the Body argument of the SendEmail action to concatenate the three local variables previously defined in the SetLocalVar actions. The three local variables are combining HTML tags, custom message text, and record data within the app and the Body argument expression is combining all three of them together for the full email message. You can be very creative with the email messages you send from your apps using these expression techniques and your own imagination.

[/URL]

Here’s an example of what a completed email message looks like when you enter a new order into the app with the defined macro logic shown earlier.

[/URL]

That’s how using the new SendEmail data macro action on table events works. For sending emails from named data macros, you define the data macro logic the same way: just by double-clicking SendEmail from the Action Catalog and providing the needed parameters. And you also have opportunities to customize your messages in these scenarios as well.

Being able to send emails from your apps opens up more possibilities for using your custom Access 2013 web apps built on top of Office 365. We hope you enjoy this new Send Email feature within Access 2013 web apps hosted inside Office 365. Give it a try and let us know what you think!

—Jeff Conrad is a Senior Content Developer on the Office Creative Content Development team.
Click to expand...

Source: Introducing Send Email in Access 2013 web apps - Office Blogs[/URL]

:)

Krishna Priya V · Jan 12, 2015

Delay in receiving message in Messanging App

Hi,

To assist you better let us know How are you accessing emails through web browser or through a mail client (mail app, outlook 2010/2013)?

When you say ‘’ Word Messaging App’’ do you refer to Skype app or any other app?

How exactly are you sending message to Windows Live Mail?

Please get back to us with all information we will be glad to assist you.

Thank you

Bannat77 · Jan 12, 2015

Sending Invites using IMAP email address Outlook web app

I need some help. I want to be able to use one email client for all email and calendar needs for my personal and business needs. My personal email is a Gmail account and I have a IMAP email for my business. I think the Outlook web app will work, but I'm
having some issues. On my PC, when I go to send a calendar invite from the web app, it doesn't seem to allow me to choose my work IMAP account to send from. I only have the option of sending from my Gmail account. When sending invites to business recipients,
I obviously want it to come from and respond to my work email. It looks like it will allow me to do this on my android phone. Is there a setting on my PC that I need to change?

Another question: Is there a way to sync my Outlook 2013 calendar to my Sunrise (now outlook web app)calendar? If so, will I be able to view events entered via Outlook 2013 on the OWA and vice versa? That will solve my problem I think.

Any help is appreciated. Thanks!

Windows 10: Introducing Send Email in Access 2013 web apps

Introducing Send Email in Access 2013 web apps

Introducing Send Email in Access 2013 web apps

Introducing Send Email in Access 2013 web apps - Similar Threads - Introducing Send Email

Introducing web capture for Microsoft Edge

Mail app for Windows is not sending emails

Can't send email from a gmail email acct from Outlook 2013- 0x800ccc81

Intermittent problem sending email in Microsoft Office Professional 2013 Outlook

Outlook app sends me to Web outlook.

Mail App unable to send emails

Outlook 2013 can't send email, can receive/reply

Introducing Web Authentication in Microsoft Edge

Introducing sonar - Linting the web forward