Advertisement

06.03.2008 at 11:57AM PDT, ID: 23454250
[x]
Attachment Details

Which is better (Safer)?: MS Word mail merge with Excel or with Access query as the data source?

Asked by twintai in Microsoft Access Database, Databases Miscellaneous, Microsoft Word

Tags: Microsoft, Office, 2000, Networked environment

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
[+][-]06.03.2008 at 12:07PM PDT, ID: 21703494

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 12:10PM PDT, ID: 21703522

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 12:59PM PDT, ID: 21703967

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 09:12PM PDT, ID: 21706896

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Databases Miscellaneous, Microsoft Word
Tags: Microsoft, Office, 2000, Networked environment
Sign Up Now!
Solution Provided By: mark_wills
Participating Experts: 2
Solution Grade: B
 
 
[+][-]06.04.2008 at 10:33AM PDT, ID: 21712214

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.04.2008 at 10:47AM PDT, ID: 21712329

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.04.2008 at 10:58AM PDT, ID: 21712403

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628