Send text file create3d by TransferText

[Guest]

I use the transfertext to output the data the way my customer wants.

Is there a way I can create the text file and mail it to them as an
attachment in the same set of VBA code?

TIA,

Vanya

 

[Allen Browne]

See help on:
SendObject

You can specify the table or query to send.

 

[Guest]

Allen,

Thanks. I have to output my query (or table) in a text format with
comma delimiters. That is why I use the TransferText with the acExportDelim.
So if I use send object it will save my data as comma delimated text file?

Thanks

Vanya

 

[Allen Browne]

See help on SendObject.

You will see that one of the arguments is OutputFormat.

 

[Guest]

Allen,

Thanks again but it I must be missing something. When I do a send
object from my query or table the data in the attachment looks like
this...(shortened to the first 3 columns…)

---------------------------------------------------------------
| Service ID | Read Date | Bill Date
---------------------------------------------------------------
| 136 | | 05/01/2006
---------------------------------------------------------------

What I need to send is this…

"136",,"05/01/2006","30","8920","0",,,,"256.82"

I can get the above with the TransferText method/action but then how do I
send it? Maybe I have to add in Outlook VBA. Sigh…

Thanks,

Vanya

 

[Allen Browne]

Right: you are getting fixed-width (viewable) text, and you want CSV
(comma-separated values.)

Tony Toews has some other leads for emaling from Access in his Email FAQ at:
http://www.granite.ab.ca/access/email.htm