Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Macro script


Hi,

Can anyone please have a look on attached and when I am clicking ok the macro it is hightlighting

  Email=v.GetContent.String and showing

Object Required=v

Please can anyone let me know is there any error in macro.

37 Replies
marcus_sommer

License-information: press button help - about qv. But I think this the reason is the security settings within the macro-editor - it must be set on access to extern files (on the left side).

- Marcus

Not applicable
Author

It's showing excel 2010 when I am clikcking excel icon. is that you mean?

marcus_sommer

No sorry, I meant the license from qv - but cause are security settings, first in macro-editor from qv.

- Marcus

Not applicable
Author

ok that means if I run macro in licenced qv server will it work?

MayilVahanan

Hi

Did you set

Requested Module Security -> System Access

Current Local Security -> Allow System Access?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks  very much it's working but just showing below when I am executing

There must be at least one name or contact group in the To, Cc, or Bcc box.

please let me know is it possible to solve this one

marcus_sommer

myMessage.To = Email - the variable must be a valid mail, perhaps it is empty.

- Marcus

Not applicable
Author

Thanks and it is showing at

mymessage.send

please any help.

marcus_sommer

For me it worked - but there is an addional security message from outlook like this:

- Marcus

Not applicable
Author

for me it's not any help please.