Send whole email from Excel without using Macros

In this post you will learn how to send whole email from Excel without using Macros.

You may know you can send email from excel with using VBA Macros but it is not so easy to understand everyone. Today I’ll show you how to send email from Excel without using Macros. We can send whole email from Excel by using just formula.

Lets Start –

Before starting tutorial make sure you should configure outlook in PC otherwise it won’t work.

I have written subject, CC and email body in column A and B as per below.

To send this email particular person we want link to click and auto create mail in Outlook. To Generate link, we are using HYPERLINK formula.

Now enter Name and Email List in Column A and B below or side of above Mail.

From above data and HYPERLINK formula we are going to generate link which help to create email directly in Outlook.

Formula is looking too big but it is very easy to understand.

Lets Understand Formula and Criteria –

 Hyperlink is required Two Criteria

1.       Link Location – Our Link location is as per below -

mailto – Select Cell where you have person’s Email ID. Here - B11

CC – If you have CC in your mail then select that cells. Here – B2

Subject – Select cell where subject appear. Here B3

Body – Body may contains multiple and blank lines so we are using “%OA” for next line and blank cell for blank lines

               

2.       Friendly Name – You can use any name for above Link which will appear in cell where you enter formula with link.

Make sure you have lock all the cells which use in CC, subject and Body as we are not changing any field. We are only change receiver email id.

Now you get link with Friendly Name. Here send e-mail.

Just Click on Link and you can see Excel will redirect to Outlook with whole email.

Now you are ready to send email from Excel without using Macros.

Note – As Hyperlink only support up to 256 characters so you won’t be able to large mails.

To Download above Template click on Link below –

Download Template 

Hope you understand how to Send whole email from Excel without using Macros 

If you have any issue then feel free to comments on Post.

Thank you

Watch Video - 

 Have a nice Day…. Enjoy Excelling……

outlook move email to folder automatically from Specific Persons

Outlook move email to folder automatically from Specific Persons

Sometimes you have received many emails from person which you think useless and don't want to read these mails. You just simply want to move them in particular folder without reading. Or you can read them afterwords. Also sometimes you want to directly move mails to specific folder receive from specific person which are not related to work at all. Like personal emails. So can save your time for reading them or move them. If you want to read them then all emails you can see in just single folder.

Today we are learning how to move email to folder automatically from specific persons in outlook

Lets Start - 

  

Click on Tools menu and go to Rules and alerts. Below Pop-up window will appear.

You have to crate new rules to those kind of emails. For that click on New Rules and default selection is Move messages from someone to a folder. Keep as it is.

Click on people or distribution list to add names of particular person. You can select contact from list or type email id in From field. If you want to add more contact then put semicolon in between each email id and hit OK.

People or Distribution List

Specific 

After adding contact to distribution list. Click on Specific to select folder where you want to move emails. You can create New Folder by clicking New button at right side or just select existing Folder.

  

After selecting folder click on OK and then Next in Rules Wizard. After that you can see lots of condition in next window. Keep as it is if you want to move all emails from particular person or change rules as per your requirement bye just putting tick mark against specific condition. Then click on Next.

In next window outlook ask what to do with that emails. Whether you want to delete them or move them etc etc. Select option as per your requirement. Click on Next.

 

In next dialog box you can add exception if any. Exception emails will be received in Inbox same as Normal emails.

Finish Rule setup. There may be emails in inbox before you creating rule. If you want to move them also in particular folder then select option Run this rule now on messages already in Inbox under Setup rule option and click on Finish button.

 Do not forget to click on APPLY button in Rules and Alert and then hit OK.

Now all the emails will be automatically moved to specific folder which received from particular person.

Video Tutorial - 

Hope you understand. Thank you. :) 

Thank you !! Have a Nice Day !!

Highlight Mails from Specific Person in Outlook

Highlight Mails from Specific Person in Outlook

There are lots option in outlook to organize your work easily and it help us to do work more efficiently if you know the options available in outlook and their uses. Sometimes we receive mails from lots of people and we might be forgot or overlook mail important mail from specific person.

If you know the mails from specific person are more important than other mails then you can highlight same on receive. Today I'll show you how to highlight those emails from specific person so you'll work on that mails on priority basis.

Lets Start -  


We are going to use Customize Current View to highlight mails from specific person. There are two option available to go to Customize Current View window.

1 . View => Current View => Customize current View - Process might be different if you are using different version of outlook. 

2. By Right Click  => Customize current View 

After clicking on Customize Current View you can see Customize View : Messages window.
Go to Automatic Formatting.



Click on Add button and give name to Rules as you want then click on Font and chose font you want which highlight mails from specific person and click on OK button. If different rules are apply for same mails then first rule will be consider. You can move up or move down to change priority of rules.

 
Then go to Condition. There are bunch of different condition available to highlight mails from specific person. Type email id in From for specific person. You can also select from you contact by clicking on From button.

Now hit OK. 

Whenever you receive mails from that specific person then it'll automatically highlighted in font which you choose.

Video Tutorial - 

Hope you understand. Thank you. :) 

Thank you !! Have a Nice Day !!