Composing Oulook Daily Emails for Staff Reporting

Dear Experts,

I am seeking your assistance to be able to draft emails on Outlook to send their daily stats. I have around 300 folks, and increasing, which has made my life somewhat difficult.

Here’s what I would like to do:

• Tab Name: Emails – It has the distribution list
• Tab Name: Email Template – It is the email template which I’ll be changing from time to time
• Sheet 1: Has the first set of details by employee
• Sheet 2: Has the second set of details by employee
• Sheet 3: Has the third set of details by employee

I request your assistance to be able to create separate emails for each employee on MS Outlook, but don’t want them to be sent directly. Only drafts get created, and I review before hitting the send button.

The requested format of the email is in the attached word document along with the spreadsheet that I maintain for compiling and sending the details.

Your kind assistance is very much appreciated. Thanks a billion!

Happy to provide any further details. Please let me know..

Thanks,
Spi

Could someone please help me on this request.

I'll be obliged.

Thanks,
Spi

Hi Spi

Try the Code in the attached...CTRL + x will fire the Code.

Fantastic! Thanks a million sir. I'll try and come back shortly.

Hope you are doing great. I had been off the forum and work for quite a bit.

Wishing you the very best!

Originally Posted by jaslake

Hi Spi

Try the Code in the attached...CTRL + x will fire the Code.

Dearest John,

This works like a charm. You are the best!

However, my boss wants me to make 2 last minute adjustments. They are as follows:


Add 2 columns in Sheet 1 - Date and Duration (I've highlighted them in Green for ease of reference)
Add some extra Accounting details in Sheet 3 (Columns highlighted in Grey)

I've attached the code sheet with the word doc of the final output email.

Request your kind assistance.

Hi Spi

Change the two indicated Lines of Code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Superduper! I'll run this with my original data and get back to close the thread shortly.

Sir - You made my day....

Thanks a lot

Thanks a zillion Jaslake.

Please accept my apologies. I had been experiencing connectivity issues since last night.

It is an awesome piece of work. I'm greatful.

God bless you!