Read emails from txt and add them to recipients

[Identis]

Hello,
I have txt file where I have users emails, number of users can change every month.
example txt:
[email protected]
[email protected]
[email protected]
How I can read and add these users to SMTPSendMail> command ?

Thanks in advance.

[Dorian (MJT support)]

To loop through the email addresses and send them one by one, the structure would be something like this (assuming you already have the regular SMTPSendMail aspects accomplished) :

Code: Select all

readfile>d:\emails.txt,AllTxt
Separate>AllTxt,CRLF,Lines

let>readloop=1
repeat>readloop
  Let>thisemail=lines_%readloop%

  SMTPSendMail>%thisemail%,post.mail.com,me,myname,subject,body,

  let>readloop=readloop+1
Until>readloop,lines_count

[Identis]

To loop through the email addresses and send them one by one, the structure would be something like this (assuming you already have the regular SMTPSendMail aspects accomplished) :

Code: Select all

readfile>d:\emails.txt,AllTxt
Separate>AllTxt,CRLF,Lines

let>readloop=1
repeat>readloop
  Let>thisemail=lines_%readloop%

  SMTPSendMail>%thisemail%,post.mail.com,me,myname,subject,body,

  let>readloop=readloop+1
Until>readloop,lines_count

Hi,
I want to send one email to all users (all users in recipients field) not a separate email to each user. Is it possible ?

[Dorian (MJT support)]

Yes, this does that :

Code: Select all

readfile>d:\emails.txt,AllTxt
StringReplace>AllTxt,CRLF,;,EmailList
Let>SMTP_CCLIST=EmailList
SMTPSendMail>EmailList,%SMTPServer%,me,myname,Subject,Body,

You can also try SMTP_BCCLIST instead of SMTP_CCLIST. However, during my tests (Macro Scheduler 15.0.21) sending via Gmail I noticed this is CCing and not BCCing. Please let me know if you get similar results and I'll mention it to dev.

SMTPSendMail : To include CC or BCC email addresses set the SMTP_CCLIST and SMTP_BCCLIST variables. Separate multiple email address with semicolons.

[Identis]

Yes, this does that :

Code: Select all

readfile>d:\emails.txt,AllTxt
StringReplace>AllTxt,CRLF,;,EmailList
Let>SMTP_CCLIST=EmailList
SMTPSendMail>EmailList,%SMTPServer%,me,myname,Subject,Body,

You can also try SMTP_BCCLIST instead of SMTP_CCLIST. However, during my tests (Macro Scheduler 15.0.21) sending via Gmail I noticed this is CCing and not BCCing. Please let me know if you get similar results and I'll mention it to dev.

SMTPSendMail : To include CC or BCC email addresses set the SMTP_CCLIST and SMTP_BCCLIST variables. Separate multiple email address with semicolons.

Thank you!!!
For me everything ok with SMTP_BCCLIST, but I'm sending not via gmail.

[Dorian (MJT support)]

Aah, that's good to know. Many thanks.