Solved

Start a Mail merge of Access 2000

Posted on 2001-06-05
7
196 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Back Up Your Microsoft Windows Server®

Back up 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.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 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