VBA code for sending delayed emails in Lotus Notes.

CarlStephens

New Member
Joined
Sep 25, 2020
Messages
40
Office Version
  1. 2016
Platform
  1. Windows
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

1604933065429.png
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

John_w

MrExcel MVP
Joined
Oct 15, 2007
Messages
6,529
Try adapting this code:


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

Watch MrExcel Video

Forum statistics

Threads
1,118,270
Messages
5,571,238
Members
412,372
Latest member
JON_ROCKS
Top