Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Producing Tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NickH - 08 Apr 2004 15:17 GMT
Hi

I am trying to merge the following table into a word
document.

  Limit Line    Freq Scale     Amp Scale
      ON           LIN            LOG
     Value        (MHz)         (dBuA)
       1          0.009          79.0
       2          0.150          79.0
       3          0.500          79.0
       4          0.500          73.0
       5          30.00          73.0

The only cells which are merged into the document from
access are the rows associated with the figures.
I now have no problems with the first Row(1), the data is
correct when merged into the table, but if I use <<NEXT
RECORD>> for the three fields in the next row down(2), I
get the following values in the table

       2           0.500          73.0
 
Could some one advise me whatI may be doing wrong, please

Thanks

Nick Hyde
Graham Mayor - 08 Apr 2004 16:08 GMT
You need to set this up as a directory (catalog) merge. Put one row on the
page containing the three fields, then merge to a new document. The merge
will build the table. Do not use next fields for this.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

  Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi
>
[quoted text clipped - 24 lines]
>
> Nick Hyde
NickH - 09 Apr 2004 11:22 GMT
Hi Grahame

Just to say thanks, it works OK.
All I need to do now, is to find a way for merging not
just one table onto one page, but from the Access table
gather the rest of the data in the table to merge out to
Word, i.e. the Table shown below
Session ID    Number    Segment    Freq    Amp
  1             0      1   0.009    101.9999
  1             0        2   0.15    78.99994
  1             0      3   0.5    78.99994
  1             0        4   0.5    72.99996
  1             0        5   30    72.99996
  1             1        1   0.009    88.9999
  1              1        2   0.15    65.99999
  1             1        3   0.5    65.99999
  1             1        4   0.5    60.00002
  1             1        5   30    60.00002
  2             0        1   0.009    101.9999
  2             0        2   0.15    78.99994
  2             0        3   0.5    78.99994
  2              0        4   0.5    72.99996
  2             0        5   30    72.99996
  2             1        1   0.009    88.9999
  2              1        2   0.15    65.99999
  2             1        3   0.5    65.99999
  2               1        4   0.5    60.00002
  2             1        5   30    60.00002

The table shows two Sessions (normally more), within each
session there are two Groups 0 & 1 each one forms a
table. From this what I am trying to achieve is to have
two tables per page so for session 1, there would be two
tables 0 & 1, with corresponding rows of data (Segment)1
to 5
The only point I can mention here is how we have or need
the Word document laid out, the tables would not go on
consecutive pages! therefore I need to find a way to
merge the specific Session with both tables at an
appropriate section of the Word Document.

I hope I have not confused.

Thanks

Nick  
>-----Original Message-----
>You need to set this up as a directory (catalog) merge. Put one row on the
[quoted text clipped - 31 lines]
>
>.
Graham Mayor - 09 Apr 2004 11:43 GMT
You can't do that. The only way I can think of would be to merge the two
tables separately and combine the resulting documents.
You could use a third document with Includetext fields to place the merged
table documents. It's a bit fiddly but should work OK.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

  Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi Grahame
>
[quoted text clipped - 86 lines]
>>
>> .
- 09 Apr 2004 11:56 GMT
OK

I will have ago

Thanks

>-----Original Message-----
>You can't do that. The only way I can think of would be to merge the two
[quoted text clipped - 94 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.