Solved

Start a Mail merge of Access 2000

Posted on 2001-06-05
7
192 Views
Last Modified: 2006-11-17
I would like to have an Access 2000 form
pass the data from a access query/table
to Ms Word 2000 where it would start a Mail Merge
for me. This to be automated so that a user
can just click on the Access form "Print Certificates"
and it will pass the table data or table reference, start the mail merge and go to the printer.
HOW ?
Thanks !!!
0
Comment
Question by:Whux
7 Comments
 
LVL 4

Accepted Solution

by:
nmilmine earned 75 total points
ID: 6158029
Hi Whux

This is some code I have used.  Paste it into a new module.  You can only use a table and not a query so will need to use the make table query to create a temp table if you need filtered results

Substitute Jewelz document and Renshaws database for your own

Function MergeItJewelz()
   
   Dim objWord As Word.Document
   Set objWord = GetObject("C:\Program Files\Database\Jewelz Merge.doc", "Word.Document")
   ' Make Word visible.
   objWord.Application.Visible = True
   ' Set the mail merge data source as database.
   objWord.MailMerge.OpenDataSource _
      Name:="C:\Program Files\Database\Renshaws GemTime.mdb", _
      LinkToSource:=True, _
      Connection:="TABLE JewelzClients", _
      SQLStatement:="SELECT * FROM [JewelzClients]"
   ' Execute the mail merge.
   objWord.MailMerge.Execute

End Function

HTH
Neil

0
 

Author Comment

by:Whux
ID: 6164238
Works !!!
Thanks !!
The only problem at this point is that
my macro in the Word doc
steps through it all and ends before the print
is done thius giving me a warning msg that the print
job is not done . Do you know how to get around that ?
0
 

Author Comment

by:Whux
ID: 6727052
old
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 49

Expert Comment

by:DanRollins
ID: 7086358
Hi Whux@idg,
You've requested to delete this question, but its status has remained as 'Pending Delete' because one or more comments have been added.  Normally, the only way to fully delete such a Question is to post a message to Community Support and ask for assistance.

EE is making a one-time database sweep to purge the Pending Delete Questions automatically.  During this sweep:

    Whux@idg -- To allow the deletion to proceed:  Do nothing.
    EXPERTS -- Please DON'T POST a comment except to contest this deletion.

In the future, please refer to http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#8 for instruction on deleting questions.

DanRollins -- EE database cleanup volunteer
0
 
LVL 4

Expert Comment

by:nmilmine
ID: 7090820
I thought I had given the required answer given Whux's comments

Neil
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7106176
You definitely did respond correctly to the initial request, sorry you had to wait so long.  Finalized.
Moondancer - EE Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

932 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

13 Experts available now in Live!

Get 1:1 Help Now