I was using DoCmd RunSavedImportExport in VBA to export query result to .xlsx file.
Data included email addresses with hyperlink property in table.
When exported to excel file, email addresses were with hyperlink format in excel file also and there was no problem.
Example: name@companyname.com
Recently I upgraded to Office Pro 2016 and also started using DoCmd.TransferSpreadSheet in VBA to export the same query result in table form to .xlsx file.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, OpenExcelName, FilePathSet & OpenExcelName & ".xlsx"
Now the email data in excel file is not with hyperlink property but shows like (example):
name@companyname.com#mailto:name@companyname.com#
Excel file is used ultimately to send mailshots enbloc to all the email addresses in the excel file and that application is not working now.
Unable to figure out why this is happening and how to correct this (get proper hyperlink format in excel as before).
Look forward to help.