VBA code for sending delayed emails in Lotus Notes.

[CarlStephens]

Hello All,

I have the below range of information, and I am looking for a code that will send an email to the individual in Lotus Notes using the email address in column E, the subject and body will be scripted in the code, and the code will copy the relevant header information from columns J to O as well as the doc status in the email in the below row and paste it the email. When each email is sent, the code will need to then wait 6 seconds before sending an email to the next person in the row, so Lotus Notes does not think that it is spam emails being sent. Is this possible?

Thank you

 

[John_w]

Try adapting this code:

Macro for sending different mails to different people and attaching different files to them in lotus notes

Hi, Can any one help me in this. I am very new to vB as well as Macros. I would like to send different mails to different people with different attachments. Please find my excell sheet coloums for your understanding 'firstname' 'lastname' 'emailid' 'attachmentpath' 'phonenumber' I would...

www.mrexcel.com

Use Application.Wait DateAdd("s", 6, Now) inside the loop to wait 6 seconds between each email.