topic Re: Generate Personalized Email to a Email on a Line of a Report in DAX Commands and Tips

Generate Personalized Email to a Email on a Line of a Report

jamiers — Sun, 18 Apr 2021 15:04:00 GMT

Hi All,

I have a report that has merged fields from a bunch of different tables looking at forms that have been turned in. Basically I scan across the report line and see if a particular employee has turned in all of the forms for a specific project. Each form is from a different data set that I have merged into this one report.

I want to click on an envelope icon an generate an email message that states which of the forms are missing.

I am going to deal with the if/then statements later... right now I am working on just generating an email that by a click on an envelope will call the external desktop email program and insert text into a new email message. I have started with the following code that calls the external email program and generates info in the body section:

GENERATEEMAIL = "mailto:" & [Email] & "?subject=" & [Name] & " :- Forms Due&body=COMPANY%0D Location, State%0D %0D Dear " & [First Name] & ",%0D %0D Here are the remaining forms that you need to submit:%0D"

As I said, this works to call the external email program and generate the email message. What I want to do is change the arrow below to a envelope icon.

Is this possible?

Re: Generate Personalized Email to a Email on a Line of a Report

OwenAuger — Sun, 18 Apr 2021 22:01:51 GMT

Hi jamiers

Yes, you can change this to an envelope icon.

It appears you have already set the GENERATEEMAIL measure's data category to Web URL.

All that is left to do is:

On your table/matrix visual, go to the Format > Values > URL icon > On

You should then see icons like this in your table/matrix visual:

Regards,

Owen

Re: Generate Personalized Email to a Email on a Line of a Report

jamiers — Sun, 18 Apr 2021 22:13:45 GMT

So, I have that turned on, but you can see the results off to the left are not an envelope. Am I missing a step somewhere?

Would anything else

Re: Generate Personalized Email to a Email on a Line of a Report

OwenAuger — Sun, 18 Apr 2021 22:48:29 GMT

Hi again jamiers

The Values > URL Icon setting is correct.

However, the Conditional Formatting > Web URL option is not required, and in fact it should not be available if you have set the measure's Data Category to Web URL.

Can you select the GENERATEEMAIL measure and check that you have set Data Category to Web URL?

Regards,

Owen

Re: Generate Personalized Email to a Email on a Line of a Report

jamiers — Sun, 18 Apr 2021 23:01:47 GMT

Thank you. That did the trick. I have this on a column, but that it did the trick. Thanks for the solution!