Hello,
Due to the complexity/time it takes to run of a query, I had to break it up into smaller queries and run them individually. From this, I pasted it into 1 spreadsheet.
My boss now wants to do a kind of mail merge (not addresses etc, dates of courses etc) from the spreadsheet into a Word document. Problem is the people who are to run the word document aren't very tech savvy, and I've been told that they should only have to select the record they want to do the mail merge and press ok and it'll merge.
Is it feasible to link the spreadsheet to Access, create a down list of each record (i.e. cleintsname) and then proceed to mail merge into Word? It sounds very complicated to set up but, in my mind, for the user, it will be quick as their are no complex queries to run and it'll keep it simple for them.
I would greatly appreciate some feedback. We can't get a report to work as it crashes out due to the amount of queries needed so this is the next option.
thank you,
J
Due to the complexity/time it takes to run of a query, I had to break it up into smaller queries and run them individually. From this, I pasted it into 1 spreadsheet.
My boss now wants to do a kind of mail merge (not addresses etc, dates of courses etc) from the spreadsheet into a Word document. Problem is the people who are to run the word document aren't very tech savvy, and I've been told that they should only have to select the record they want to do the mail merge and press ok and it'll merge.
Is it feasible to link the spreadsheet to Access, create a down list of each record (i.e. cleintsname) and then proceed to mail merge into Word? It sounds very complicated to set up but, in my mind, for the user, it will be quick as their are no complex queries to run and it'll keep it simple for them.
I would greatly appreciate some feedback. We can't get a report to work as it crashes out due to the amount of queries needed so this is the next option.
thank you,
J
