Auto Mail merge ability??

Thanks Sandra J

We have done a bit more investigation into methods and the best found so far would be to save the output of a report to a specific location, then a coded VBS script (for example) runs through the process of opening, merging and saving the merged documents / or print them. This program can then be applied to a scheduled job that runs at some point after the reports have been generated each week (for example).

This is a possibility we may look into a little more and it appears to be a sound solution??

Regards

Chris

Hi Chris

Here are a couple of options.

You are not able to schedule a Mail Merge itself but you can schedule the output of the data to be used in the Merge.

I’m not an MS Apps guru, but I’m wondering if it’s possible to force Word to open and run through the merge process using the Excel data saved by Tessitura  scheduled report process?

If you do manage to get Word to do this please let us all know!

Cheers

Sandra

Hia

I am wondering if anyone is able to advise if there is an auto-mail merge ability within Tessitura at all?

We are trying to streamline a few of our manual processes and the ability to be able to schedule a report and mail merge the results to either a bunch of saved merged word documents or directly to the printer would be brilliant?

I have a suspicion that if it is possible at all, it is going to be something more to do with the Microsoft apps side – but am wondering if anybody has this kind of thing setup and running anywhere else?

Regards

Chris

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Thanks Sandra J

We have done a bit more investigation into methods and the best found so far would be to save the output of a report to a specific location, then a coded VBS script (for example) runs through the process of opening, merging and saving the merged documents / or print them. This program can then be applied to a scheduled job that runs at some point after the reports have been generated each week (for example).

This is a possibility we may look into a little more and it appears to be a sound solution??

Regards

Chris

Hi Chris

Here are a couple of options.

You are not able to schedule a Mail Merge itself but you can schedule the output of the data to be used in the Merge.

I’m not an MS Apps guru, but I’m wondering if it’s possible to force Word to open and run through the merge process using the Excel data saved by Tessitura  scheduled report process?

If you do manage to get Word to do this please let us all know!

Cheers

Sandra

Hia

I am wondering if anyone is able to advise if there is an auto-mail merge ability within Tessitura at all?

We are trying to streamline a few of our manual processes and the ability to be able to schedule a report and mail merge the results to either a bunch of saved merged word documents or directly to the printer would be brilliant?

I have a suspicion that if it is possible at all, it is going to be something more to do with the Microsoft apps side – but am wondering if anybody has this kind of thing setup and running anywhere else?

Regards

Chris

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!