Query outputed to an Email in Excel Format - loses parts of fields

[Guest]

I am outputing a query to Email (Outlook 2003) as an Excel attachment (code
below) and one of the fields in the query is a memo field with can have upto
1000 characters in it, but my Excel attachment cuts of some of the field,
looks to me that it is keeping the first 255 characters ?

I need the recipient to work on the file so would like to keep it in an
Excel format.

Dim stDocName As String
stDocName = "Q_Excel_Spreadsheet"
DoCmd.SendObject acSendQuery, stDocName, acFormatXLS

thanks

Scott

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This is a common complaint. Search Google Groups for a solution. Here
are some discussions of your problem:

http://tinyurl.com/nzpgu
http://tinyurl.com/om83n
http://tinyurl.com/pv68a
http://tinyurl.com/zkzdb

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRAopAYechKqOuFEgEQIXzgCfZdvtBEIrbAJF28cuE9y2+vjvKAIAn129
m3Ikc5AKd5dtCoYX4yF5ua7o
=Ndr0
-----END PGP SIGNATURE-----

 

[Guest]

Thanks,

I think I will making the query a make table query then making a temporary
table and outputting the table to email as an excel file.

cheers.

 

[Guest]

That did not work either ?????

I now know the problem to be that the standard export format from Access
2003 is Excel 95 which does not support over 255 characters.

Does anyone know how to change this from Excel 95 ?

I have tried the Transfer.Spreadsheet command but this doesn't let me
automatically add the output file as a Outlook attachment unless someone know
a way ?

thanks

Scott