>>>
>>>Success!
>>>
>>>As soon as I saw your previous message I went back and looked at the GETWORDCOUNT() and realised you hadn't specified the comma as the delimiter. Glad you worked it out.
>>>
>>>I had asked you to check what GETWORDCOUNT() was returning and you mentioned it was 2, not sure how you checked that :)
>>
>>
>>That was in the command window itself, and I had the comma in there. It didn't dawn on me until I went back through and checked for the 50th time that I had no comma in my actual code :)
>
>LOL, I had just gone back through the thread to see how that had happened.
One last thing if you don't mind, could you explain your m.msg code?
m.msg= m.msg + CHR(13) + CHR(10) + [Exported ]+m.bn+[T2.xls]
I'm not sure I see how it's grabbing all the relevant record numbers and what makes it repeat "Exported" for the number of records, I was trying to change it to have "Exported " print once, and then each record number separated by commas again.
I'm really starting to hate commas.
EDIT: Duh, it's still in the FOR loop. I have too much commented out code and keep missing that ENDFOR. I just added an additional m.msg = m.msg + under that ENDFOR and it works.