In a user macro - how set a field value to the result from another macro

[Ralph Fisher (DHL Supply Chain)]

I have one macro which is calling a sql macro producing a list of email addresses. In another macro I want to call this and have the value placed into a field, not shown on a screen.

Behind this is the sql query add on for Confluence.

Attempting to do something along this lines of:

#set ($emaillist = $action.getHelper().renderConfluenceMacro("{mymacroname:PARM1=$paramP1}"))

The value of emaillist is always blank, the macro runs but shows the information on the page.

Any suggestions?