By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Rendering MS Access Report Into Something Else Besides Printer/PDF?

P: n/a
I'm doing a booklet for a class reunion. Got all the data and everybody's life
history in a little MS Access app and now it's time to get the booklet ready to
go to the printer's.

I have a report that creates same, but rather than send it to a printer of PDF
file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow the
text around their pix.

I've considered exporting to an MS Word mail-merge, but there's so much
contitional formatting in the report (mainly, if somebody is deceased, various
fields become invisible and an obituary takes over the whole space) that I'd
probably have to go back and re-think the whole document to do so.

I've tried copying/pasting from Acrobat, but it only gets the text - no
positioning or lines...

So: bottom-line question.... Is there some way I can render this thing and get
it into a document editor?
--
PeteCresswell
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try setting up the report in Access, then just exporting it to Word, not as
a mail-merge. It should come across in RTF format, which will preserve your
formatting. You can open it in Word and edit further.

HTH
- Turtle

"(Pete Cresswell)" <x@y.z> wrote in message
news:vc********************************@4ax.com...
I'm doing a booklet for a class reunion. Got all the data and everybody's life history in a little MS Access app and now it's time to get the booklet ready to go to the printer's.

I have a report that creates same, but rather than send it to a printer of PDF file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow the text around their pix.

I've considered exporting to an MS Word mail-merge, but there's so much
contitional formatting in the report (mainly, if somebody is deceased, various fields become invisible and an obituary takes over the whole space) that I'd probably have to go back and re-think the whole document to do so.

I've tried copying/pasting from Acrobat, but it only gets the text - no
positioning or lines...

So: bottom-line question.... Is there some way I can render this thing and get it into a document editor?
--
PeteCresswell

Nov 13 '05 #2

P: n/a
Pete,
I'd tend to do some VBA where I fired up an instance of Word in my code and
then had Word do whatever heavy lifting was needed to complete the document.
There is limited support for conditional branching in the mail-merge codes
supported by Word but it may not be enough. The automation possible in Word
with its command set in VB is extensive so that's probably where I'd focus
my energy.

"(Pete Cresswell)" <x@y.z> wrote in message
news:vc********************************@4ax.com...
I'm doing a booklet for a class reunion. Got all the data and
everybody's life
history in a little MS Access app and now it's time to get the booklet
ready to
go to the printer's.

I have a report that creates same, but rather than send it to a printer of
PDF
file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow
the
text around their pix.

I've considered exporting to an MS Word mail-merge, but there's so much
contitional formatting in the report (mainly, if somebody is deceased,
various
fields become invisible and an obituary takes over the whole space) that
I'd
probably have to go back and re-think the whole document to do so.

I've tried copying/pasting from Acrobat, but it only gets the text - no
positioning or lines...

So: bottom-line question.... Is there some way I can render this thing and
get
it into a document editor?
--
PeteCresswell

Nov 13 '05 #3

P: n/a
RE/
I'd tend to do some VBA where I fired up an instance of Word in my code and
then had Word do whatever heavy lifting was needed to complete the document.
There is limited support for conditional branching in the mail-merge codes...


I never thought of that: just open up an instance of Word from Access and build
customized pages individually on-the-fly. Thanks. I've done this before in
customer-response letters...I guess I just got so fixated on mail-merge this
time that it didn't occurred to me.

--
PeteCresswell
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.