Email : How to add read receipt in VBA.

How to add email read receipt in VBA.

In a previous post, I explained how to send emails in excel using VBA (send an email with attachments via Excel), but it was an illustration of the core stuff required to send an email via excel, update the information required to control the whole process that why I wanted to make minimal the solution and make it usable for everyone.

Obviously, some readers can’t live on bread alone and have asked how to achieve extras features

Many readers asked how to add the read receipt.

You have to set this property :

.ReadReceiptRequested = True

Where to add it ? in the code you have already in place so that the code will change in this way

Add email Receipt Confirm VBA

Add email Receipt Confirm VBA

There are a lot of other property that you can set and in this Microsoft’s page, you can find the most important and I suppose relevant to you ( a very useful property is “DeferredDeliveryTime” that allows setting the delivery time so you can optimize the

quantity of the emails send according to your email provider limits or the customers local times.).

Once learning how to set one you can easily set the properties you need.

How to send email from Excel

How to send email from excel based on cell value

Send email from excel will be really easy if you will read this post.

This post will give you a simple illustration of how to use the attached excel sheet to send emails or, if you need it, how to use the source code inside it in other excel files. I suggest to start from the base and modified it according to your needs.

Send email from excel : MACRO

The macro provides the following functions:

  • Reading data from excel
  • formatting body email
  • set recipients
  • set up CC
  • attach files
  • send the email
  • update sending data

excel sheet used to send email

Before to proceed it’s important to understand the meaning of the light blue arrow.

What does the LIGHT BLUE ARROW BELOW “SENT ON” mean?

It represents the range that the VBA macro automatically detects in order to process the email.

Your bulk email process can be handled by this short macro very useful and easy to manage (it’s easily implemented even by those who do not know much excel).

The excel sheet contains the information required by the macro refers (the code refers to the columns and not to the header) and a glance is sufficient to understand which kind of data we have available.

A delay has been inserted between sending an email to the other to avoid being blocked by the provider or, worse still, classified as spammers.

In case you want to add more data, add the columns always after the last provided in the example.servermx.com

This code has been tested in Excel 10 and Excel 2016 with outlook.

It’s is easily adaptable in other contexts and soon I will also provide other versions for different scenarios.

EXCEL FILE EXAMPLE & STRUCTURE – SHORT FIELD DESCRIPTION

First of all, take in account that the macro gets the first empty cell of the column H (8) and the first empty cell of column A (1) and uses these boundaries to instance the reading loop ( for .. to ..).

The column H (8) it’s very important because it’s used to store the email’s sent date  (the VBA code automatically populate this cell according to the elaborated row).

In this case, the loop while elaborate the row from 2 to 11.

EXCEL FOR SEND EMAIL  – COLUMNS & CELLS CONTENT

Even if is really intuitive let me give a brief synthesis of the columns.

  • Column A: Here you must to set the destination email (TO) and it’s a mandatory field.
  • Column B: Here you must to set presentation name used in the opening of the email (e.g. “Dear MAX “) and it’s a mandatory field.
  • Column C: It contains the email’s subject and it’s a mandatory field.
  • Column D: You can specify the signature to use at the end of the email (e.g. “Cheers Servermx.com “)  and it’s a mandatory field.
  • In column E  there is a value that can be used in the body of the email. In this example is a mandatory field, but it can update according to your needs.
  • Column F: Here you have to set the carbon copy destination of the email (CC)  and it’s an optional field.
  • The column G It’s used to get the attachment file (Attachment) and it’s an optional field.

Anyway, the code can easily update in order to change the body, subject and so on.

VISUAL BASIC CODE 

Vba macro used to send email via excel

In the end the core is :

  • Set OutlookApp = CreateObject(“Outlook.Application”)
  • Set Mess = OutlookApp.CreateItem(olMailItem)
  • With Mess
  • .Subject = Subj
  • .Body = Msg
  • .Recipients.Add (Email)
  • .CC = CC
  • .Attachments.Add (Attach)
  • .Send

DOWNLOAD

