Hi,

I have created a macro which sends out a query as a txt file but i want to be able to add a unique number to the name of the file for every time it is e-mail out.

Hope this makes sense??

Where will the unique number come from?

Wherever I need to?

Sorry, quite new to this.