How to generate email by pressing a button to the recipient list generated from list of users?

Question

Hey fellow Atlassian users,

I would like to create a custom made button on my confluence page that, when pressed, will automatically compose an email with the following parameters.

To: %Communication_plan_users%
Subject: %Page_Title% + some free text
Body: Some free text + %link_to_the_confluence_page% + some free text

Where...

* %Communication_plan_users% variable contains the email addresses of list of conflucence users listed in the cells in the 1st column of a Table element under Heading4 "Communication Plan". The list doesn't contain the 1st cell (Heading row) of the Table. There can be one or more user names within one cell of the Table. See: Example below.
* %link_to_the_confluence_page% variable contains the link to the actual page, e.g. https://confluence.company.com/pages/viewpage.action?pageId=123456789
* %Page_Title% variable contains the title text of the actual confluence page.

Any idea for this automation?

Example:

Tomislav Tobijas · Answer

Hi @Akos Horvath ,

This will probably be a tricky one, and that's mostly because of those users you want to 'extract' and to whom you want to send the email. I've tested something similar for Page Properties macro so I would recommend checking that first > link.
*basically, you'd need to play with page body content parsing and that could be tricky. Although if you only use mentions within this initial table, it will be easier to achieve

Anyway, as for actual additional entry/info, best bet would be smart buttons/manual trigger. But, you could only add a prompt where the user would input that additional information, such as *some free text* you mention and then combine the inputs and page content and send an email via Send email action.

You would need to play around with it and, in the end, you might not get 100% result you're looking for, but something similar can be done as described in the text above.

Hope this helps.

Cheers,
Tobi