Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:viewer.export.massemailsmtp [2023/08/08 21:57] – administratoren:viewer.export.massemailsmtp [2025/09/29 20:03] (current) – created administrator
Line 1: Line 1:
-====== SMTP export ======+====== Mass email via SMTP ======
  
-{{ :massemailsmtpexport1.png?nolink |}}+Database Application Pro allows you to easily send mass emails using the [[https://nl.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol|SMTP protocol]].
  
-===== Toolbar =====+The settings are stored in your database, so you always have them to hand even if you open your database on another computer.
  
-No+{{ ::massemailsmtpexport14.png?nolink |}}
  
-===== Status bar ===== +Setting up your SMTP e-mail is done via the [[viewer.export.massemailsmtp.forms.designer|SMTP email designer]].
- +
-No +
- +
-===== Actions ===== +
- +
-  Note: Specific knowledge of SMTP server settings and building the HTML or plain-text email template is required to use this export method successfully.   +
-  This page only gives you the explanation of how the various settings work and a basic example for the HTML email and plain-text template.  +
-  We do not provide support on finding the correct server settings and/or designing email templates and their display/operation in the final email application.   +
-   +
-Using this export method, you can send mass emails directly from Database Application Pro using the [[https://nl.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol|SMTP protocol]]. Database Application Pro will communicate directly with the specified SMTP server. +
- +
-==== Sending e-mails ==== +
-via the ''Send e-mails...'' emails are sent to the specified entities. This button is only available when you have entered sufficient information. +
- +
-After sending, you will always see a result window displaying any errors. +
-If everything went successfully, the window looks like this. +
-{{ :massemailsmtpexport7.png?nolink |}} +
- +
-If an error occurs, this will also be displayed and the general result will be ''Failed'' will be. To know exactly what goes wrong, it is sometimes possible to see the internal error, this will give you more information about what goes wrong between Database Application Pro and the SMTP server. By clicking on the ''View error'' you will get a window with the actual internal error message. +
- +
-In the example below, you can see that the SMTP server indicates that authentication failed, which is correct because in this case the password was entered incorrectly. +
-{{ :massemailsmtpexport8.png?nolink |}} +
- +
-==== Test e-mail ==== +
-Via the ''Test e-mail...'' there is the possibility to do a test send of the first e-mail to a manually specified e-mail address. This allows you to send this e-mail to yourself and check whether the e-mail is constructed and displayed properly. This button is only available when you have entered sufficient information. +
- +
-{{ :massemailsmtpexport6.png?nolink |}} +
- +
-===== Tabs ===== +
- +
-==== Settings ==== +
-{{ :massemailsmtpexport1.png?nolink |}} +
- +
-=== Actions === +
- +
-In this tab, you specify the settings to send emails via SMTP. After sending the e-mails, the settings, excluding the SMTP password, are permanently saved. This avoids you having to enter all SMTP settings every time, only the password will have to be entered every time. +
- +
-== Email content == +
-**Subject**\\ +
-This text is used as the subject of the email, you will therefore also see this text in the final email application as the subject of the sent email. There are no placeholders possible in this text. +
- +
-The example below is how the subject is displayed in Microsoft Outlook 2013. +
-{{ :massemailsmtpexport3.png?nolink |}} +
- +
-** HTML email text & Plain text email text **\\ +
-Here you select the template file used for SMTP e-mail sending, you must choose at least one of the two types. If you select both an HTML and a plain text template, both will be sent with the actual e-mail transmission. It is then up to the final e-mail client which of the two is displayed, normally an HTML e-mail text will always be preferred, only when an e-mail client does not support HTML will the plain text e-mail be displayed. +
- +
-== Address of == +
-** Display name **\\ +
-The display name associated with the e-mail address with which the e-mail will eventually be sent. This name is usually displayed in the e-mail client application as the sender of the e-mail. No placeholders are possible in this text +
-** E-mail address **\\ +
-The e-mail address that is displayed and the e-mail client. +
- +
-The example below is how the display name and e-mail address is displayed in Microsoft Outlook 2013. +
-{{ :massemailsmtpexport4.png?nolink |}} +
- +
-== Address to === +
-** Display name **\\ +
-The entity field that contains the display name associated with the e-mail address to which the e-mail is ultimately sent. +
-** Email address **\\ +
-The entity field which contains the actual e-mail address to which the e-mail is sent. +
-** Type **\\ +
-Here you specify how the recipient's e-mail address is used in the e-mail. This can be the ''To'', ''CC'' or ''BCC'' field. Because a separate e-mail is created for each entity, e-mail addresses of other entities will never be sent along in the ''To'', ''CC'' or ''BCC'' field. +
- +
-The example below shows that when e-mails with type ''BCC'' are sent there are no ''To'' address is displayed in Microsoft Outlook 2013. +
-{{ :massemailsmtpexport5.png?nolink |}} +
- +
-== SMTP server settings == +
-In this group, you specify the server settings to connect to the SMTP server. +
-You can usually request this data from your internet service provider or hosting party. +
-** Server address **\\ +
-The address of the SMTP server used to send e-mails. +
-This can also be a direct IP address. +
- +
-** Server port **\\ +
-The port by which the SMTP server is to be reached. +
-This is usually port 25 for unsecured connections (SSL off) or port 465 or 587 for secured connections (SSL on). +
- +
-** Use SSL **\\ +
-Indicates whether you want to use a secure connection (SSL on) or not (SSL off). +
- +
-** Username **\\ +
-The user name with which you authenticate to the SMTP server. +
- +
-** Password **\\ +
-The password with which you authenticate to the SMTP server. The password is **not** stored. +
- +
-==== Available fields ==== +
-{{ :massemailsmtpexport2.png?nolink |}} +
- +
-=== Actions === +
- +
-This tab gives you the different variables to use in the e-mail template. Each field ''%%{{:fxx}} %%'' will be replaced with the entity's actual value when generating the e-mail. +
- +
-===== Examples ===== +
- +
-==== Plain text email ==== +
-A plain-text email is relatively simple, using a ''.TXT'' file, a text with variables is constructed. This can be done, for example, with Notepad which comes standard in Windows. +
- +
-The image below shows an example email template, in this example field 27 (''%%{{%%F27%%]]%%'') is the field which contains the full name of the entity. +
-{{ ::massemailsmtpexport9.png?nolink |}} +
- +
-Next, select this ''.TXT'' file as ''Plain text e-mail text'' and enter the rest of the data. +
-{{ :massemailsmtpexport10.png?nolink |}} +
- +
-After sending, the email will look like this in Outlook 2013. +
-{{ :massemailsmtpexport11.png?nolink |}} +
-==== HTML email ==== +
-Building an HTML email is relatively difficult to do and requires specific knowledge of HTML, CSS and how email clients work. +
-To show the principle, this example uses a simple free-to-use template. +
- +
-The template can be found here [[https://github.com/leemunroe/responsive-html-email-template|htmlemail.io]], and then the ''email-inlined.html'' example. +
-Download this file and save it to your computer, then open the file in an editor so you can enter the variable. +
- +
-In the example below, on line 117 the field 27 is placed as a variable, this field contains the full name of the entity. +
- +
-{{ :massemailsmtpexport12.png?nolink |}} +
- +
-Next, select this ''.HTML'' file as ''HTML e-mail text'' and enter the rest of the data. +
-{{ :massemailsmtpexport13.png?nolink |}} +
- +
-After sending, the email will look like this in Outlook 2013. +
-{{ :massemailsmtpexport14.png?nolink |}} +
-===== Hotkeys ===== +
-==== Window wide ==== +
- +
-The following hotkeys are valid across the entire window, they do not depend on the focus on a particular component +
- +
-^ Hotkey ^ Action ^ +
-| F1 | Call up online documentation| +
-| Alt + F4 | Close window| +
- +
-==== Component-specific ==== +
- +
-No+

Trace:

Print/export
QR Code
QR Code en:viewer.export.massemailsmtp (generated for current page)