Hi Experts,
I have a DB containing many records of customers' info. How can I pull these
data to the MS Word mail merge letters containing the header (name, address,
etc) and contents (description 1, 2, 3,...) page by page per record? Thanks
a lot.
Andrew 4 1375
Is ASP really the right technology to use for this? Since Word has the
functionality all built into it, why not use Word to do it? Word is
programmable, if you'd like to automate it that way.
Ray at work
"Andrew" <du******@yahoo.com> wrote in message
news:jf********************@rogers.com... Hi Experts,
I have a DB containing many records of customers' info. How can I pull these data to the MS Word mail merge letters containing the header (name, address, etc) and contents (description 1, 2, 3,...) page by page per record? Thanks a lot.
Andrew
Because I want the users to specify the records output to the Word template,
and click somewhere(a button) to be prompted download or display Word format
on webpage.
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:OT**************@TK2MSFTNGP15.phx.gbl... Is ASP really the right technology to use for this? Since Word has the functionality all built into it, why not use Word to do it? Word is programmable, if you'd like to automate it that way.
Ray at work
"Andrew" <du******@yahoo.com> wrote in message news:jf********************@rogers.com... Hi Experts,
I have a DB containing many records of customers' info. How can I pull these data to the MS Word mail merge letters containing the header (name, address, etc) and contents (description 1, 2, 3,...) page by page per record? Thanks a lot.
Andrew
"Andrew" <du******@yahoo.com> wrote in message
news:Q-********************@rogers.com... Because I want the users to specify the records output to the Word
template, and click somewhere(a button) to be prompted download or display Word
format on webpage.
Does it have to be Word? Or just nice looking? My personal preference is to
let Word be a really nice desktop app, and use other things for client /
server and web apps. If it were me, I would use Crystal or Appligent's
StampPDF.
In theory, I can imaging you could create Word docs using automation,
perhaps within VB dll, on the server then push them down to the client or
provide a link to the completed doc. But I have no experience, so that is
the limit of what I will say. Sorry.
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in message news:OT**************@TK2MSFTNGP15.phx.gbl... Is ASP really the right technology to use for this? Since Word has the functionality all built into it, why not use Word to do it? Word is programmable, if you'd like to automate it that way.
Ray at work
"Andrew" <du******@yahoo.com> wrote in message news:jf********************@rogers.com... Hi Experts,
I have a DB containing many records of customers' info. How can I pull these data to the MS Word mail merge letters containing the header (name, address, etc) and contents (description 1, 2, 3,...) page by page per record? Thanks a lot.
Andrew
Yes, you are on the right track. I was thinking about using mail merge
feature of Word.
"Stephanie Stowe" <No****@IWishICould.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... "Andrew" <du******@yahoo.com> wrote in message news:Q-********************@rogers.com... Because I want the users to specify the records output to the Word template, and click somewhere(a button) to be prompted download or display Word format on webpage.
Does it have to be Word? Or just nice looking? My personal preference is to let Word be a really nice desktop app, and use other things for client / server and web apps. If it were me, I would use Crystal or Appligent's StampPDF.
In theory, I can imaging you could create Word docs using automation, perhaps within VB dll, on the server then push them down to the client or provide a link to the completed doc. But I have no experience, so that is the limit of what I will say. Sorry.
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in message news:OT**************@TK2MSFTNGP15.phx.gbl... > Is ASP really the right technology to use for this? Since Word has the > functionality all built into it, why not use Word to do it? Word is > programmable, if you'd like to automate it that way. > > Ray at work > > "Andrew" <du******@yahoo.com> wrote in message > news:jf********************@rogers.com... > > Hi Experts, > > > > I have a DB containing many records of customers' info. How can I > > pull > > these > > data to the MS Word mail merge letters containing the header (name, > > address, > > etc) and contents (description 1, 2, 3,...) page by page per record? > > Thanks > > a lot. > > > > Andrew > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Shawn Mehaffie |
last post by:
I have the following class that I've wirtten to take a Dataset and
automatically export it to either XML, ASCII or Tab delimited file. The
reason I wrote it they way I did was that I don't want to...
|
by: Franck |
last post by:
Does anyone know how I can export my data from a database
and put it into a predefined Word template document.
I'm using C#.NET and have datasets with all the data I
need. I would like to add...
|
by: Do Park via SQLMonster.com |
last post by:
Hello all,
I don?t often export data from a table. I am wondering how you export data
from a table. I?d like to know how you export in real world.
Do you export data from a table to a flat...
|
by: maricel |
last post by:
Is there anybody out there who have any idea why EXPORT is relatively slower
when putting the output file on a network drive - map drive from onother PC
compared to putting it on my local PC drive...
|
by: Regnab |
last post by:
I've got my code working so that it'll count the number of columns in
the table and move across (eg Range A-P and then range Q-W). Problem is
when I get to the end of the single letters and get...
|
by: chaitu |
last post by:
Hi,
Can anybody tell me what the error code for Export is. Like i get the
message
SQL3104N The Export utility is beginning to export data to file...
|
by: smaczylo |
last post by:
Hello, I've recently been asked to work with Microsoft Access, and
while I feel quite comfortable with Excel, I'm at a complete loss with
databases. If someone could help me with this issue I'm...
|
by: steve |
last post by:
I'm fairly new to Access and trying to figure out how to execute a
particulary query. For example I have 2 tables named TEST and TEST1.
TEST has a column labeled LETTERS with values A - Z. I want...
|
by: prosserl |
last post by:
Hi
I have an application which produces Access Report Letters but my end user wants to be able to edit these reports in word and wants them to open up directly in word. My reports contain sub...
|
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: 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...
|
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...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |