Adding Outlook Email Tool In Excel 2010

Sometime it happens that you need to send Excel worksheets via email, but for that you don’t need to follow the orthodox way of sending datasheet by attaching it with email. Excel provides a tool, which enables you to send it over with a single click. This post illustrates how to make Email option apparent in Excel 2010, and how to use it.

Note: This procedure requires Outlook to be installed and configured on your computer

Launch Microsoft Excel2010, go to File menu, click Options, and in left pane click Customize Ribbon, in right pane select All Commands from Choose commands drop-down options and look for Email, Email as PDF Attachment, and Email as XPS Attachment commands. Now from left pane, hit New Tab, change it’s name to Outlook, and then click New Group to create group in the newly created tab, give it an appropriate name. Now click Add >> button to add Email-related commands to newly created group. Click OK to close Excel Options dialog.

Now navigate to newly created Outlook tab, you will see commands added earlier.

Now open the datasheet which you want to attach with an email.

If you want to attach datasheet as default Excel format (.xlsx), then click Email on Outlook tab.

Outlook mail window will open, you can see the attached Excel datasheet. Now you just need send it to the recipient.

For sending datasheet as PDF copy, click Email as PDF Attachment on Outlook tab. Outlook mail window will open, showing PDF format as attached file.

Upon double-click the attached file, you can open the datasheet in PDF format to verify the data positioning etc.

Read more

Send Outlook Mail to OneNote 2010

Outlook 2010 has an intrinsic feature which lets user to transfer mails to OneNote 2010, it could be very useful, if you are using OneNote 2010 for taking notes, by sending email content, you will able to complement the note which is related with an email.

Launch Outlook 2010, and open the mail you want to send to OneNote, as shown in the screenshot below.

Now navigate to Home tab, and click OneNote

Select the location where you want to place the email in OneNote sheet, if you are having a lot of sheets in OneNote, you can also search them by providing search keyword. Click OK after selecting one.

Upon click, it will automatically send all the related email content; subject, sender email address, date/time, to selected OneNote sheet as shown in the screenshot below.

Read more

Outlook 2010 Email Tracking

After sending the email, sometime it becomes a frantic need to know when the recipient will start reading it, Outlook has an intrinsic feature which lets you know immediately when the person starts reading your message. By using Tracking, you can track down the email. This post elaborates how you can enable this feature.

Launch Outlook 2010, and from Home tab, click New E-mail.

Navigate to Options tab, and From Tracking pane enable Request a Read Receipt option, now click Send to send it to recipient.

By enabling this option, the recipient will be asked if he is willing to send the receipt back to the sender.

Upon clicking Next, Outlook will send a receipt containing time of reading mail back to the sender, with the same subject (RE). You will also notice on receiving receipt that, there is a small icon will be appeared adjacent to the Flag graphic, representing that, it is only the receipt, not the reply from the recipient.

On opening the receipt, it will be showing the time/date of mail, when it was sent and when it was read.

Read more