Embedding a word document in a database

Embedding a word document in a database

Post by EJ » Fri, 10 Jun 2005 02:55:32


I wonder if someone can help me

My job is writing proposal for a mechanical contractor. I have an
Approach data base for all the contact and location information, which
I call "Proposal header". I also have a word processor application
-Word pro- for the proposal body, that includes enhancements like
bullets , underling, numbering, etc. Which I call the "Proposal body".

Right now I have a blank memo field in the center of my proposal
header, I first print out the proposal header form, then I run the same
paper through the printer again to print the proposal body into the
blank space.

I am trying to eliminate the double printing

If I just cut and paste the proposal body into the memo field, I lose
the enhancements. I tried embedding a "picture plus" field in place of
the memo field, then inserting the Word pro document as an object. But
it comes out as a Graphic Meta file and the fonts are blurry.

I there a way to embed a document on top of another with out printing
it first. Like with a PDF file.

I am trying to eliminate the double printing of the same documents

I would appreciate any help
 
 
 

Embedding a word document in a database

Post by rwoodso » Sat, 11 Jun 2005 03:11:09


EJ

I think you need to find a user group associated with the Approach
Database to get this answer. If the memo field in Approach is like the
memo field in Access, it will be difficult to do, if at all. Databases
like Oracle have a blog field that you can stuff anything into,
including formatting and pictures.

 
 
 

Embedding a word document in a database

Post by jay » Sat, 11 Jun 2005 05:49:17

There may be a way to output to two different PDFs and overlay or
combine those-
but again, that takes you to the realm of Approach + PS and/or PDF
operations.

I'm sure there are ways to combine PDF pages, but it won't be with just
Acrobat or Acrobat Pro.
- happy hunting!

Jay
 
 
 

Embedding a word document in a database

Post by shog » Sat, 18 Jun 2005 07:08:43

What kind of database is it? Do you mean MS Word? Let me know, I might
be able to help.
 
 
 

Embedding a word document in a database

Post by jochen tue » Sat, 18 Jun 2005 13:43:22

EJ,

the first challenge I identify from your post is that the dataset in the
Approach database and the information in the word document are not
linked. At least, you are not describing it.

Before being able to achieve what you are looking for, either the
dataset must know about the related WordPro document (e.g. through
storing the filename in the database which I would not prefer) or the
WordPro document must know about the dataset you wish to use for your
proposal.

Not being a Approach or WordPro specialist I have to rely on my
knowledge about Microsoft Office Word: Word has a feature called "Mail
merge". "Mail Merge" is typically used, if you want to send the same
document to multiple recipients while still wanting to personalize the
information in the document. Basically "Mail Merge" allows you to have
placeholders in your document that are filled from external datasources
when printing the document. Those datasources can be anyhting that can
be queried using the standard Microsoft Query tool, including databases
that offer an ODBC interface. I would assume that Approach does have a
compatible interface.

If WordPro does not offer something comparable to "Mail Merge" I would
assume that your requirements could be fullfilled by a simple macro
using COM automation that could either be embedded into the Approach
(not preferred) or into the WordPro document.


Jochen
 
 
 

Embedding a word document in a database

Post by shog » Sat, 18 Jun 2005 22:27:04

Whoops, read too quickly. Approach and WorfPro are software names. : )

Jochen was going down a similar path I would have.
 
 
 

Embedding a word document in a database

Post by EJ » Fri, 24 Jun 2005 02:10:42

Thank you all for the replies

I did find a program that does what I need.

It is Foxit PDF edit by Foxit software. I simply print my forns to a
PDF file using broadgun software. Then I open them using Foxit and I
can cut, paste or edit to my hearts content.

BTW Foxit also has a free PDF reader the that takes only one 10th the
space of Adobe and loads in a tenth of the time

Thanks again .