Here you can Download the excel file (it’s an xlsm ) : Email_send_blog

servermx.com 2018  servermx.offers servermx.features

How to set email web client with your domain name.

CNAME Records

it’s useful for instance, to rename a webmail client in case of your email being managed by an external provider.

CNAME stand for canonical nome a “CNAME stands for Canonical Name. CNAME records can be used to alias one name to another.”

It’s like a nickname … your name is Elizabeth but someone calls you Betty and when you hear one of two you respond…but what is more is that Betty will appear as to be your native name.

cname logo

cname

HOW TO SET WEB CLIENT WITH YOUR DOMAIN NAME

If you own your domain and entrust your email service to an external provider, it ‘s really probably that you will read the email via the client proposed by your provider that will use it’s own domain.to

This it’s not always appreciated especially from who, owning its domain, feel stronger inside the need to show it’s brand and mark its visibility.

So here we are to show how it’s easily renaming external email provider email client (Roundcube, SquirrelMail, Rainloop etc) and let it appear as is was yours.

A CNAME record on your DNS setup, basically allows that a link like: emailclient.myprovider.com being turned into myemailclient.mydomain.ltd (or whatever you need).

In your DNS panel you’ll find several records :
MX (to point the email server provider)
A (to set web entry)
etc
and you can also configure one, or more, CNAME records.

This example, you can find more details here, it’s based a servermx’ Roundcube client.

A servermx’ customer can access to its mail in several ways: one of this is the Roundcube client at roundcube.servemx.com.

If the customer domain, for instance, being mydomain.com he must to:
Go to DSN PANEL
ADD CNAME mywebclient.mydomain.com roundcube.servemx.com

MX cpanel setup

MX cpanel setup

Save!!!
That’s all
Now mywebclient.mydomain.com will point the Roundcube client of the external email provider, but the link showed to the email user will be
emailclient.shopstars.com and your custom Webmail URL will be set up.

How configure WordPress email account with Servermx

How do I can set up WordPress MX record? 2108

If you bought a domain via WordPress you will manage your domain configuration (DNS setup) using WordPress panel.

In case you want to use servermx.com (or anything else email provider) as your email provider what you have to do can be summarized in 4 step :

  • Log into your WordPress admin page
  • Log to WordPress DNS panel.
  • Change/Add MX record .
  • Add the TXT verification record (this step is required by servermx  but even by many other providers)
  • Log into your WordPress admin page :

 

Log into  WordPress DNS panel

Change/Add MX record.

  1. ADD (if there are no other previous MX records listed)
    1. Find Add New DNS Record button and select it.
    2. Select MX from the drop-down.
    3. In the Hostname text box, provide yourdomain.com (replace yourdomain.com with your domain name).
    4. In the handled by, set mx1.servermx.com, and provide the priority number as 10. Click Add
    5. Repeat the steps A-D with the values mx1backup.servermx.com and priority 20. 
  2. CHANGE (if there are other previous MX records listed)
    1. Find Add New DNS Record button and select it.
    2. Locate the current MX record
    3. Delete the current MX Record
    4. Follow the instructions set for the ADD action above mentioned.
  3. Add the TXT verification record
    1. Find Add New DNS Record button and select it.
    2. Select TXT from the drop-down.
    3. Leave blank the host box.
    4. In the text box, provide the string you find in your reserved area:
      1. link help Servermx: ServerMX Help page.
      2. link reserved area: your reserved area, in case you were connected at servermx.

If you want to know more information about servermx Mx record you can find at this link other details.

 

How to transform an email in a WordPress post safely.

How to transform an email into a WordPress post safely.

One of the most famous and appreciated plugin used to better configure an email as a gateway for creating an automatic post is POSTIE.

It’s really intuitive and easy to set up.
What you need is just to install POSTIE plugin and set up the incoming email.

Take into account that everyone who will send an email to the incoming email could create a post so it’s recommended to choose an email account that must be hard to suppose (e.g. b357fr1end5@servermx.com) and set up the default status to draft (to be able to verify the post before the publishing).

Setup the email Postie

