| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
formatting mailmerge in word2003
I want to format a string, coming from a access-query into my merged document.
The value is BE012345679. I want to format as BE 0123.456.789 wich is in fact a belgian VAT nummer. Formating the string in the query does not help. Is there a "over-all-structure" for formatting this kind of strings? Thanks a lot -- cram |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
formatting mailmerge in word2003
Word does not have the ability to do that, but for sure it can be done with
a Query in Access even if you had to resort to Left(fname, 2) & " " & Mid(fname, 3, 4) & "." & Mid(fname, 7, 3) & "." & Right(fname, 3) -- 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 "cram" wrote in message ... I want to format a string, coming from a access-query into my merged document. The value is BE012345679. I want to format as BE 0123.456.789 wich is in fact a belgian VAT nummer. Formating the string in the query does not help. Is there a "over-all-structure" for formatting this kind of strings? Thanks a lot -- cram |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
formatting mailmerge in word2003
Thanks Doug,
this works. I tried before to use a format() in my query but it went wrong. What you propose is in fact quiet logic = make a "real" string... When i look in the result in my access query, i see a rather different presentation than the word result, is this OK? See you. -- cram "Doug Robbins - Word MVP" wrote: Word does not have the ability to do that, but for sure it can be done with a Query in Access even if you had to resort to Left(fname, 2) & " " & Mid(fname, 3, 4) & "." & Mid(fname, 7, 3) & "." & Right(fname, 3) -- 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 "cram" wrote in message ... I want to format a string, coming from a access-query into my merged document. The value is BE012345679. I want to format as BE 0123.456.789 wich is in fact a belgian VAT nummer. Formating the string in the query does not help. Is there a "over-all-structure" for formatting this kind of strings? Thanks a lot -- cram |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
formatting mailmerge in word2003
I am not sure what you mean by "a rather different presentation", but if the
Word result is what you want, then what does it matter. -- 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 "cram" wrote in message ... Thanks Doug, this works. I tried before to use a format() in my query but it went wrong. What you propose is in fact quiet logic = make a "real" string... When i look in the result in my access query, i see a rather different presentation than the word result, is this OK? See you. -- cram "Doug Robbins - Word MVP" wrote: Word does not have the ability to do that, but for sure it can be done with a Query in Access even if you had to resort to Left(fname, 2) & " " & Mid(fname, 3, 4) & "." & Mid(fname, 7, 3) & "." & Right(fname, 3) -- 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 "cram" wrote in message ... I want to format a string, coming from a access-query into my merged document. The value is BE012345679. I want to format as BE 0123.456.789 wich is in fact a belgian VAT nummer. Formating the string in the query does not help. Is there a "over-all-structure" for formatting this kind of strings? Thanks a lot -- cram |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
formatting mailmerge in word2003
Indeed result is OK. But I wonder why (although not a women, still very
curious...) something like this BE 01 12.4.56..789 when I activate the "cell" the presentation is normal as it should be: BE 0123.456.789 if you do'nt have a ready-made answer, forget it. It doesn't matter. Thanks anyway. You helped me a lot for this and some more "problems". -- cram "Doug Robbins - Word MVP" wrote: I am not sure what you mean by "a rather different presentation", but if the Word result is what you want, then what does it matter. -- 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 "cram" wrote in message ... Thanks Doug, this works. I tried before to use a format() in my query but it went wrong. What you propose is in fact quiet logic = make a "real" string... When i look in the result in my access query, i see a rather different presentation than the word result, is this OK? See you. -- cram "Doug Robbins - Word MVP" wrote: Word does not have the ability to do that, but for sure it can be done with a Query in Access even if you had to resort to Left(fname, 2) & " " & Mid(fname, 3, 4) & "." & Mid(fname, 7, 3) & "." & Right(fname, 3) -- 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 "cram" wrote in message ... I want to format a string, coming from a access-query into my merged document. The value is BE012345679. I want to format as BE 0123.456.789 wich is in fact a belgian VAT nummer. Formating the string in the query does not help. Is there a "over-all-structure" for formatting this kind of strings? Thanks a lot -- cram |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
formatting mailmerge in word2003
Now you've got me wonderingG
I can't explain it. -- 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 "cram" wrote in message ... Indeed result is OK. But I wonder why (although not a women, still very curious...) something like this BE 01 12.4.56..789 when I activate the "cell" the presentation is normal as it should be: BE 0123.456.789 if you do'nt have a ready-made answer, forget it. It doesn't matter. Thanks anyway. You helped me a lot for this and some more "problems". -- cram "Doug Robbins - Word MVP" wrote: I am not sure what you mean by "a rather different presentation", but if the Word result is what you want, then what does it matter. -- 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 "cram" wrote in message ... Thanks Doug, this works. I tried before to use a format() in my query but it went wrong. What you propose is in fact quiet logic = make a "real" string... When i look in the result in my access query, i see a rather different presentation than the word result, is this OK? See you. -- cram "Doug Robbins - Word MVP" wrote: Word does not have the ability to do that, but for sure it can be done with a Query in Access even if you had to resort to Left(fname, 2) & " " & Mid(fname, 3, 4) & "." & Mid(fname, 7, 3) & "." & Right(fname, 3) -- 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 "cram" wrote in message ... I want to format a string, coming from a access-query into my merged document. The value is BE012345679. I want to format as BE 0123.456.789 wich is in fact a belgian VAT nummer. Formating the string in the query does not help. Is there a "over-all-structure" for formatting this kind of strings? Thanks a lot -- cram |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MailMerge WORD2003 - EXCEL2003 | Mailmerge | |||
| Mailmerge in Word2003 for Outlook Express 6 | Mailmerge | |||
| Formatting printers for Word2003. | New Users | |||
| Word2003 MailMerge: DataSource Access2003 (converted from Access97 | Mailmerge | |||
| Word97 documents change formatting in Word2003 | Microsoft Word Help | |||
Linear Mode
