G
GVR_Mike
It appears that there is only one OutputFormat to choose to send
export a table to Excel and send it via e-mail, acFormatXLS. This
seems to be sending the file as Excel 95 and is giving some of the
recipients problems. Is there a way to specify to send the file as
Excel 97 or 2003? Here is my code ("Daily Performance Statistics" is
the name of the table):
DoCmd.SendObject acSendTable, "Daily Performance Statistics",
acFormatXLS, "(e-mail address removed)", _
"(e-mail address removed)", , "Daily Numbers", "Auto-Generated", No
export a table to Excel and send it via e-mail, acFormatXLS. This
seems to be sending the file as Excel 95 and is giving some of the
recipients problems. Is there a way to specify to send the file as
Excel 97 or 2003? Here is my code ("Daily Performance Statistics" is
the name of the table):
DoCmd.SendObject acSendTable, "Daily Performance Statistics",
acFormatXLS, "(e-mail address removed)", _
"(e-mail address removed)", , "Daily Numbers", "Auto-Generated", No