send email from excel to multiple recipients

send email notification from excel to multiple recipients
Dear Team,

Here i am but still i am getting error messge
please see the below code :

Please Login or Register  to view this content.

I would like to have a message in the below format :




Dear Sir/Madam,
Kindly provide the following clarification/ input required that we came acrosswhile processing your claim.
We would need your inputs to proceed further on processing of this claim.

Vendor Claim Details: Document No./ Ref No. XXXX [ having Invoice No -NO/LEGALCH/884 ] of Vendor code "XXX " of Vendor Name : "Vendor name

Reason for Holding : Kindly attach the finance head approval for releasing thepayment.

When you are sending any additional document, please attach a print out of thismail and then drop it in
Wividus Box.

We are awaiting your reply to proceed further.

*************************************************************************** **********
If the Hold document not resolved within 15 days from hold date the claim will be REJECTED

*************************************************************************** **********
For further clarification please feel free to conduct us.

Regards,
Team

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.

Hi, hariexcel1987,

Here i am but still i am getting error messge

No doubt: 5 For Loops with only 2 Next, rng not being set, Variable Z being used, but neither dimmed nor filled, same goes for Q, the following variables arenīt filled: D, F, p.

For a startup have a look at this:

Please Login or Register  to view this content.

The code for Ending Outlook is missing, I would probably use GetObject first with a boolean Variable for not ending it and on an error for doing so use CreateObject since to my knowledge Outlook can only be run in one instance on a computer.

Ciao,
Holger

Hi, Hari ,

the variable F isnīt filled with any information for a range and thus may be the cause of the run-time error:

Please Login or Register  to view this content.

Change the code to read (and check if Column P is the place to put in the second line)

Please Login or Register  to view this content.

On Debugging no error were thrown up which doesnīt mean that the code will run (sorry donīt have Outlook installed on this Computer, only Office 2010HSE).

CIao.
Holger

Hi, Hari,

due to the If checking if notification was necessary an email could only get send if that value was true. Please try this altered code which put the mail into my Outgoing mails:

Please Login or Register  to view this content.

And I think you should work a little bit on extra spaces in the text.

Ciao,
Holger

Hi, Hari,

please have a look at the following code. Both Chr(13) and vbCrLf may be used to force a new line in the string. According to the pattern laid out here you should be able to start making changes to the output on your own if you keep an original of the code as a safety and use either ' or REM to convert the codelines to comment which wouldnīt be executed:

Please Login or Register  to view this content.

Ciao,
Holger

ROn de Bruin has an article about that

Hi, hariexcel1987,

is there any reason why there isnīt much of code in the sample (in fact just two brackets not filled with an code in Sheet "DISC"?

Use an Autofiölter on Column P in "Hold-Data", run the range of visible cells and have a Case Select for the text to be shown in the mail depending on the value from Column P - thatīs the basic idea right now so that you will have to adapt the time range for the three macros but not the basic code to deliver the mails. If you prefer you could as well compose three nearly identical macros for each period, or use textfiles to hold the individual passages for the mail. You could as well step through all cells on Data-Hiold and compare P to the values for that period.

Ciao,
Holger

Hi, Hari,

as you changed the look of the sheet I kindly ask you to provide me with the updated code you use to send mail from that sheet. And please confirm that this is the final look of the sheet as there needs a column to be added (date of mail sent or day pending when mail was sent) as well as a formula being used for Column P days pending.

so I would like to request you to provide me code for to add if condition

The way I would go for a solution was laid out and there were several scenarios. As you want to adjust 2 macros on your own the If-Statements I feel that are needed are a check for the pending (Iīd apply an Autofilter to Column P) and for the date the last mail was sent.

Ciao,
Holger

Hi, Hari,

right now Iīm facing the fact that the macro that worked on the old file doesnīt create a mail on my system after I adapted it for the changes. Could you please check on your system if itīs working?

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Hari,

Originally Posted by hariexcel1987

It’s filtering the data but I am unable to send an E-mail to the recipient , actually it’s hanging could you please look into this

Originally Posted by HaHoBe

right now Iīm facing the fact that the macro that worked on the old file doesnīt create a mail on my system after I adapted it for the changes.

No, I canīt as I am on vacation right now and only know that an update on Windows has taken place but donīt know whatīs been changed there (and currently am on a very slow net next to beating bytes into the net).

Maybe I will be able to check this on the start of next week when Iīm back at work as I need a system with Outlook (and the laptop Iīm working on doesnīt do the job nor does it feed me with adequate information from the net in a reasonable time).

Ciao,
Holger

Hi, Hari,

the reason for Outlook not getting the mail might be the contents of Column R (have to fill manually). If you change the command .Send to .Display the mail will be displayed in Outlook. Or better you change the contents in Column R to valid e-mail addresses and try to run the macro again.

Ciao,
Holger

Hi, Hari,

display option is working fine but when I made it to .send all the excel files are hanging and it’s not letting me to close also , so please look into this,

I explained the reason for that in my last post, you donīt indicate that anything has been changed in your file (or at least you didnīt mention that).

I think we can delete filter option because I don’t want it to filter the data , simple I have to send the data if the condition satisfies

Are you taking about 10 sample data or 100.000? Whatīs wrong with the Autofilter which could be switched back with just one command at the end of the macro but will certainly save a lot of time in conjunction with SpecialCells as maybe only a part of all the data needs to be looked at.

And maybe you are kind enough to inform me about what we need to program concerning the sending of the mails. Do you want to send a mail each time the criteria satisfies?

Ciao,
Holger