Send E-Mail to list of individuals defined in a particular Range

Also update the sheets with the sheetname Rawdata and E-Mail list with wksRawdata and wksEList in VBA editor.
Regards,
Loki

Hello lokicl,

Thank you so much for your immediate support!

I really appreciate the way you break down my query with the code. As I am a beginner with VBA, formatting the code to get rid of the error is little challenging for me. Hence if you can help me in getting the clarification on below listed issue, it would be truly help full for me.

1. As you said, I had copy paste your code into new Module in VBA and renamed (is there any specific reason for wksrawdata & wksElist name) the worksheet as you mentioned.

2. Now, When I am trying to run the Macro I am getting an Error like “Run-time error ‘424’: Object required”

3. In the VBA code we have something called “For i = some number like 3, 2 6”, where as we have not defined anywhere what is this i!

4. Last but not least, as mentioned early I am completely new to this VBA, So for each of your code if you can update me comments like 'Outlook.Application, 'Change this string - according to your system setup - c: or D:. I can have more clarity on your code.

Once again Thank you for your time on this!

Thanks & Regards,
Rajeshkumar R

Hi Rajesh,

below are my comments:

1. As you said, I had copy paste your code into new Module in VBA and renamed (is there any specific reason for wksrawdata & wksElist name) the worksheet as you mentioned
- it should be renamed in the respective Sheet properties

2. Now, When I am trying to run the Macro I am getting an Error like “Run-time error ‘424’: Object required”
- you have renamed the worksheet - Requested you the update the sheet name in the Sheet properties - when you open the VBE Editor - click on the sheet and update the name - hence the error

3. In the VBA code we have something called “For i = some number like 3, 2 6”, where as we have not defined anywhere what is this i!
- "for i" is a loop statement - the number 3, 2 etc defines the start of the counter


4. Last but not least, as mentioned early I am completely new to this VBA, So for each of your code if you can update me comments like 'Outlook.Application, 'Change this string - according to your system setup - c: or D:. I can have more clarity on your code.
- this will run only with Outlook Application
- the string is - your signature stored path e.g. as per my system setup it is D: but mostly the user profiles will be in C:

However attaching the working project. Check you signature path and update the sig string. I will work.

Thanks & Regards,
loki

Hello lokicl,

Once again Thanks for your valuable explanation and attached file as well. Hope now its working fine. However, I found few observations as below, when I started to work on the file.

1. E-Mail is reaching only to Cc: Recipients and it’s not reaching to any of To: Recipients.

2. Subjected of the E-Mail is only picking up first zero of Serial number like “Serial Number 2 is waiting for the Approval”. Instead it has to pick all serial numbers which is defined as zero in Column N.
“Serial Number 2,4,6,7,8,9,11,12,13,14,15,16 is Waiting for the Approval” (As I mentioned in the first post).

3. File Name is just getting pasted as is like text in the body of the E-Mail, but it has to get pasted as Hyperlink path, so that the recipient can just clink of the link and get open the File.

4. I just thought instead of Signature, let us give the message like “It’s an Auto Generated E-Mail” only.

Thanks & Regards
Rajeshkumar R

Hello lokicl,

Any help and support on my previous post!

Thanks & Regards,
Rajeshkumar R

Hi Rajesh,

Please find attached the updated tool.

Request you update the To list with valid mail id, because it is working fine for me.

Regards,
loki

Hello lokicl,

Amazing, now the file is working exactly the way I need… Simply superb…. Thank you so much for your great support on this….

Thanks & Regards,
Rajeshkumar R