If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Merge - Data Table
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 :-) |
#3
|
|||
|
|||
Merge - Data Table
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 :-) . |
#4
|
|||
|
|||
Merge - Data Table
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 :-) . |
#5
|
|||
|
|||
Merge - Data Table
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 :-) |
#6
|
|||
|
|||
Merge - Data Table
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- :-) . |
#7
|
|||
|
|||
Merge - Data Table
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 :-) |
Thread Tools | |
Display Modes | |
|
|