>>>>hh="d:\outmail\out"+TTOC(DATETIME())+".dbf"
>>>>hh=STRTRAN(hh," "+"")
>>>>hh=STRTRAN(hh,":"+"")
>>>>hh=STRTRAN(hh,"/"+"")
>>>>
>>>>
>>>>the value of hh is d:\outmail\out07012015084913.dbf
>>>>
>>>>SELECT outmail
>>>>
>>>>COPY TO &hh
>>>>
>>>>I get invalid path or filename - what am I doing wrong?
>>>>
>>>>d:\outmail dirctory exists exists as does the file outmail
>>>
>>>Do not use macro, use Name expression instead.
>>>Also make sure that "d:\outmail\ folder exists
>>>

>>>hh="d:\outmail\out"+TTOC(DATETIME())+".dbf"
>>>
>>>hh=CHRTRAN(hh," :/", "")
>>>
>>>SELECT outmail
>>>TRY
>>>   md ("d:\outmail\") && It is closed in quotes and brackets just in case there are spaces in the folder name
>>>CATCH
>>>ENDTRY
>>>
>>>COPY TO (hh) && Here
>>>

>>
>>I still get the error - d:\outmail exists
>
>change code
>to
>

>hh="d:\outmail\out"+TTOC(DATETIME())+".dbf"
>
>hh=CHRTRAN(hh," :/", "")
>
>SELECT outmail
>TRY
>   md ("d:\outmail\") && It is closed in quotes and brackets just in case there are spaces in the folder name
>CATCH
>ENDTRY
>
>_CLIPTEXT = hh
>
>COPY TO (hh) && Here
>

>
>Paste Clipboard content in the next message.
>
>What happens if you change
>

>COPY TO (hh) && Here
>

>to
>

>COPY TO d:\outmail\outxyz.dbf
>

>
>?
That copies fine