Semi Colon (;)<\/strong>. This is very important to use semi colon to separate your Email IDs.<\/p>\n4. HTML Mail Body <\/h3>\n
In previous version there was no option to send your email in HTML format. It means all the emails were sent in plain text always. There were many suggestions regarding this feature from many avid users of my Blog. Few users wanted that even if they format there email in Excel cell, then it should go as it is. In this version you have got both.
\n
\nYou have much more flexibility to format your Email Body here in this version. Following are the few examples <\/p>\n
4.1 Mail Body formatted in Excel Cell<\/h2>\n
You can format your email in Excel Cell. Though here you do not have much option to format but whatever is available you can send same as in your email.<\/p>\n
<\/p>\n
4.1.1. How it Works? <\/h3>\n
There is one new function added to convert Excel Cell text in to HTML Code. So whatever email Text is written in the cell, is first converted in to HTML code and then it is sent as a HTML body email. <\/p>\n
Note:<\/i><\/strong>Following are the formatting of a text in a cell which can be converted by the Function:<\/p>\n\n- Font Color<\/li>\n
- Font-Weight : Bold, Normal<\/li>\n
- Italics, Under-lines<\/li>\n
- Alt+Enter<\/li>\n<\/ol>\n
In Excel cell though you can change the Font Size or Font Face of a selected text, but this is the limitation that the above mentioned function can not convert the Font Size and Face in to HTML code. Therefore it will be sent in by default Size and default face. <\/p>\n
\nThis limitation will be overcome by HTML code. Read further…to know how?<\/i><\/strong><\/p><\/blockquote>\n
4.2 Mail Body written in HTML Code<\/h2>\n
To overcome the above limitation in formatting, you can code your whole email in HTML. Here you can design your email in HTML with whatever formatting you want. There is not limitation here in formatting except that you should be aware of HTML coding to draft your email in HTML code.
\n<\/p>\n
4.3 Mail Body Formatted in Cell + HTML code both <\/h2>\n
If you do not have clue how to write your complete email in HTML code, there is a way here. Whatever formatting is possible in excel cell you can do and rest which is not possible in excel, you can write it in HTML code. <\/p>\n
This way the limitation mentioned above is overcome. Wow… then what are you waiting for?? Go and get some coffee and continue reading some more and amazing features of this tool…<\/p><\/blockquote>\n
<\/p>\n
4.4 Mail Body containing Text and Image embedded<\/h2>\n
Many of my blog readers asked this question:<\/p>\n
How to Embed some image in the email with some Text written in the email Body?<\/strong><\/p><\/blockquote>\nThis is achieved in this version of the tool. All you need is to put the below HTML code in your mail Body where ever you want your image to be embedded.<\/p>\n
<html><body>
\n… your mail body text…..
\n….
\n<img src=”D:\\Documents and Settings\\ihwa749\\Desktop\\logo.bmp”>
\n….
\n….
\n<\/body><\/html><\/p><\/blockquote>\n
<\/p>\n
5. What is different in sending Email via Outlook??<\/h3>\n
If you are sending an email via Outlook, then all the Signatures which are saved in your outlook will be loaded to select. As soon as you select any of the signature name from the drop down, Signature text will be displayed in a preview section as shown in the below image.
\nIf you do not want your saved signature to be used in your mails then you can select the first option as “No signature”.
\n<\/p>\n
6. Progress Bar With Messages <\/h3>\n
You have got very beautiful progress bar with message bar which keep giving you the current status. It will help you in not being impatient \ud83d\ude42 You can go and get a cup of Coffee and enjoy it with the new stylish progress bar which will keep informing you about the status in terms of completion %<\/strong>
\nMessage and progress bar<\/p><\/div><\/p>\n
7. With some bug fixes which was raised by many of our avid readers<\/h3>\n
There were few bugs in previous version for sending emails using GMAIL. I have fixed those bugs. In this version PORT number text box is made editable so that you can choose any port between 25, 465 and 587<\/strong>. <\/p>\nAfter trying all the 3 PORTS 25, 465 and 587, still you are not able to send emails using gmail, yahoo or any other, kindly write to me or comment here.<\/h2>\n
<\/p>\n
After a long read, here is your link to download it and Enjoy !!! DO NOT forget to provide your feedback about this version… your feedback, suggestions help me in improving my articles, tools, add-ins etc.
\n <\/p>\n
\n
<\/a>\n<\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email – VBA Tool. I have come up with the next version of the same tool based on your suggestions and feedback. I promise this version is going to amaze you with its new properties. I […]<\/p>\n","protected":false},"author":45,"featured_media":13639,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5205,2077,1682],"tags":[],"class_list":["post-12191","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-send-email","category-excel-tools","category-popular-articles"],"yoast_head":"\n
FREE Download : Send Multiple Email Tool - Ver 3.0 - Let's excel in Excel<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\n\n\t\n\t\n\t\n