Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
37 Replies
marcus_sommer
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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.