Recent content by MarathonMan

Thanks FoFa, I wasn't expecting a reply from Texas, I would love to have a go at being a cowboy for a day, let me know if you fancy an exchange for a visit to Avebury and stonhenge! anyway I thought your suggestion was a good one, however I have version (10.2627.6817) SP3 and my macro drop...

Using Access 2002 on XP Pro. Query is based on 1 table and only returns the first column which is a text field 6 characters long. If I run the query manually and copy paste into excel I have no problems. 16938 rows, excel file size 620KB when I put the query in a macro and select Sendobject...