Hi all,
i have a report which shoots mail to employees on their birthday.(bursting)
is it possible to add the name of the employee in the subject line of the email being sent ?
Thanks in advance!
if you can retrieve the employee name by somekind of macro function like ParamValue, then you can change the Source Type property of the Subject Text to "Report Expression" and edit the function.
if that does not work, put the Title in a singleton. associate the query of the singleton to the query where your employee name is. then change the "Source Type" property of the the subject text to "Data Item Value". Then use the value that contains the employee name
Try sending the email using Event Studio, I think it will dynamically change the subject line
Quote from: khayman on 18 Jun 2014 02:57:12 AM
if you can retrieve the employee name by somekind of macro function like ParamValue, then you can change the Source Type property of the Subject Text to "Report Expression" and edit the function.
if that does not work, put the Title in a singleton. associate the query of the singleton to the query where your employee name is. then change the "Source Type" property of the the subject text to "Data Item Value". Then use the value that contains the employee name
hi khayman,
Thanks for the response ,but i am looking to change the subject line of the email when i am scheduling the report.
Regards
Quote from: raj_aries81 on 19 Jun 2014 08:51:26 AM
Try sending the email using Event Studio, I think it will dynamically change the subject line
yah i did that and was able to dynamically change the subject line of the email using event studio.
the challenge i am facing here is i want to add an image to the mail body instead of the file going as an attachment.
has anyone done this is event studio ? please guide.
Regards
Quotethe challenge i am facing here is i want to add an image to the mail body instead of the file going as an attachment.
This raises all sorts of questions.
If you just want to add any old image to the email, Event Studio can do that, also, I think.
Is the image you want to send a screen print of the report output?
Why would you want to send an image rather than the report itself, there must be a problem you're facing?
Hi MDXpressor,
the image that i want to attach here is a birthday card. i dont want to send it as an attachment as the recipient will have to open the attachment. i want the card to be displayed in the body when the user recieves the mail.
would this be possible in even studio mail body ?
Regards
Hmmm seems like a reasonable request... I think you can add HTML items to email output. Your HTML item could be a report expression which dynamically calls the image you want to embed...
Just grasping at straws at this point...
thanks for the tip MDXpressor
do u mean i need to write a HTML in the email body in event studio ? have u encountered such situation before, if yes please do guide me with the same.
Regards
That's what I'm suggesting, and no I have not encountered it before. Feel free to dive in ahead of me, but I will try some things in the next couple of days. Bump the thread if you don't see anything shortly.
I assume you want to dynamically include the picture of the person based on his/her b'day.
Regards
Raj
Quote from: Raghuvir on 20 Jun 2014 02:50:16 AM
yah i did that and was able to dynamically change the subject line of the email using event studio.
the challenge i am facing here is i want to add an image to the mail body instead of the file going as an attachment.
has anyone done this is event studio ? please guide.
Regards
Could you please advise me how we can change the subject line using Event studio? I am aware that we can create a data item and pull that in to subject line however in the mail TO/CC we need to mention email ids correct?