I am sorry that this has probably been asked a thousand times but I cannot find exactly what I am looking for and have spent about three days trying to work it out to some success but not a lot.

I have a datasource that at the moment it in an access database but it can be happily exported to excel if it is easier?

I have a mail merge template called 'merge'

The database I am performing the merge from is called 2011.accdb
and it has a singular table called 2011.

My aim is to perform a mail merge on the data from within this table or from an excel data source using the field called 'ClientAccountNumber'

And use 'ClientAccountNumber' as the data to save the individual PDF's as.

Please let me know if anything needs clarifying I cannot work it out and am desperately in need of a solution.

Many thanks in advance for anyone who can help push me in the right direction or provide a tutorial on how it is done!

Regards

Richard