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

Rocky Smolin rockysmolin at bchacc.com
Sat Mar 12 14:04:55 CST 2016


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



More information about the AccessD mailing list