Reporting - export to MSWord doc. - Microsoft Access / VBA

Robert

Hello,

I would like to take the data from a query and export it to an MSWord
doc or dot that can display the fields. (Auto fill)

I have been trying to figure out how to do this, but have not found
the appropriate documentation as to how to set this up.

Can someone help me out here.

Regards,

Robert

Nov 12 '05 #1

Subscribe Post Reply

1862

Keith Wilby

Rp*****@gmx.de (Robert) wrote:

Hello,

I would like to take the data from a query and export it to an MSWord
doc or dot that can display the fields. (Auto fill)

I have been trying to figure out how to do this, but have not found
the appropriate documentation as to how to set this up.

Can someone help me out here.

Regards,

Robert

Hi Robert,

The process to use is "Mail Merge". Search the help on either 'mail' or
'merge'.

HTH - Keith.
www.keithwilby.org.uk

Nov 12 '05 #2

Pieter Linden

Rp*****@gmx.de (Robert) wrote in message news:<b6**************************@posting.google. com>...

Hello,

I would like to take the data from a query and export it to an MSWord
doc or dot that can display the fields. (Auto fill)

I have been trying to figure out how to do this, but have not found
the appropriate documentation as to how to set this up.

Can someone help me out here.

Regards,

Robert

Open a recordset based on the query, open Word through automation, and
then pass the recordset to Word and build the table there. Covered in
the Developer Handbook in the Automation chapter.

Nov 12 '05 #3

Albert D. Kallal

I have a working download that does exaclity this.

Grab it, and give it a try. Also read the info on how it works.

Check out my super easy word merge at::

http://www.attcanada.net/~kallal.msn.../msaccess.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #4

Pieter Linden

"Albert D. Kallal" <pl********************@msn.com> wrote in message news:<XbAvb.452994$pl3.352500@pd7tw3no>...

I have a working download that does exaclity this.

Grab it, and give it a try. Also read the info on how it works.

Check out my super easy word merge at::

http://www.attcanada.net/~kallal.msn.../msaccess.html

Albert,
I guess I was thinking that if you want to do a complex mail merge
(1-M) data, then you'd have to use the stuff from ADH. Otherwise,
yours is easier...

Nov 12 '05 #5

Similar topics

Suggest a reporting tool?

by: David | last post by:

Hi all, I am hoping someone can suggest a reporting tool that I can use with my program. Currently, I am using Crystal Reports. I use the reports strictly as a container that I dump data into. It...

Visual Basic 4 / 5 / 6

export to msword - html

by: Tom Gao | last post by:

hi guys I'm trying to export an aspx page to msword. ############# I know you can do Response.Clear(); Response.ContentType="application/msword";

.NET Framework

When I used "application/vnd.ms-excel" to export table's content to Excel file. It would be showed between "Confused" words and normally words randomly.How can i sloved it?

by: Benny Ng | last post by:

Hi,All, Export Method: ------------------------------------------------------------------------- strFileNameExport = "Results" Response.Clear() Response.Buffer = True...

C# / C Sharp

3rd Party Web Reporting

by: TRobran | last post by:

Would anyone have a good recommendation for a Web Reporting component that could be used within a shared environment and can create PDF's? Thanks.

ASP.NET

Unable to export Crystal report containing subreports

by: Henry | last post by:

I have written an ASP/VB.Net application via VS 2003 (Crystal V9) that uses MS Access 2000 as its database. I can export reports that have no linked sub reports for printing. However, I'm unable...

Visual Basic .NET

Export Image Data Types to Local PC from SQL Database

by: manmit.walia | last post by:

Hello All, I am stuck on a task that I need to complete. What I have is a SQL 2005 DB running with a Table called Docs. The table structure consists of the following: Table Structure for Docs...

Microsoft SQL Server

Export Excel Question

by: Cloud | last post by:

Hi all, I have a parent page(parent.aspx) which will open different new windows depending on the user input. for example, the new windows are opened using the following code :...

ASP.NET

Custom reporting engine.

by: Ibrahim. | last post by:

Hello, I want to build a custom reporting engine in .NET. Wht are the consideration and I need to provide the user design facilty at run time. Thanks,

C# / C Sharp

export .net class to docx

by: nightscorpion | last post by:

Hello Everyone , im supposed to create a Customer with labels (name,add,Telnr...)and textboxes(thomas ,karsplatz,23423423423) in a windows form. i store all these data in a class...

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

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

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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++