Hello again
Well I've decided to be flash at work and try and draft a mail merge document to try and cut down some time - however I keep hitting a problem. I can get the file to merge but I can't set up my Excel sheet as a data source.....and this is where it gets strange.
When I open my new word document it asks for a data source as it can't find the excel file automatically. I go through the "new data source" wizard and find my file but it has no sheets I can link too. But all the other excel files in the same folder, well at least the older ones, give me a nice list of sheets to link to.
What am I doing wrong?....please help me so I can show my boss I'm more intelligent than him
Many thanks
Hillsy
Well I've decided to be flash at work and try and draft a mail merge document to try and cut down some time - however I keep hitting a problem. I can get the file to merge but I can't set up my Excel sheet as a data source.....and this is where it gets strange.
When I open my new word document it asks for a data source as it can't find the excel file automatically. I go through the "new data source" wizard and find my file but it has no sheets I can link too. But all the other excel files in the same folder, well at least the older ones, give me a nice list of sheets to link to.
What am I doing wrong?....please help me so I can show my boss I'm more intelligent than him
Many thanks
Hillsy