SendObject and acFormatTXT - what a mess!

[Atomic Shrimp]

I would like to be able to attach the results of a query as a text file attachment on an email.

It works, except that instead of the comma-separated file that i would have liked, the text file is an absolute mess, like this:

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -----------
|        Scan        |       Count       |                  Description                   |   Entered Text    |        Loc        |       Date        |       Seq1        |       Seq2        |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -----------
| 9781876050733      |                 1 | CAIRN TERRIER THE NEW                          |                   | (Unknown)         | 16/07/01 18:02:26 |                 1 |                 1 |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -----------

So, short of exporting the results to a file on disk then attaching to an mail object in code (fiddly) , is there any way to get SendObject (A97) to send a .csv file?

Thanks

Mike

 

[Talismanic]

Mike I am assuming that you seen this thread: Topic: E-mailing with Export Specs

I know that is about doing exactly what you want to avoid but I am not sure how else you would do it.

The last post in this thread from The Doc Man may be of some interest to you:
Topic: Can you export a report to word97?

Unless I missiing something obvious I don't see how you are going to do it with CSV because of the difference in field sizes are based on the strings inside them. It doesn't look like the SendObject supports Fixed Width either.

 

[Atomic Shrimp]

Thanks for that, it does look like I'll have to do it that way, and thanks for the example (in the other thread).