Dynamically Change subject line of the report.

[Raghuvir]

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!

[Francis aka khayman]

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

[raj_aries81]

Try sending the email using Event Studio, I think it will dynamically change the subject line

[Raghuvir]

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

[Raghuvir]

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

[MDXpressor]

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.

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?

[Raghuvir]

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

[MDXpressor]

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

[Raghuvir]

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

[MDXpressor]

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.

[raj_aries81]

I assume you want to dynamically include the picture of the person based on his/her b'day.

Regards
Raj

[cielo]

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?