Re: exporting access reports into word

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 13:17:27 +1300

Marc,

No, I did not mean to re-type all of your data into the Word document.
I mean to export the data from the Access database into the Word
document, as you have apparently already done. And then do the required
formatting and layout in Word, after you have the data in there. Will
this work for you? If not, why not?

Otherwise, did you look at the information at lebans.com? 

-- 
Steve Schapel, Microsoft Access MVP
marc wrote:
> Hi Steve - 
> 
> I can very easily put my educational data in word...It's just very time 
> consuming typing each data element in one by one...With my knowledge of 
> Access, I was hoping that I could build a db that holds all of this 
> educational data, then do a sort by city, then build a report (that was 
> copied from my original Word Table) and place the data in their appropriate 
> cells...Then, export that report into RTF....It's just that Access will not 
> allow me to keep the formatting (lines and text), like you mentioned...
> 
> It just seems odd to me that when I took a blank Word table and copied & 
> pasted into Access, it looks just like it should on the monitor...All of my 
> reasons for students dropping out with appropriately lined up in their 
> respectful columns and rows...Then, when I put data in and try to export to 
> RTF, I get just the data...
> 
> It's a bummer that it happens to be a document that the gov't needs to keep 
> 'as is'....I can't play around with it at all, in other words, I can't send 
> them a pdf or an image or something like that....
>  
> The only solution that I could think of was to create a mailmerge in Word, 
> but there seems to be a limit on the number of fields in a mailmerge...
> 
> Is there anything else that I can do with Access and my little project here???
> 
> Thanx for all of your help!!!
> marc
>

Relevant Pages

  • Re: Export Access data to Outlook or Word
    ... >John, I have an Access report and can save as snapshot format, but ultimately ... Is there another way to automate this without using mailmerge? ... >> data has to be grouped (e.g. multiple records per customer) it's ...
    (microsoft.public.access.externaldata)
  • Re: Kiddie fucker Heenan is a cunt who deserves a fucking good kicking
    ... If you have no evidence, ... Duncan Heenan ... You don't mind if I report this abuse, with you named as a witness, do you? ... You have my full permission and support in reporting this to the Authorities, Marc; and they will receive my full cooperation in properly investigating the whole business. ...
    (uk.rec.naturist)
  • Re: page number printing on a merged report
    ... What else is in you mailmerge main document other than the 15 x 5 ... Sounds like you could just have 1 set of the 5 mergefields in ... If you try the page numbering scheme in the ... > Excel file that is read and placed on the merged report. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Jurassic Otter-Beaver-pus
    ... Marc wrote: ... The New York Times has a story too, and there is a technical report ... In the conventional view, the earliest mammals were small, primitive, ... The Jurassic is a bit far back, but the marsupial, eutherian split had ...
    (talk.origins)