Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table that grows (Office 2000)

    Hi guys,
    I

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

    Re: Table that grows (Office 2000)

    Hi Princess:

    Why don't you use a catalog as the main document. Put in a one row table with each cell containing a mergefield in the main document. When you do the merge, you'll have 1 record per row.

    Hope this helps.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    Hi Phill.
    I've changed the main document to catalog, and have added one row table with mergefeilds.
    When I merge it only shows one record as I expected but what I want it to do is to create more rows and add all the records to the document.
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

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

    Re: Table that grows (Office 2000)

    Hi Princess:

    A mailmerge consists of 3 documents:
    1. A datasource (where the records are kept). This is generally (but not necessarilly) in table form with 1 column per field of information & 1 row per record.
    2. A set of instructions telling Word how to pick items from these records & what format to put them in. Word calls this a main document.
    3. The merged document (the result of merging 1. & 2.).

    You are at step 2. You must now merge the records from Item 1 using the instructions from Item 2. If you've been able to create a catalog, you probably used the mailmerge wizard. That dialog box will have the term "merge" for the 3rd step. Just merge the records & fields that you wish.

    Hope this helps.

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    Hi Phill!
    Thank you.
    I found out what you just told me. But the problem is that I need to have both form and catalog in one page coz its a Fax Cover. Have a look at the attachment.
    Attached Files Attached Files

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

    Re: Table that grows (Office 2000)

    Hi Princess:

    Then I wouldn't use mailmerge for the table. Just set up your cover page (as a form letter, if you're mailing out several) & have an INCLUDETEXT field for your table. As long as your information is the first worksheet in the Excel workbook, you should be able to include it easily...unless I'm missing something. Wouldn't be the first time. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  7. #7
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    I don't get it.
    How would include text help me create a table in word document?
    Unless you're telling me to create a table in Excell with the information and then cut and paste it automatically. Have a look at the following post and tell me what you think.
    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=96308&page=0&vie w=collapsed&sb=5&o=0&fpart=>http://www.wopr.com/cgi-bin/w3t/showflat.p...sb=5&o=0&fpart=</A>

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

    Re: Table that grows (Office 2000)

    Hi Princess:
    Includetext fields do not require any cut & paste. However, I forgot that you were using Access and I'm not very familiar with it. However, you can type a form coversheet in Word & instead of using INCLUDETEXT fields, you can insert a database. I still may not be fully understanding what you have, but see if this works for you.

    1. Put your cursor in the cover sheet where you want the table to go.
    2. Right click any toolbar & choose the Database toolbar.
    3. Click the Insert/Database button.
    4. Click Get Data...
    5. Change the "Files of Type" box to MS Access Databases.
    6. Browse to your Access file & click Open. A dialog box will open saying "confirm data source".
    7. Choose MS Access via DDE. Another dialog box will open showing Tables & Queries.
    8. Choose the appropriate table or query.
    9. You will have an opportunity to use query options, if you wish.
    10. Choose Insert/Data & then choose which records &/or fields you want to insert.

    As your table in Access grows, you can update Word by selecting everything (Ctrl+A) & then updating the field (F9).

    Hope this helps.

  9. #9
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    Thanx Phil!
    But What I've done was to create a mail merge catalog and put everything other than the mail merge feilds in the header and the footer section which does exactly what its supposed to do, There is one tiny problem which is that I have also had a Trade date feild and a Rec No feild, I don't wanna put this in the body part of the document coz it will repeat it self but when I tried to put it in the header, it wouldn't merge. Any idea on how i could go around this??
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

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

    Re: Table that grows (Office 2000)

    Hi Princess:

    I'm not sure. When you mail merge, you can't merge fields into a header obviously because it doesn't make sense to have variable information to repeat on every page. Is there are column (field) for Trade Date & Rec No? I don't know if it's feasible to put it in a column in Access & then merge it where you want. As I say, I'm not that familiar with Access. Sorry.

  11. #11
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    No worries Phil,
    My manager said he could enter the Trade Date and the Total Rec No manually so all is fine.
    Thanx 4 the help
    <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15> <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

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

    Re: Table that grows (Office 2000)

    Hi Princess:

    I think I've found a description on the Microsoft MVP site that might work for you. I should tell you that I haven't tried it, but it seems to address the exact situation that you refer to. Let me know if this helps. You can find it <A target="_blank" HREF=http://www.mvps.org/word/FAQs/index.html>here</A>. Look for the mail merge tab & the topic "How to List Multiple Items for a Single Condition".

    If I come up with any other ideas, I'll let you know.

    Hope this helps.

  13. #13
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    Hi Phil!
    Thanx for the link but I cannot run any of the programs in that site coz all of those programs are for Office 95 & 97 and my system wouldn't allow me to convert it to 2000.

    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  14. #14
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table that grows (Office 2000)

    Is it possible to automate this:
    Insert information from a database or other data source into an existing Word document
    What I have to do is insert a MS Excel spreadsheet into MS word Fax cover document. The data is exported to Excel automatically. I want the cursor to be set on a particular line (e.g. Line 10) and then automatically insert the table from that point onwards.
    Is this possible???
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

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

    Re: Table that grows (Office 2000)

    Hi Princess:
    I believe this is possible, but I'm not a VBA expert. It seems to me that you're talking about a macro that would open Excel, select a range, copy it, switch back to Word & paste.

    I recall that on the site that mentioned in my previous post, there was a technique using SET & IF fields. You should be able to use them in Access 2000 & Word 2000, but I don't have time to test them at present. Sorry.

Page 1 of 2 12 LastLast

Posting Permissions

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