Mail Merge to Access 2003 - Microsoft Access / VBA

Jking482

I want to merge data to a Word doc from an Access query. The query
does exist and contains data, but the Word data source locator DOESN'T
SHOW THE QUERY AT ALL. What am I doing wrong?

Thanks.

John

Dec 23 '07 #1

Subscribe Post Reply

1906

mike1174

On Dec 23, 12:20*pm, Jking482 <jking...@cableone.netwrote:

I want to merge data to a Word doc from an Access query. *The query
does exist and contains data, but the Word data source locator DOESN'T
SHOW THE QUERY AT ALL. *What am I doing wrong?

Thanks.

John

You need to use word automation through the word object...and you can
use bookmarks from there as well...

Dec 26 '07 #2

Fred Zuckerman

<mi******@comcast.netwrote in message
news:33**********************************@f53g2000 hsg.googlegroups.com...
On Dec 23, 12:20 pm, Jking482 <jking...@cableone.netwrote:

I want to merge data to a Word doc from an Access query. The query
does exist and contains data, but the Word data source locator DOESN'T
SHOW THE QUERY AT ALL. What am I doing wrong?

Thanks.

John

You need to use word automation through the word object...and you can
use bookmarks from there as well...

If you change your "select" query to a "make table" query. Then you can
create a mail merge doc using the table.
Fred Zuckerman

Dec 27 '07 #3

Similar topics

Mail Merge (Word 2003 & SQL server)

by: antonovaCCCS | last post by:

In our old VB 6 application we utilize a mail merge feature of Word 97 with MS Access. A table in Access is populated from VB and a Word template is wired to that table. So all we do in the code is...

.NET Framework

word mail mergers from access

by: jwa6 | last post by:

We have recently went to access 2003 from access 97. And from word 97 to Word 2003. We have an Access application we use for ms word mail mergers to a 5160 mail label format. The data for the...

Microsoft Access / VBA

Extra Access Instance with Automated Mail Merge

by: Neil Ginsberg | last post by:

I have a strange situation using Access to automate a Word mail merge. Using Access 2000 and Word 2000, the code opens Word, opens the document in Word, sets a table in the calling Access...

Microsoft Access / VBA

Opening a mail merge document from Access 2000

by: Andy Davis | last post by:

I have set up a mail merge document in Word 2003 which gets its data from my Access 2000 database. I want to set up a button on a form that: 1. runs the query to provide the dat for the merge...

Microsoft Access / VBA

MS Access 2003 and Word 2003 Mail Merge Problem

by: pmhaupt2 | last post by:

I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and...

Microsoft Access / VBA

Access 2003 mail merge using DDE

by: Access | last post by:

Okay I know this is probably not the best way to be doing things but I have an ancient application that was working fine until a end user got a new machine. The Access database is performing a...

Microsoft Access / VBA

MS Access and Word Mail Merge

by: pnr | last post by:

I transferred my database to a new computer. I can open it in 2003 Access, but am keeping it in the 2000 version until I get it working correctly. I have dozens of Word documents where I use...

Microsoft Access / VBA

Automate Word Mail Merge - Conversion Issue

by: johnvon | last post by:

I have a mail merge that runs flawlessly in Access 2000. In 2003 I keep getting dialog boxes that I can't figure out how to supress. Several of them are telling me that Admin (me!) has the database...

Microsoft Access / VBA

Question on Mail Merge with Shell Command

by: ckirby | last post by:

I've inherited an application for creating mail merges from an Access 2003 ADP that needs an overhaul. To generate the mail merge , the app uses a shell command: result = Shell(str, vbHide) ...

Microsoft Access / VBA

Access 2003 to Word 2003 Mail Merge

by: Ron B | last post by:

Help!!! What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table. I want to...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++