Report that Generates mailto: based on Attribute or Constituency

Hi Dara

When you setup the Word Template for a mail merge this is when you set this up as an email mail merge. 

When you do a merge from Tessitura select in the Merge To drop down “Electronic Mail” and click on the setup to select the email address field and subject line.  You will be shown an error message saying that word is trying to access addresses in outlook but you can get some software to suppress this!  If not just select allow for 10 minutes in the drop down menu.

Hope this helps.

Thansk

Hi Nick, Ben,

Thanks for the feedback on this.

Sorry about the delay getting back to you, Not had a chance to look at this again until now!

Nick,

I’ve tried the using the File > Merge from the results of the “Execute and Output Set” report. When I click merge if offers me to merge to a word doc. Can I do something like create template message file that will automatically open outlook when they merge to that?

I know I could save the list to Word or Excel and then use this list in Outlook to merge to a mail but that’s a lot of clicks for the user.

Ben,

Yes, I am fine with getting the data. Its quickly putting the list of email addresses into an email that’s the issue for me.

We use TMS for large mailings, but I find this too time consuming to use this for smaller groups of email.

The report I’m looking at creating would be similar to the Output Set, showing a list of emails, e.g. email1@company1.com, email2@company2.com, email3@company3.com, and at the bottom of the report have a hyperlink as follows: mailto:email1@company1.com;email2@company2.com;email3@company3.com

This would allow the user to generate the mail with one click. Only problem is I can’t seem to create a hyperlink in Infomaker so it will have to be a SSRS report.

Do you think this idea seems feasible?

I don’t think there is any other way to generate the email with just a few clicks.

Thanks,

Dara

HI Dara,

There are two parts in this topic.

1, get an email list.

2, create an email and send them to the listed email address.

For part 1,

it is about database.

so just run some kind of stored procedures to create a list.

no one can really help you to create such list.

part2,

I don't think use AP_SEND_SMTP_EMAIL  or

sp_send_smtp_mail will be a good idea.

that's not professional emails.

so what should we do?

TMS, somebody maybe think about this.

It is a good choice.

Or you can try something else.

google "group email software".

here you go, there are a lot of free softwares you can use to send out group emails.

here is an exmaple:

http://www.automsw.com/features.html

have fun.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL

Hi Dara

When you setup the Word Template for a mail merge this is when you set this up as an email mail merge. 

When you do a merge from Tessitura select in the Merge To drop down “Electronic Mail” and click on the setup to select the email address field and subject line.  You will be shown an error message saying that word is trying to access addresses in outlook but you can get some software to suppress this!  If not just select allow for 10 minutes in the drop down menu.

Hope this helps.

Thansk

Hi Nick, Ben,

Thanks for the feedback on this.

Sorry about the delay getting back to you, Not had a chance to look at this again until now!

Nick,

I’ve tried the using the File > Merge from the results of the “Execute and Output Set” report. When I click merge if offers me to merge to a word doc. Can I do something like create template message file that will automatically open outlook when they merge to that?

I know I could save the list to Word or Excel and then use this list in Outlook to merge to a mail but that’s a lot of clicks for the user.

Ben,

Yes, I am fine with getting the data. Its quickly putting the list of email addresses into an email that’s the issue for me.

We use TMS for large mailings, but I find this too time consuming to use this for smaller groups of email.

The report I’m looking at creating would be similar to the Output Set, showing a list of emails, e.g. email1@company1.com, email2@company2.com, email3@company3.com, and at the bottom of the report have a hyperlink as follows: mailto:email1@company1.com;email2@company2.com;email3@company3.com

This would allow the user to generate the mail with one click. Only problem is I can’t seem to create a hyperlink in Infomaker so it will have to be a SSRS report.

Do you think this idea seems feasible?

I don’t think there is any other way to generate the email with just a few clicks.

Thanks,

Dara

HI Dara,

There are two parts in this topic.

1, get an email list.

2, create an email and send them to the listed email address.

For part 1,

it is about database.

so just run some kind of stored procedures to create a list.

no one can really help you to create such list.

part2,

I don't think use AP_SEND_SMTP_EMAIL  or

sp_send_smtp_mail will be a good idea.

that's not professional emails.

so what should we do?

TMS, somebody maybe think about this.

It is a good choice.

Or you can try something else.

google "group email software".

here you go, there are a lot of free softwares you can use to send out group emails.

here is an exmaple:

http://www.automsw.com/features.html

have fun.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL