[AccessD] [dba-OT] Output report to word

[John Bodin]

Rocky, as an alternative, can you figure out all the fields you will need, create a table in a 2003 MDB with those fields in it and use that as your merge source for the Word Doc?  Then when person runs the report, you would dump the data into the table and just call Word and not worry about the book mark piece.  Not sure what your data looks like as far as what query(ies) you need so that might be harder, but I've used both ways depending on the requirement of the app.

John

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, March 12, 2016 3:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] [dba-OT] Output report to word

Yes.  That's the mail merge approach - make a .dot document with the bookmarks and populate from an Access BE using automation.

I've done it.  It's a PITA.  So just looking for an easy way out.

r
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
Sent: Saturday, March 12, 2016 11:09 AM
To: Access List
Subject: Re: [AccessD] [dba-OT] Output report to word

Is it possible to create a word template with fields, then just write the data across, im in pub at moment but would be abke to help more tomorrow On
12 Mar 2016 18:57, "Charlotte Foust" <charlotte.foust at gmail.com> wrote:

> I seem to recall using underscores to create lines that were 
> exportable to rtf.  The line controls don't export.
>
> Charlotte Foust
> (916) 206-4336
> On Mar 12, 2016 9:01 AM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:
>
> > BTW - this is Access 2003.
> >
> > r
> >
> > -----Original Message-----
> > From: dba-OT [mailto:dba-ot-bounces at databaseadvisors.com] On Behalf 
> > Of Rocky Smolin
> > Sent: Saturday, March 12, 2016 8:39 AM
> > To: 'Access Developers discussion and problem solving'
> > Cc: 'Off Topic'
> > Subject: [dba-OT] Output report to word
> >
> > Dear List:
> >
> > I need to output a couple of reports to a word doc. If I can avoid 
> > the template/bookmark thing that would be great.
> >
> > DoCmd.OutputTo acOutputReport works well, but the reports have line 
> > and boxes which I would like to preserve.  OutputTo has a formatting 
> > option
> of
> > acFormatRTF which outputs all the text correctly formatted and 
> > spaced in Rich Text Format but loses the lines and boxes.
> >
> > Is there a simple way to create a word doc from a report that will
> preserve
> > lines, boxes and images (would like to have the client's logo in the 
> > Word doc)?
> >
> > MTIA
> >
> > Rocky Smolin
> > Beach Access Software
> > 858-771-1869
> > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> > <http://www.e-z-mrp.com/>
> > Skype: rocky.smolin
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com