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 |