Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Start a Mail merge of Access 2000

Posted on 2001-06-05
7
Medium Priority
?
204 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 300 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

715 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