Broadcast workbook file attachment names - How to change?
When we broadcast our workbooks, it currently sends out the email with a workbook excel attachment. The workbook displays the technical name of the workbook as the title of the workbook. (eg. WORKBOOK_4AL9FGLI9WKUKA0ENQ3UY56OA )
Is there anyway to alter the file name of the workbook so that is personalised for each recipient?
the problem this causes is that some recipients receive more than one workbook and that can cause issues if they try to open multiple workbooks with the same name.
Thanks in advance for any help received.