topic Re: Send multiple recipients?! in QlikView

Send multiple recipients?!

Wed, 25 Nov 2020 16:16:04 GMT

In macro , I not use nprinting

how to sending report to multiple recipients??

(not objEmail.To = "recipient1@gmail.com; recipient2@gmail.com; recipient3@gmail.com")

I need to send automatic from table, or xlsx file?

Re: Send multiple recipients?!

agomes1971 — Fri, 02 Sep 2016 15:49:47 GMT

Hi,

see this

Sending Emails using Macro

using macro to send email with attachments

Automated Excel Export and Email Macro

HTH

André Gomes

Re: Send multiple recipients?!

Sun, 04 Sep 2016 14:39:03 GMT

Tnx agomes1971 , but how I seen, All links show how to send mail to one recipients, I need how to send mail to more recipients(30 or 50),
Because of this, I need a way to import recipients from table, or XLSX file?

Re: Send multiple recipients?!

saimahasan — Sun, 04 Sep 2016 15:30:31 GMT

you can store the email ids in an excel file and use that file.

Fetch the field in the variable in macro by using

set Email = ActiveDocument.Fields("EmailID").GetPossibleValues

val = Email.Count

for i=0 to val-1

TO_ADDR = Email(i).text & ";"

now use this in your objEmail.To as

objEmail.To = "" & TO_ADDR & ""

Re: Send multiple recipients?!

Sun, 04 Sep 2016 17:08:17 GMT

tnx a lot saimahasan ,
that it looks like as if it could be that what I was looking for, but I'm relatively new to QV, can you more verbose example, to write. Please.

This objEmail.To = "" & TO_ADDR & "" copy the part where we define who is sent, the message subject, body, etc., but, I have a dilemma

set Email = ActiveDocument.Fields("EmailID").GetPossibleValues

val = Email.Count

for i=0 to val-1

TO_ADDR = Email(i).text & ";"

What is "EMAILID"?

and

"Fetch the field and in the macro variable by using" does that mean that I create a variable, for example,

vEmails = "D:\emails.xlsx" //with list email adress recepients in to emails.xlsx file

and what?

Re: Send multiple recipients?!

saimahasan — Mon, 05 Sep 2016 09:20:37 GMT

Please refer attached qvw.

Re: Send multiple recipients?!

Tue, 06 Sep 2016 08:07:21 GMT

Tnx a lot saimahasan. Yes, that is what I need.
Works perfect.