G
Guest
HI,
I use a transfer spreeadsheet for exporting a query to excel
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_queries",
"N:\a_c_attach.xls", True
I export memo fields, with a lot of text. I use that exported file as
attachement in email. The only problem is that the "wrap text" format is not
applied in Excel, and as some fields contains a lot of text, it's not
readable.
How could I apply automatically that format in Excel ? Is it possible to
do it in the VB script used for exporting the query and lauch emails ?
Rds
MArco
I use a transfer spreeadsheet for exporting a query to excel
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_queries",
"N:\a_c_attach.xls", True
I export memo fields, with a lot of text. I use that exported file as
attachement in email. The only problem is that the "wrap text" format is not
applied in Excel, and as some fields contains a lot of text, it's not
readable.
How could I apply automatically that format in Excel ? Is it possible to
do it in the VB script used for exporting the query and lauch emails ?
Rds
MArco