Solved

Access database - mail merge issue

Posted on 2013-01-23
3
310 Views
Last Modified: 2013-01-31
Hello,

We have a customer database on Access. It has a function when the user clicks a button mail merge it enters certain predefined information in Word. It is working Ok on Windows XP 32bit with 32bit Office 2010. Now we migrated to Windows 7 64bit, and the same Office 32bits. The database is working except this mail merge function.

Can you please advise ?
0
Comment
Question by:goliveuk
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 38810428
ARe you using code in ACcess to set up the Word document as a mail-merge document, or have you created the mail-merge document in Word and all Access does is just open it?
0
 

Author Comment

by:goliveuk
ID: 38810519
Hello peter57r,

We start supporting this customer a few months ago, and the database was there. According to the experience on the old XP computer where it is working, it is using a code in Access and it is just showing up in Word.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 38813427
Sorry I can't work out what you are telling me.

If the mail-merge is built in code in Access then you will have to change the code that creates the connection
- see here for some examples
http://support.microsoft.com/kb/285332

If the Mail-merge has been built into the Word document then you will have to open the template and re-set the data source.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now