I have a Access Database, and I would like to create a word document
that
(preferable would filter)links to ACCESS table or query. I would like
to print the word document on the filtered record that I have selected
in Access.
for example if I have customer number (201) that I would like to merge
over to a Word document. The word document is a template that I would
like to use regularly.
Thanks so Much for anyone that can WALK me thru the process. Step by
step,
I have tried the Hyperlink option - but it doesn't see to be working
right.
Isn't there an easy way to create such a thing. In the past I
created all my templates in the FORM view and have printed from the
Forms. But
Some letters are easier generated in MS Word.
Thanks again! 3 3110
ok, i've been doing this very frequently in my job ...
perhaps u might find this useful
Step 1 : create your query with all the information that u'll need on that
merged letter
Step 2 : run the query and ensure the result is as u wanted.
Step 3 : while still looking at your query, select 'Tools' --> 'Office
Links' --> 'Merge it with MS Words'
Step 4 : MS Word will be activiated and prompts you to select a document to
merge to. Ignore this and opts for a new word document
Step 5 : you'll then be presented with a black document, ready for you to
edit.
Step 6 : edit your document, at the Toolbars portion of ms word (at the
top), right click and select the 'Mail Merge' toolbars.
Step 7 : you may try to play around with the mail merge toolbar, selecting
whatever u need to.
Hope the above helps.
______________________________________
Lawrence Lee
"di" <di******@charter.net> wrote in message
news:9b**************************@posting.google.c om...
I have a Access Database, and I would like to create a word document
that
(preferable would filter)links to ACCESS table or query. I would like
to print the word document on the filtered record that I have selected
in Access.
for example if I have customer number (201) that I would like to merge
over to a Word document. The word document is a template that I would
like to use regularly.
Thanks so Much for anyone that can WALK me thru the process. Step by
step,
I have tried the Hyperlink option - but it doesn't see to be working
right.
Isn't there an easy way to create such a thing. In the past I
created all my templates in the FORM view and have printed from the
Forms. But
Some letters are easier generated in MS Word.
Thanks again!
Thanks for both versions - I tried both of them and I know I will have
a need for both versions in the future.
Thanks you very Much!!
"Lawrence" <ga******@singnet.com.sg> wrote in message news:<c6**********@mawar.singnet.com.sg>... ok, i've been doing this very frequently in my job ... perhaps u might find this useful
Step 1 : create your query with all the information that u'll need on that merged letter Step 2 : run the query and ensure the result is as u wanted. Step 3 : while still looking at your query, select 'Tools' --> 'Office Links' --> 'Merge it with MS Words' Step 4 : MS Word will be activiated and prompts you to select a document to merge to. Ignore this and opts for a new word document Step 5 : you'll then be presented with a black document, ready for you to edit. Step 6 : edit your document, at the Toolbars portion of ms word (at the top), right click and select the 'Mail Merge' toolbars. Step 7 : you may try to play around with the mail merge toolbar, selecting whatever u need to.
Hope the above helps.
______________________________________ Lawrence Lee
"di" <di******@charter.net> wrote in message news:9b**************************@posting.google.c om... I have a Access Database, and I would like to create a word document that (preferable would filter)links to ACCESS table or query. I would like to print the word document on the filtered record that I have selected in Access. for example if I have customer number (201) that I would like to merge over to a Word document. The word document is a template that I would like to use regularly.
Thanks so Much for anyone that can WALK me thru the process. Step by step,
I have tried the Hyperlink option - but it doesn't see to be working right.
Isn't there an easy way to create such a thing. In the past I created all my templates in the FORM view and have printed from the Forms. But Some letters are easier generated in MS Word.
Thanks again! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: di |
last post by:
I have a Access Database, and I would like to create a word document
that
(preferable would filter)links to ACCESS table or query. I would like
to print the word document on the filtered record...
|
by: Sharon |
last post by:
Following up, I've found success at last with Aspose, combining both
Aspose.Word to create an xml file, and then and Aspose.Pdf to create the
pdf file.
This works out to be quite a considerable...
|
by: Michael Tkachev |
last post by:
Hi Everybody!
I have a problem. When I get a HTML of my page that I'm rendering. I need to
generate a word-document from a html. And than I have to send this
word-document to the users through...
|
by: Niyazi |
last post by:
Hi,
I created application that store the data in SQL SERVER that reside on
network. The client also use this application to access the resources
provided with application. But is the client want...
|
by: jmar |
last post by:
I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a...
|
by: jmar |
last post by:
I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...
I am updating a...
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is...
|
by: rlntemp-gns |
last post by:
Re: Access 2003/Word 2003
I have about 100 motivational documents that I am wanting to import
into a small database and put a front end on it that would allow the
user to select one, read it and...
|
by: babyangel43 |
last post by:
Hello, I have a query set up in Access. I run it monthly, changing
"date of test". I would like this query to be merged with a Word
document so that the cover letter is created in Word, the fields...
|
by: ncsthbell |
last post by:
I have a request to programatically create a .pdf file from within a current access application. The problem is that they want this one .pdf file to contain both an access report (created by the...
|
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...
|
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...
|
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...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |