Merge - Data Table

Hi


The following data I have in a template, Nick1.dot

Note; Where the"PILCROW" sign is used in word, for the=20
code below I have used the "=A3".=20

{SET Place1{MERGEFIELD Session_ID}{IF{Place2}{Place1}"
.....................Page Break.........................

=A3
{Mergefield Session_ID}=A3
{Mergefield Freq \#"0.00"}-Note: this is in a box as are=20
nine more Fields they are positioned Horizontally.
"."
{Mergefield Freq \#"0.00"}-Note This is the second group=20
of nine fields again in boxes horizontally
"}{SET PLace2{Mergefield Session_ID}}



The above worked fine before I inserted the {Mergefield=20
Freq \#"0.00"}plus the other nine fields into a table.

Now when I produce a new document I get a space between=20
each row caused by the "PILCROW" =3D carriage return at the=20
top of the first page.

When the Fields are toggled I finish up with PILCROW sign=20
and with it the lefthand Bookamrk, then below this I have=20
the first row of nine fields of data and finally below=20
this the righthand Bookmark.

Before the table insertion the bookamrks reside at either=20
end of the nine filds of data when toggled, no problems=20
and when merged to a new document all is fine,=20

So any help here, it appears the problem relates to the=20
bookmark and the first "MILCROW" =3D Carriage return.

I feel this I about as much that I can possibly explain,=20
other than sending the template and becuase of the link=20
the database as well!!=20

Tks

Nick

Hi NickH,

I think I'm following you, and have a follow-up question?

1. What is your data source?

2. Are you familiar with using a DATABASE field to create a
table of data from a data source? If you are, why would this
not give you the result you're trying to obtain using mail
merge?

If you are not familiar with it, try displaying the Database
toolbar and using the "Insert database" button.

The following data I have in a template, Nick1.dot

Note; Where the"PILCROW" sign is used in word, for the
code below I have used the "£".

{SET Place1{MERGEFIELD Session ID}{IF{Place2}{Place1}"
.....................Page Break.........................

£
{Mergefield Session ID}£
{Mergefield Freq \#"0.00"}-Note: this is in a box as are
nine more Fields they are positioned Horizontally.
"."
{Mergefield Freq \#"0.00"}-Note This is the second group
of nine fields again in boxes horizontally
"}{SET PLace2{Mergefield Session ID}}



The above worked fine before I inserted the {Mergefield
Freq \#"0.00"}plus the other nine fields into a table.

Now when I produce a new document I get a space between
each row caused by the "PILCROW" = carriage return at the
top of the first page.

When the Fields are toggled I finish up with PILCROW sign
and with it the lefthand Bookamrk, then below this I have
the first row of nine fields of data and finally below
this the righthand Bookmark.

Before the table insertion the bookamrks reside at either
end of the nine filds of data when toggled, no problems
and when merged to a new document all is fine,

So any help here, it appears the problem relates to the
bookmark and the first "MILCROW" = Carriage return.

I feel this I about as much that I can possibly explain,
other than sending the template and becuase of the link
the database as well!!


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

Hello Cindy

Thank you for the reply.

Yes the data source I am using is a query (signalPassfail)
from within Access 2002, which I hope is correct.
The reason for using a query as a source that several=20
calculations are carried out from the original data=20
table "signal", a sub-form is used to analyse the=20
calculated data.

Secondly, is it possible to use one or more fields for=20
sorting without having to have them displayed once the=20
merge has taken place? =20
I have tried this approach but come up against errors.
i.e Once I have selected the fields I wish to be=20
displayed in the merged table I do a sort "Ascending on=20
two fields which are not selected Session_ID and Signal.
the result once the merge starts is the "INVALID MERGE=20
FIELD" BOX appears, session_id this merge field is used=20
in the main document, but it does not exist in the data=20
source!.

This would seem to be just common sence since I have=20
removed fields I do not want to appear in the final=20
table, althought they are required for the sort.
if I leave the two fields in and run a merge on "All"=20
records, it all appears to work, except the data instead=20
of appearing in twelve tables (Session_ID 1 to 12, I=20
obtain one table on 13 pages.

I would expect it is something to do with my lack of=20
experience, but any help here I owuld be most appreciated=20
for. =20
-----Original Message-----
Hi NickH,=20

I think I'm following you, and have a follow-up question?

1. What is your data source?

2. Are you familiar with using a DATABASE field to=20
create a=20
table of data from a data source? If you are, why would=20
this=20
not give you the result you're trying to obtain using=20
mail=20
merge?

If you are not familiar with it, try displaying the=20
Database=20
toolbar and using the "Insert database" button.

The following data I have in a template, Nick1.dot
=20
Note; Where the"PILCROW" sign is used in word, for the=20
code below I have used the "=A3".=20
=20
{SET Place1{MERGEFIELD Session ID}{IF{Place2}
{Place1}"
.....................Page=20
Break.........................
=20
=A3
{Mergefield Session ID}=A3
{Mergefield Freq \#"0.00"}-Note: this is in a box as=20
are=20
nine more Fields they are positioned Horizontally.
"."
{Mergefield Freq \#"0.00"}-Note This is the second=20
group=20
of nine fields again in boxes horizontally
"}{SET PLace2{Mergefield Session ID}}
=20
=20
=20
The above worked fine before I inserted the=20
{Mergefield=20
Freq \#"0.00"}plus the other nine fields into a table.
=20
Now when I produce a new document I get a space=20
between=20
each row caused by the "PILCROW" =3D carriage return at=20
the=20
top of the first page.
=20
When the Fields are toggled I finish up with PILCROW=20
sign=20
and with it the lefthand Bookamrk, then below this I=20
have=20
the first row of nine fields of data and finally below=20
this the righthand Bookmark.
=20
Before the table insertion the bookamrks reside at=20
either=20
end of the nine filds of data when toggled, no=20
problems=20
and when merged to a new document all is fine,=20
=20
So any help here, it appears the problem relates to=20
the=20
bookmark and the first "MILCROW" =3D Carriage return.
=20
I feel this I about as much that I can possibly=20
explain,=20
other than sending the template and becuase of the=20
link=20
the database as well!!


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update=20
Sep=20
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any=20
follow question or reply in the newsgroup and not by e-
mail=20
:-)

.

Cindy

Another issue has come to light!

I have tried using a table as a source as well, and the=20
one thing I ma finding with the data is the demimal place.
Inthe table,for each field with the type "Number"=20
selected the format is set for Fixed and 2Pts. Open the=20
table up and the result is correct as one would expect.
If I then use word to insert the databse selecting all=20
the fields and running a merge the endresult is.
Data field columns such as the example below:

Freq
o.123455555555555555.

Not really what I want, I prefer 0.123

Tks
Nick
-----Original Message-----
Hi NickH,=20

I think I'm following you, and have a follow-up question?

1. What is your data source?

2. Are you familiar with using a DATABASE field to=20
create a=20
table of data from a data source? If you are, why would=20
this=20
not give you the result you're trying to obtain using=20
mail=20
merge?

If you are not familiar with it, try displaying the=20
Database=20
toolbar and using the "Insert database" button.

The following data I have in a template, Nick1.dot
=20
Note; Where the"PILCROW" sign is used in word, for the=20
code below I have used the "=A3".=20
=20
{SET Place1{MERGEFIELD Session ID}{IF{Place2}
{Place1}"
.....................Page=20
Break.........................
=20
=A3
{Mergefield Session ID}=A3
{Mergefield Freq \#"0.00"}-Note: this is in a box as=20
are=20
nine more Fields they are positioned Horizontally.
"."
{Mergefield Freq \#"0.00"}-Note This is the second=20
group=20
of nine fields again in boxes horizontally
"}{SET PLace2{Mergefield Session ID}}
=20
=20
=20
The above worked fine before I inserted the=20
{Mergefield=20
Freq \#"0.00"}plus the other nine fields into a table.
=20
Now when I produce a new document I get a space=20
between=20
each row caused by the "PILCROW" =3D carriage return at=20
the=20
top of the first page.
=20
When the Fields are toggled I finish up with PILCROW=20
sign=20
and with it the lefthand Bookamrk, then below this I=20
have=20
the first row of nine fields of data and finally below=20
this the righthand Bookmark.
=20
Before the table insertion the bookamrks reside at=20
either=20
end of the nine filds of data when toggled, no=20
problems=20
and when merged to a new document all is fine,=20
=20
So any help here, it appears the problem relates to=20
the=20
bookmark and the first "MILCROW" =3D Carriage return.
=20
I feel this I about as much that I can possibly=20
explain,=20
other than sending the template and becuase of the=20
link=20
the database as well!!


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update=20
Sep=20
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any=20
follow question or reply in the newsgroup and not by e-
mail=20
:-)

.

Hi NickH,

Note: you don't mention whether you've tried using a
DATABASE field? I very much recommend you try this, if the
end result you want is a table.

Yes the data source I am using is a query (signalPassfail)
from within Access 2002, which I hope is correct.

That should be fine...

is it possible to use one or more fields for
sorting without having to have them displayed once the
merge has taken place?

This is something I'd do in the query? Insert the fields,
set the sorting, and deactivate the "Show" checkbox?

if I leave the two fields in and run a merge on "All"
records, it all appears to work, except the data instead
of appearing in twelve tables (Session ID 1 to 12, I
obtain one table on 13 pages.

I doubt very much that changing just the fields you include,
or the records to which you want to merge, splits the table.
This is more likely the result of forgetting to specify
CATALOG (DIRECTORY) as the mail merge type?

I have tried using a table as a source as well, and the
one thing I ma finding with the data is the demimal place.

Word won't "see" any formatting you've applied to a field,
unless you're using a DDE connection. Then it might,
depending on how the formatting is applied.

But in any case, I'd use a query as the source and apply the
formatting explicitly using an expression. That would look
roughly like this, in a field in the top row of the query
grid:
MergeDecimalField: Format([DecimalField], "0.000")

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

Hello Cindy

First of all I have tried the DATABASE Field as suggested
and after a fassion it works, I will show you the String
I have written below, my only concern using this approach
is the Mobility,i.e we have about ten database allocated
to their own Project sub-directories.

This is the string I have used;

{DATABASE \d "S:\\R&D\\EMC\\Product-Project
Tests\\icon\\Statoil Kriston\\Kriston
Hipps2002.mdb"\c "DSN=Ms Access
Database;DBQ=S:\\R&D\\EMC\\Product-Project
Tests\\icon\\Statoil Kriston\\Kriston Hipps2002.mdb;
FIL=RedISAM"\s "Select * From
\ "SignalPassfail\""\f "01"\t "432"\I "3"}

when used in a template, selecting CTRL A and F9 to
update works, the only problem I see with this is the
string would have to be edited for the template to be
used with other databases simply because they have their
own allocated sub-directory's. A problem for me to
resolve.

Secondly, emitting the two fields from the query source
works ok.

Thirdly, on the topic of the table size and producing the
separate tables, I have checked and the document produced
is labled as "catalogue1", and checking the Mail merge
topic area, the select document type is set
to "Directory", which I am assuming is the correct one
since it is the only one I have been using.

The forth and last, I am a little confused here, not so
much with the expression MergeDecimalfield: Format
([DecimalField], "0.000") but where it is used.

i.e in the first query field in the top row the title
is "Freq", so how do I add the expression to this field

Any help here Cindy would be most appreciated.

Tks

Nick

-----Original Message-----
Hi NickH,

Note: you don't mention whether you've tried using a
DATABASE field? I very much recommend you try this, if
the
end result you want is a table.

Yes the data source I am using is a query
(signalPassfail)
from within Access 2002, which I hope is correct.

That should be fine...

is it possible to use one or more fields for
sorting without having to have them displayed once the
merge has taken place?

This is something I'd do in the query? Insert the
fields,
set the sorting, and deactivate the "Show" checkbox?

if I leave the two fields in and run a merge on "All"
records, it all appears to work, except the data
instead
of appearing in twelve tables (Session ID 1 to 12, I
obtain one table on 13 pages.

I doubt very much that changing just the fields you
include,
or the records to which you want to merge, splits the
table.
This is more likely the result of forgetting to specify
CATALOG (DIRECTORY) as the mail merge type?

I have tried using a table as a source as well, and
the
one thing I ma finding with the data is the demimal
place.

Word won't "see" any formatting you've applied to a
field,
unless you're using a DDE connection. Then it might,
depending on how the formatting is applied.

But in any case, I'd use a query as the source and apply
the
formatting explicitly using an expression. That would
look
roughly like this, in a field in the top row of the
query
grid:
MergeDecimalField: Format([DecimalField], "0.000")

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-
mail
:-)

.

Hi NickH,

First of all I have tried the DATABASE Field as suggested
and after a fassion it works, my only concern using this
approach is the Mobility,i.e we have about ten database
allocated to their own Project sub-directories.

Perhaps if you told us more about how you need to use these
data tables, we could work out an approach?

do you really NEED mail merge, or is you main interest
simply seeing a table of the data, coming from a query?

The forth and last, I am a little confused here, not so
much with the expression MergeDecimalfield: Format
([DecimalField], "0.000") but where it is used.

i.e in the first query field in the top row the title
is "Freq", so how do I add the expression to this field

This is used in the top row, in the first empty column. what
you're doing, in essence, is creating a new "field" for the
query result. The term to the left of the colon will be the
field name, the information to the right calculates the
result you want in the column. After you've created the
expression, you can select the column in the query grid and
drag it to any position you wish.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)