Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    How To Parse 1 doc into many (2000/2002/2003)

    Using anyversion of Word from 2000 thru 2003 I would like to do the following:

    1: Import data from an Access DB into a Word document.
    I plan to just use Words Mail Merge to do this piece.

    2: After merging the data I want to take that 1 large file and split it into 1 file per merge item. The data I am pulling from Access is Knowledge Base files. Once I have this data in Word via the Mail Merge I want to then take that 1 large file and split it into 1 doc per Knowledge Base item. The end goal is to get 1PDF file per Knowledge Base item. If I can get the one Word document split into 1 document per Knowledge Base item then I can print these individually to PDF files.

    What would be great if anyone knows how to do this would be to not have to split the one Word Document up into 1 doc per Knowledge Base entry and then print each of those but to somehow get 1 PDF file per Mail Merge item from the sincle document file.

    Thoughts?
    Thanks
    Ed

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Is Word necessary as intermediary? The Access forum has several threads about exporting reports as individual files.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Unfortunately Word is required. My company has a proprietary scripting method that our clients use to create custom reports that output not only to our programs interface but to Excel, Word, Crystal Reports and even PDF. We do not interface with Access. The Word interface is for creating letters like late notices and even contracts. We provide accounting software for the property management industry. The ability to automatically generate late notices thru Word is very much in demand. For whatever reason development decided to go with the hdr files method for a data source so we in support are stuck using it. When Word 2003 came out and we found that there was no ability to use hdr files thru the default Mail Merge interface we became concerned that our clients would not be able to upgrade to Word 2003 if they wanted to retain the abilityto use our Word Merge reporting method. Thankfully I came accross the button I mentioned which allows access to the Word 2000 Mail Merge Helper screen else our clients would be stuck with a difficult choice.

    Ed

  4. #4
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Oops. Ignore my first response to your response. I have 2 items in the Word forumn and I thought your resopnse was to the other post I have in Word. My apolagies.

    Now to answer your question properly: Word does not have to be an imtermidiary if I can use Access alone to do this. I specified the use of Word and Mail Merge onnly because I can easily create in Word the exact layout I want for a Knowledge Base document and send it to Adobe for creation of a PDF file. If I can use Access alone to achive this same end result then I am open to doing so. I did look at creating a report in Access to pull the data but did not realize I could then send each to a PDF file so that each record results in a seperate PDF file. There also is the issue of future changes. Not all of my companies users have Access and of the ones that have it installed not all are famiiar with using Access. By creating Word Files I end up with a base file that is much easier for anyone in my company to make changes to at a later point in time should the file need updating.

    Thanks for your comments.
    Ed

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How To Parse 1 doc into many (2000/2002/2003)

    I don't use software to create PDF files myself, so I don't know if it's possible to create separate PDF files from a merged document without splitting it into individual documents. But I'm sure someone will come up with a bright idea.

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Either I have deja vu or someone else posted a similar request during the past month. Would you mind trying a search here?

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Hi Ed:
    Like Jefferson, I think there was a thread on this not too long ago, but I can't find it easily. You can find instructions on splitting a merge into separate files on Cindy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm
    Cheers,

  8. #8
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Hi Folks,

    I believe the recent thread you're referring to starts with <post#= 387625>post 387625</post#>. It's in the VB/VBA forum.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How To Parse 1 doc into many (2000/2002/2003)

    Hi Macropod:
    Thanks for this. Actually, it led me to the thread that I was thinking of at <post#=345245>post 345245</post#>. Seems like it's been visited several times. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •