472,096 Members | 1,433 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

Exporting to Word and including graphics

Is it possible to export a report to word and have it include the
graphics that are in the report?

I'd like to take some of our reports and export them to word so we can
email those to the client, but when I export, I lose the logo as well
as any graphics (grey line separaters, etc) and only get the text of
the reports.
Nov 12 '05 #1
5 5379
On Fri, 19 Sep 2003 21:44:18 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:
"Jayjay" <jj****@notmail.com> wrote in message
news:3f****************@news.cis.dfn.de...
Is it possible to export a report to word and have it include the
graphics that are in the report?

I'd like to take some of our reports and export them to word so we can
email those to the client, but when I export, I lose the logo as well
as any graphics (grey line separaters, etc) and only get the text of
the reports.


There is no single simple way to do this. You could look at exporting the
file as a snapshot (.snp) file which is the easiest solution. The snapshot
viewer is software that comes with MS Access or can be downloaded for free
from Microsoft.

If not, you might consider a mailmerge (not the most flexible) or you might
have to write some custom code to get what you need.

Fletcher


Exporting to PDF works - but unfortunately, not all users have the
ability to export to PDF and spending a few hundred $$ on a program to
do that just to export reports is not gonna happen with this company.
(were talking the need for about 100 users to use this database on
occasion).

Nov 12 '05 #2
That software is call PDF995 by a company called software995 (retarded name
in my opinion), it costs $US 20 for a single liscence, and cheaper for site
liscences

It does not support automation that I know of, it operates by setting
options through a ini file. As far as I know it is the cheapest on the
market. It can be set as a shared printer driver and with a bit of messy
programming and a shell to a dos batch file you can get away with one
liscence on one computer. With 100 users Im not sure its a great idea
though.

Or the easy way is to use snapshot....but nearly everyone has acrobat
installed and nearly no one has snapshot viewer installed. So i'd go with
pdf, itd be cheaper than getting everone to install snapshot viewer.

Also if 100 people are using the database, and they arnt willing to spend a
few hundred dollers, then they're idiots and you should quit your job :)

Regards
John Sheppard

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:qs********************************@4ax.com...
On Fri, 19 Sep 2003 22:46:02 GMT, jj****@notmail.com (Jayjay) wrote:
On Fri, 19 Sep 2003 21:44:18 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:
"Jayjay" <jj****@notmail.com> wrote in message
news:3f****************@news.cis.dfn.de...
Is it possible to export a report to word and have it include the
graphics that are in the report?
I'd like to take some of our reports and export them to word so we can
email those to the client, but when I export, I lose the logo as well
as any graphics (grey line separaters, etc) and only get the text of
the reports.There is no single simple way to do this. You could look at exporting thefile as a snapshot (.snp) file which is the easiest solution. The snapshotviewer is software that comes with MS Access or can be downloaded for freefrom Microsoft.
If not, you might consider a mailmerge (not the most flexible) or you mighthave to write some custom code to get what you need.

Exporting to PDF works - but unfortunately, not all users have the
ability to export to PDF and spending a few hundred $$ on a program to
do that just to export reports is not gonna happen with this company.
(were talking the need for about 100 users to use this database on
occasion).


A few hundred bucks? If memory serves, there's a free or nearly free
utility out there called something like "PDF99" (numbers might be off)
that can create "basic / simple" PDF files without needing the full
PDF creator package.

Personally however, I've always just gone the route of using Office
Automation to create a report via a Document Template file. It's
fast, it's quick, but it's not always very easy.

--
Ever Stop To Think And Forget To Start Again?

Nov 12 '05 #3
"Steve" <sa****@penn.com> wrote in message news:<1q*******************@newsread2.news.atl.ear thlink.net>...
Chuck,

What is a Document Template file and how do you get Access data into it?

Thanks!

Steve

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:qs********************************@4ax.com...
On Fri, 19 Sep 2003 22:46:02 GMT, jj****@notmail.com (Jayjay) wrote:
On Fri, 19 Sep 2003 21:44:18 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:

>"Jayjay" <jj****@notmail.com> wrote in message
>news:3f****************@news.cis.dfn.de...
>> Is it possible to export a report to word and have it include the
>> graphics that are in the report?
>> I'd like to take some of our reports and export them to word so we can
>> email those to the client, but when I export, I lose the logo as well
>> as any graphics (grey line separaters, etc) and only get the text of
>> the reports.There is no single simple way to do this. You could look at exporting the
>file as a snapshot (.snp) file which is the easiest solution. The snapshot
>viewer is software that comes with MS Access or can be downloaded for free
>from Microsoft.
>If not, you might consider a mailmerge (not the most flexible) or you might
>have to write some custom code to get what you need.Exporting to PDF works - but unfortunately, not all users have the
ability to export to PDF and spending a few hundred $$ on a program to
do that just to export reports is not gonna happen with this company.
(were talking the need for about 100 users to use this database on
occasion).


A few hundred bucks? If memory serves, there's a free or nearly free
utility out there called something like "PDF99" (numbers might be off)
that can create "basic / simple" PDF files without needing the full
PDF creator package.

Personally however, I've always just gone the route of using Office
Automation to create a report via a Document Template file. It's
fast, it's quick, but it's not always very easy.

--
Ever Stop To Think And Forget To Start Again?


Hi,

first of all its called pdf995 and its very good!.
Second, why don't you write your reports direct with word?
It's a bit tricky at the beginning and not really fast, but you have
much more options to design very good reports.

you have to embed fm20.dll, maybe wordxx.dll (or ocx, i'm not sure).
and you can start. Just 1 hint: always use word."function". ... .
Don't leave the word. because this can sometime, don't knwo when
exactly cause problems.

Gr T
Nov 12 '05 #4
Take a look at what Stephen Lebans has at
http://www.lebans.com/ReportUtilities.htm

If you want to go the PDF route, CutePDF is completely free (pdf999 is
nag-ware unless you pay $9.99)
http://www.acrosoftware.com/products...df/Printer.asp

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
"Jayjay" <jj****@notmail.com> wrote in message
news:3f****************@news.cis.dfn.de...
Is it possible to export a report to word and have it include the
graphics that are in the report?

I'd like to take some of our reports and export them to word so we can
email those to the client, but when I export, I lose the logo as well
as any graphics (grey line separaters, etc) and only get the text of
the reports.

Nov 12 '05 #5
CutePDF is completely free
http://www.acrosoftware.com/products...df/Printer.asp

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
"John Sheppard" <jt************@nobosospam.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
That software is call PDF995 by a company called software995 (retarded name in my opinion), it costs $US 20 for a single liscence, and cheaper for site liscences

It does not support automation that I know of, it operates by setting
options through a ini file. As far as I know it is the cheapest on the
market. It can be set as a shared printer driver and with a bit of messy
programming and a shell to a dos batch file you can get away with one
liscence on one computer. With 100 users Im not sure its a great idea
though.

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by mik18 | last post: by
1 post views Thread by gooberoot | last post: by
2 posts views Thread by Neil | last post: by
3 posts views Thread by gowens | last post: by
1 post views Thread by Mustufa Baig | last post: by
2 posts views Thread by Mux | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.