Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting an inserted database field
Using Word 2003, I have a mail merge which also has an inserted database (by
using Insert/Field/Database, browsing to the database, and inserting the conditional database as a field excluding formatting). This database is used to generate a telephone number dependant on data in the main database (and I have to do it this way, unfortunately!!!!). So, I have an inserted field which produces a result and displays on the document. All working fine except; I can't seem to apply any formatting to the field (all I want in this instance is to make the result bold). Teh field is embedded in a few IF commands, and I've replaced * Mergeformat with * Charformat wherever I could find them, all to no avail. Any ideas on how to make the formatting stick once the mail merge ins run would be greatly appreciated, as it's driving me absolutely nuts. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting an inserted database field
Have you applied Bold formatting to the first character of the field to
which you have applied the charformat switch? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Xanbaby" wrote in message ... Using Word 2003, I have a mail merge which also has an inserted database (by using Insert/Field/Database, browsing to the database, and inserting the conditional database as a field excluding formatting). This database is used to generate a telephone number dependant on data in the main database (and I have to do it this way, unfortunately!!!!). So, I have an inserted field which produces a result and displays on the document. All working fine except; I can't seem to apply any formatting to the field (all I want in this instance is to make the result bold). Teh field is embedded in a few IF commands, and I've replaced * Mergeformat with * Charformat wherever I could find them, all to no avail. Any ideas on how to make the formatting stick once the mail merge ins run would be greatly appreciated, as it's driving me absolutely nuts. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting an inserted database field
Yes I have. Weirdly, when "Toggle Field Codes" is carried out on the field, the toggled codes are in bold, and I've re-applied bold many, many times to the toggled codes and the field when it's not toggled, however when the mail merge is run, it loses the formatting. I'm attaching (hopefully!) a jpg with the toggled code, in the hope that it may assist. The field BED.TEL" is in the main database, the rest of the code is looking at a small separate database. Any further advice you could give me would be greatly appreciated. "Doug Robbins - Word MVP" wrote in message ... Have you applied Bold formatting to the first character of the field to which you have applied the charformat switch? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Xanbaby" wrote in message ... Using Word 2003, I have a mail merge which also has an inserted database (by using Insert/Field/Database, browsing to the database, and inserting the conditional database as a field excluding formatting). This database is used to generate a telephone number dependant on data in the main database (and I have to do it this way, unfortunately!!!!). So, I have an inserted field which produces a result and displays on the document. All working fine except; I can't seem to apply any formatting to the field (all I want in this instance is to make the result bold). Teh field is embedded in a few IF commands, and I've replaced * Mergeformat with * Charformat wherever I could find them, all to no avail. Any ideas on how to make the formatting stick once the mail merge ins run would be greatly appreciated, as it's driving me absolutely nuts. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting an inserted database field
Sorry, meant field "BED.DIVISION", ignore reference to "BED.TEL" in
earlier post. Any assistance would really be greatly appreciated. "Xanbaby" wrote in message ... Yes I have. Weirdly, when "Toggle Field Codes" is carried out on the field, the toggled codes are in bold, and I've re-applied bold many, many times to the toggled codes and the field when it's not toggled, however when the merge is run, it loses the formatting. I'm attaching (hopefully!) a jpg with the toggled code, in the hope that it may assist. The field BED.TEL" is in the main database, the rest of the code is looking at a small separate database. Any further advice you could give me would be greatly appreciated. "Doug Robbins - Word MVP" wrote in message ... Have you applied Bold formatting to the first character of the field to which you have applied the charformat switch? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Xanbaby" wrote in message ... Using Word 2003, I have a mail merge which also has an inserted database (by using Insert/Field/Database, browsing to the database, and inserting the conditional database as a field excluding formatting). This database is used to generate a telephone number dependant on data in the main database (and I have to do it this way, unfortunately!!!!). So, I have an inserted field which produces a result and displays on the document. All working fine except; I can't seem to apply any formatting to the field (all I want in this instance is to make the result bold). Teh field is embedded in a few IF commands, and I've replaced * Mergeformat with * Charformat wherever I could find them, all to no avail. Any ideas on how to make the formatting stick once the mail merge ins run would be greatly appreciated, as it's driving me absolutely nuts. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting an inserted database field
When I looked at your screenshot, there was no \*Charformat switch at
the end of the { DATABASE } field. What Doug was saying is that you need that switch /and/ to apply bold formatting to the D of the DATABASE field (or the whole field, if you like) It works OK here but I wouldn't want to predict what happens if your table flows over more than one page. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Xanbaby wrote: Sorry, meant field "BED.DIVISION", ignore reference to "BED.TEL" in earlier post. Any assistance would really be greatly appreciated. "Xanbaby" wrote in message ... Yes I have. Weirdly, when "Toggle Field Codes" is carried out on the field, the toggled codes are in bold, and I've re-applied bold many, many times to the toggled codes and the field when it's not toggled, however when the merge is run, it loses the formatting. I'm attaching (hopefully!) a jpg with the toggled code, in the hope that it may assist. The field BED.TEL" is in the main database, the rest of the code is looking at a small separate database. Any further advice you could give me would be greatly appreciated. "Doug Robbins - Word MVP" wrote in message ... Have you applied Bold formatting to the first character of the field to which you have applied the charformat switch? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Xanbaby" wrote in message ... Using Word 2003, I have a mail merge which also has an inserted database (by using Insert/Field/Database, browsing to the database, and inserting the conditional database as a field excluding formatting). This database is used to generate a telephone number dependant on data in the main database (and I have to do it this way, unfortunately!!!!). So, I have an inserted field which produces a result and displays on the document. All working fine except; I can't seem to apply any formatting to the field (all I want in this instance is to make the result bold). Teh field is embedded in a few IF commands, and I've replaced * Mergeformat with * Charformat wherever I could find them, all to no avail. Any ideas on how to make the formatting stick once the mail merge ins run would be greatly appreciated, as it's driving me absolutely nuts. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting an inserted database field
Duh. Yes, of course, applying *\ CHARFORMAT to the {Database} field is the
answer, can't believe I overlooked that, not enough coffee obviously. Unfortunately for me though, it's thrown up a weird knock on effect. Following population of the mailmerge, the field populated and aligned as normal UNTIL I applied the *\ CHARFORMAT to the {Database} field in the master document. Once this is completed, the formatting does indeed change to Bold, however a hard carriage return is also appearing before the field, so the field is now misaligning. I have analysed the document, and after the merge is completed have discovered the following: 1. When viewing the document without Show/Hide formatting selected (and before CHARFORMAT is applied to the field in the master document), all looks fine. 2. When viewing the document with Show/Hide Formatting selected (and before CHARFORMAT is applied to the field in the master document), there is a carriage return before the field (this disappears again once the Show/Hide Formatting is turned off, and the document also prints correctly. I am unable to manually delete the carriage return. This is puzzling me greatly). 3. Once the CHARFORMAT is applied to the field, the carriage return appears in the merged document, and the document misaligns. So, to summarise, a carriage return is somehow magically creeping in, but while there, doesn't cause the document to look/print incorrectly unless CHARFORMAT is applied to the field. Don't think coffee is going to help me on this, any ideas would be greatly appreciated. "Peter Jamieson" wrote in message ... When I looked at your screenshot, there was no \*Charformat switch at the end of the { DATABASE } field. What Doug was saying is that you need that switch /and/ to apply bold formatting to the D of the DATABASE field (or the whole field, if you like) It works OK here but I wouldn't want to predict what happens if your table flows over more than one page. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Xanbaby wrote: Sorry, meant field "BED.DIVISION", ignore reference to "BED.TEL" in earlier post. Any assistance would really be greatly appreciated. "Xanbaby" wrote in message ... Yes I have. Weirdly, when "Toggle Field Codes" is carried out on the field, the toggled codes are in bold, and I've re-applied bold many, many times to the toggled codes and the field when it's not toggled, however when the merge is run, it loses the formatting. I'm attaching (hopefully!) a jpg with the toggled code, in the hope that it may assist. The field BED.TEL" is in the main database, the rest of the code is looking at a small separate database. Any further advice you could give me would be greatly appreciated. "Doug Robbins - Word MVP" wrote in message ... Have you applied Bold formatting to the first character of the field to which you have applied the charformat switch? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Xanbaby" wrote in message ... Using Word 2003, I have a mail merge which also has an inserted database (by using Insert/Field/Database, browsing to the database, and inserting the conditional database as a field excluding formatting). This database is used to generate a telephone number dependant on data in the main database (and I have to do it this way, unfortunately!!!!). So, I have an inserted field which produces a result and displays on the document. All working fine except; I can't seem to apply any formatting to the field (all I want in this instance is to make the result bold). Teh field is embedded in a few IF commands, and I've replaced * Mergeformat with * Charformat wherever I could find them, all to no avail. Any ideas on how to make the formatting stick once the mail merge ins run would be greatly appreciated, as it's driving me absolutely nuts. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem when date field from Excel database is inserted to Word 20 | Mailmerge | |||
database field - merge single field from excel list | Microsoft Word Help | |||
How do I print a .mdb database inserted into a merged document | Mailmerge | |||
formatting inserted files? | Microsoft Word Help | |||
Formatting of inserted files | Microsoft Word Help |