Send Bulk Email from Excel for Outlook

Download the File from below Link

https://drive.google.com/file/d/1tcb4lzNFgEfDKsvQqCW05sgoiGFEhqcK/view?usp=sharing

Instructions are given in the image below. Save the File as Excel Macro - Enabled workbook (.xlsm)

Use this file to send bulk emails at a time i personally have sent more than 2000 bulk emails at a time.

Error may occur if email id typed contains space etc. Only one email id one cell.

Comments

Charts - Make your data presentable

One-click charts are easy: Select the data and press Alt+F1 . What if you would rather create bar charts instead of the default clustered column chart? To make your life easier, you can change the default chart type. Store your favorite chart settings in a template and then teach Excel to produce your favorite chart in response to Alt+F1 . Say that you want to clean up the chart above. All of those zeros on the left axis take up a lot of space without adding value. Double-click those numbers and change Display Units from None to Millions. To move the legend to the top, click the + sign next to the chart, choose the arrow to the right of Legend, and choose Top. Change the color scheme to something that works with your company colors. Right-click the chart and choose Save As Template. Then, give the template a name. (I called mine ClusteredColumn.) Select a chart. In the Design tab of the Ribbon, choose Change Chart Type. Click on the Templates folder to see the template that ...

Improve your Excel Productivity with these Shortcuts and formulas

I have given below 45 tips and tricks to improve your productivity while working in Excel. Useful Keyboard Shortcuts 1. To format any selected object , press ctrl+1 2. To insert current date , press ctrl+; 3. To insert current time , press ctrl+shift+; 4. To repeat last action , press F4 5. To edit a cell comment , press shift + F2 6. To autosum selected cells , press alt + = 7. To see the suggest drop-down in a cell , press alt + down arrow 8. To enter multiple lines in a cell , press alt+enter 9. To insert a new sheet , press shift + F11 10. To edit active cell , press F2 (places cursor in the end) 11. To hide current row , press ctrl+9 12. To hide current column , press ctrl+0 13. To unhide rows in selected range , press ctrl+shift+9 14. To unhide columns in selected range , press ctrl+shift+0 15. To recalculate formulas , press F9 16. To select data in current region , press ctrl+shift+8 ...

Recover Unsaved Excel File

We normally avoid these settings but in the hour of need they save us rework time. So if your working on a excel file and you forget to save it or click on don't save by mistake, follow below steps If the workbook was open for at least 10 minutes and created an AutoRecover version, Excel kept a copy for you. Follow these steps to get it back: Open Excel. In the left panel, choose Open Other Workbooks. In the center panel, scroll all the way to the bottom of the recent files. At the very end, click Recover Unsaved Workbooks. Excel shows you all the unsaved workbooks that it has saved for you recently. Click a workbook and choose Open. If it is the wrong one, go back to File, Open and scroll to the bottom of the list. When you find the right file, click the Save As button to save the workbook. Unsaved workbooks are saved for four days before they are automatically deleted. Use AutoRecover Versions to Recover Files Previously Saved Recover Unsaved Workbooks applies only to files that...

Solutions for Data Science

Search This Blog