• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there any way to send an automatic email to all the employees

K

KiKi

Member
I need to send an email to all the employees (info about employees stored in an excel sheet). Email content is the worksheet (another excel sheet where there is a seperate worksheet for every employee) corresponding to that employee? Any help would be helpful
 
Luke M said:
It is possible, but you'll need to do some reading to to tailor the code to your exact layout. I'd start with Chandoo's post here:
http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/

After that, Ron's has some pretty slick template here:
http://www.rondebruin.nl/win/section1.htm

You should be able to read through those two and get a good understanding of what type of coding you will need.
Click to expand...
I read both of these and understood too... however, i need to see the code behind Ron's template... as in one worksheet, i will have all email ids and name to whom email needs to be sent out and in other worksheets i will have tabs with same name as in first worksheet to send the corresponding worksheet to that email id. so i will need to compare the name (in 1st worksheet) with the subsequent worksheet name to send the meaningful data.
 
Luke M said:
Don't know where you were looking, but almost all of Ron's sheets provide the code directly. Did you look around here?
http://www.rondebruin.nl/win/s1/outlook/mail.htm
Click to expand...
I am very new to VB. i did some research this morning and got it where i could find the code.I was using the add-in here http://www.rondebruin.nl/win/s1/templates.htm (pdf one: RDBMailPDFOutlook) which was matching my requirements. I also made some modification in the file. However now i want to make body of the email as dynamic, i.e. rather entering it into separate column, i want to take name from a additional column and want to use it " Hi {Name}, please find attached file for the data". 'please find attached file for the data' will be static.
 
Sounds good. Would it be possible for you to upload your workbook, or an example with same layout? Please include any mail code that you already have so far.
 
Luke M said:
Sounds good. Would it be possible for you to upload your workbook, or an example with same layout? Please include any mail code that you already have so far.
Click to expand...
Sure. Please find attached files. So instead of using the text in Body text field, i want to use an extra column "name" [will be inserted] to say Hi {Name} and then rest of the code i will keep static. Thanks.
 

Attachments

Hi Luke, I hope you are doing good and nice to see this thread..
The functionality given in 'send-mails-using-excel-vba-and-outlook' is really useful and amazing.

A quick q:
Is it possible to capture a screenshot image of a range from rawData worksheet (for example : rawData Tab, range $A1 TO $L21) and make this range as screenshot image visible in the email body itself along with remaining existing functionality is greatly helpful. unable to attach the original file (email.xlsm) says it is too large..

Thank you
Mahendra
 
Hi Mahendra,

Good to hear from you as well. If you could start a new thread rather than posting in this older one, that would be much better. Other people would be able to see that you have a new question. e.g., I only saw your post because I automatically monitor threads I've previously replied to, but others would probably ignore it since it already had a response.
 
Thanks for responding Luke.
I will start a new thread on this as initially I was searching for email functionality and this thread popped and saw last response on this around December last year.

I will prepare my template excel file with short data and post it some today with new request.

Regards
Mahendra
 
You must log in or register to reply here.
Back
Top