I should rephrase the question. I know that MS Word to Excel will have little to no problems. However, I get the sense that MS Word to MS Access is more likely to result in problems and possibly corrupt the database. So, does anyone have any insight into this?
A LITTLE INSIGHT: At my company, we do a lot of MS Word mail merges. Most, if not all, employees use Excel as the data source for their mail merges. However, we have one employee that uses MS Access query as the data source. While this seems to be fine and allowed (technically speaking), it seems that every database that this employee works with is always having issues of some sort and sometimes getting corrupted. I'm pressed to believe the employee's mail merge method (MS Word to MS Access Query) is causing some of the problems. Perhaps the mail merge is causing some friction via the Jet Engine. It seems that I always have to fix things in the database that works fine but some how go crazy. Recently, an update query in one of the databases stopped working and is now generating syntax error?
Are there any views, cautions, opinions on MS Word to MS Access mail merge?
Start Free Trial