Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format mail merge fields?
I am using Excel & Word 2003. I have tried to format the merge fields in my
document without success. For example, I want the date to read 1 December 2007. After I press Alt+F9, my 'date' field is as follows : { MERGEFIELD "Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm yyy"} - but when I hit Alt+F9 again it doesn't change the format. What am I doing wrong? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format mail merge fields?
Hi Black Doctor,
The lower-case 'm's in your formatting switch are for minutes - months require 'M's. Try: { MERGEFIELD "Date1" \@ "d MMMM yyyy"} After pressing Alt-F9 to toggle the code display off, press F9 to update the displayed results. Cheers -- macropod [MVP - Microsoft Word] "Black Doctor" Black wrote in message ... | I am using Excel & Word 2003. I have tried to format the merge fields in my | document without success. For example, I want the date to read 1 December | 2007. After I press Alt+F9, my 'date' field is as follows : { MERGEFIELD | "Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm yyy"} - but | when I hit Alt+F9 again it doesn't change the format. What am I doing wrong? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format mail merge fields?
It still doesn't work. Now I get an error in the field saying : 'Error!
Unknown charater in picture string'. "macropod" wrote: Hi Black Doctor, The lower-case 'm's in your formatting switch are for minutes - months require 'M's. Try: { MERGEFIELD "Date1" \@ "d MMMM yyyy"} After pressing Alt-F9 to toggle the code display off, press F9 to update the displayed results. Cheers -- macropod [MVP - Microsoft Word] "Black Doctor" Black wrote in message ... | I am using Excel & Word 2003. I have tried to format the merge fields in my | document without success. For example, I want the date to read 1 December | 2007. After I press Alt+F9, my 'date' field is as follows : { MERGEFIELD | "Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm yyy"} - but | when I hit Alt+F9 again it doesn't change the format. What am I doing wrong? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format mail merge fields?
As the formatting switch is correct, the must be something wrong with the
data. What is displayed if you remove the formatting 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 "Black Doctor" wrote in message ... It still doesn't work. Now I get an error in the field saying : 'Error! Unknown charater in picture string'. "macropod" wrote: Hi Black Doctor, The lower-case 'm's in your formatting switch are for minutes - months require 'M's. Try: { MERGEFIELD "Date1" \@ "d MMMM yyyy"} After pressing Alt-F9 to toggle the code display off, press F9 to update the displayed results. Cheers -- macropod [MVP - Microsoft Word] "Black Doctor" Black wrote in message ... | I am using Excel & Word 2003. I have tried to format the merge fields in my | document without success. For example, I want the date to read 1 December | 2007. After I press Alt+F9, my 'date' field is as follows : { MERGEFIELD | "Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm yyy"} - but | when I hit Alt+F9 again it doesn't change the format. What am I doing wrong? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format mail merge fields?
Exactly what I have written : 'Error! Unknown character in picture string.'
This is the code : { MERGEFIELD "Date1" \@ "d MMMM yyy"} I still can't see where its going wrong. Cheers "Doug Robbins - Word MVP" wrote: As the formatting switch is correct, the must be something wrong with the data. What is displayed if you remove the formatting 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 "Black Doctor" wrote in message ... It still doesn't work. Now I get an error in the field saying : 'Error! Unknown charater in picture string'. "macropod" wrote: Hi Black Doctor, The lower-case 'm's in your formatting switch are for minutes - months require 'M's. Try: { MERGEFIELD "Date1" \@ "d MMMM yyyy"} After pressing Alt-F9 to toggle the code display off, press F9 to update the displayed results. Cheers -- macropod [MVP - Microsoft Word] "Black Doctor" Black wrote in message ... | I am using Excel & Word 2003. I have tried to format the merge fields in my | document without success. For example, I want the date to read 1 December | 2007. After I press Alt+F9, my 'date' field is as follows : { MERGEFIELD | "Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm yyy"} - but | when I hit Alt+F9 again it doesn't change the format. What am I doing wrong? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format mail merge fields?
Hi Black Doctor,
Check the number of 'y's.in your formatting switch. It's not the same as I posted. Cheers -- macropod [MVP - Microsoft Word] "Black Doctor" wrote in message ... | Exactly what I have written : 'Error! Unknown character in picture string.' | | This is the code : { MERGEFIELD "Date1" \@ "d MMMM yyy"} | | I still can't see where its going wrong. | | Cheers | | "Doug Robbins - Word MVP" wrote: | | As the formatting switch is correct, the must be something wrong with the | data. What is displayed if you remove the formatting 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 | | "Black Doctor" wrote in message | ... | It still doesn't work. Now I get an error in the field saying : 'Error! | Unknown charater in picture string'. | | "macropod" wrote: | | Hi Black Doctor, | | The lower-case 'm's in your formatting switch are for minutes - months | require 'M's. Try: | { MERGEFIELD "Date1" \@ "d MMMM yyyy"} | After pressing Alt-F9 to toggle the code display off, press F9 to update | the displayed results. | | Cheers | | -- | macropod | [MVP - Microsoft Word] | | | "Black Doctor" Black wrote in message | ... | | I am using Excel & Word 2003. I have tried to format the merge fields | in my | | document without success. For example, I want the date to read 1 | December | | 2007. After I press Alt+F9, my 'date' field is as follows : { | MERGEFIELD | | "Date1" } so I changed it to read { MERGEFIELD "Date1" \@ "d mmmm | yyy"} - but | | when I hit Alt+F9 again it doesn't change the format. What am I doing | wrong? | | | | | | |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using if fields in mail merge to ignore empty fields | Mailmerge | |||
Format a mail merge doc address 2 fields are needed insome ltrs | Mailmerge | |||
MS Word form fields versus mail merge fields | Mailmerge | |||
Form fields versus mail merge fields | Microsoft Word Help | |||
mail merge format fields | Mailmerge |