It’s pretty easy. Next an example based on  servermx.com account configuration (here you’ll find other configurations parametrizations) :


You can set timing and other several parms.
It’s always better to check if the parameters specified are right.
You can use the TELNET command from the command prompt.
Open the command prompt and type: TELNET.
If TELNET is not installed type :
dism /online /Enable-Feature /FeatureName:TelnetClient
and press enter

Now, to test for example the connection setup above mentioned, type:
telnet pop.servermx.com 110
press enter and you should get the response from the email servers (type: quit to exit)
If you need specific plan for an email check it out at https://www.servermx.com/en/pricing.html

How “catch-all” option work?

How “catch-all” option work?

The catch-all option is a pretty useful function, but quite underrated

In few easy word, it allows addressing emails to a specific email account in case of the destination email is wrong.

Obviously, it works on a single domain.

You have only to set the account you want to be the catch-all account (e.g.: masteraccount@mydomain.com)
for being the catch-all account.

All the emails sent to <account>@mydomain.com in case of the <account> is missing will be delivered to masteraccount@mydomain.com.

other info at :servermx.com

 

Email and Web Hosting Separate? Excellent choice.

Email and Web Hosting Separate? Excellent choice.

When you purchase website hosting your website host usually offer you email boxes included in your pack.

The final result is, more or less, Something like name@surname.com : Professional, not anonymous an with your brand or name clearly stated.

In most cases, it’s not the best idea to have your email hosted by your website host.

Following we’ll share with you our idea why it’s an agreeable idea to save your email far from your website hosting, the best options for email, and details on how to set up email for yourself.

email vs vps

servermx

One problem is that you are Hosting your email and website on the same server.
Another one is that, usually, the “email” features is a core function of your business but it doesn’t for a hosting provider (The core business it’s the hosting) and even the support provides is secondary, in terms of quality, if compared to the one provided for the hosting.
One more issue might be that the Website hosting is not reliable and if the Hosting goes down for 1 day also your email goes down for 1 day.

Using website hosting for your email could chain you for more than the time you want.

Maybe at some point, you could decide to move your website somewhere else. Migrating a website is simple but migrating email can be a nightmare.

Obviously, If you worked with a reliable VPS or Dedicated Server it’s could seem ok, but you should take into account the infrastructure management costs and how to scale any further needs.

Proposal

Worldwide, There are several solutions, and one is ours.

Our solutions for the email is focused on :
Support, Reliability, Features, Flexibility.

The support is the king for so important service such as the email.
That’s why we like to say that we provide a proactive support (it’s better to prevent a problem than facing) and we have in place several tools (lot of them highly customized to better fit the customer needs) to detect issues about, for instance: Privacy, Spam Management, Attachment management and so on.

We invest also in new features to make easier the email management such as, for example, the “Dropbox upload management” that allows to our customer to get the email attachment straight to in their Dropbox account without reading the email (it’s a features server-side based).

https://www.servermx.com/en/features.html here there are the major features provided by Servermx.

Punycode conversion for MX records

Internationalized Domain Name (IDN)

If your domain name containing international (non-ASCII) characters, you must to convert the domain name into “#Punycode” and next insert it into the DNS server.

With this IDN Conversion Tool, you can see how your name will visually convert from special characters to a name in ASCII characters (and vice versa).

In this way, you can manage without any problem your domain.
The following first level domains support IDN registration.

.ac,.ae,.ar,.at,.bd,.bi,.br,.ca,.co,.ch,.cl,.cn,

.de,.dk,.es,.eu,.fi,.gr,.hk,.hu,.id,.in,.io,.ir,.is,

.it,.jp,.kr,.li,.lt,.lv,.mu,.mn,.ne,.no,.nu,.or,.pe,

.pl,.pt,.se,.sh,.su,.tm,.tr,.tw,.vn,.ws

  • How to convert the domain name in “Punycode”

There are several online sites that provide this conversion, for instance :
https://www.punycoder.com/
Next an example:

Once converted you have to use the Punicode translation in every part of the email configuration where required :MX, TXT records and so on