Email A pipe delimited file

[TomTiddle]

Hi I 'm just starting to find my way around Access,
I need to email a pipe delimited file from Access I have managed to create the file and export to a directory but I wanted to automate the send anyone help?
Thanks N

 

[hymn]

Wecome to tek-tips
your best bet would be to do a search on email in the keyword search above or look in the FAQs you will find that their are many threads covering what you require

Hope this helps
Hymn

 

[TomTiddle]

Hi
thanks for the reply I can't see anything in FAQ that gives me an answer maybe I put the question badly.
I have created a table via a query and automated this to run on open I now want to auto mate the send via email but need the format to be pipe delimited hope this make more sense???

 

[LittleSmudge]

Okay - so maybe I'm being thick here - but I've not come across 'Pipe' delimiting.

What do you mean by that ?




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[hymn]

LittleSmudge
It is how the text is spaced i personaly use a comma but pipe is "|" shift and \

Hope this helps
Hymn

 

[hymn]

TomTiddle
Afew threads to look at
thread333-743408
thread705-550913
thread181-336165
thread705-499185

Hope this helps
Hymn

 

[LittleSmudge]

Thanks hymn.

So its a CSV file using "|" instead of the 'C' ?


That simple.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.