Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Phone number formatting
I'm doing a mail merge (creating letters) with data from an excel file. In
the excel file, one column is formatted as 'Special' and 'Phone number'. The data entered into that column was 10 digits and it shows in excel as phone number format - ie: (xxx) xxx-xxxx . This is how I need it. When I merge that field into the document, it comes across as xxxxxxxxxx (without the parenthesis and dashes). How can I fix it so that the phone numbers come across in the same format as they show in excel? Another issue (dunno if related or not...): When I do the merge, I get a small pop-up which I don't know what it's for... it's a small pop-up with an area where I can enter data (dunno what it's looking for) and there's an 'ok' and a 'cancel' button. Closing the pop-up (clicking the 'X') does not work... I have to hit 'ok' or 'cancel' exactly 100 times (note: the data source excel file contains exactly 50 records). What is this text entry pop-up looking for? How can I get it to stop? All help is greatly appreciated! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Phone number formatting
Note: I am running Office 2007.
"Merrick" wrote: I'm doing a mail merge (creating letters) with data from an excel file. In the excel file, one column is formatted as 'Special' and 'Phone number'. The data entered into that column was 10 digits and it shows in excel as phone number format - ie: (xxx) xxx-xxxx . This is how I need it. When I merge that field into the document, it comes across as xxxxxxxxxx (without the parenthesis and dashes). How can I fix it so that the phone numbers come across in the same format as they show in excel? Another issue (dunno if related or not...): When I do the merge, I get a small pop-up which I don't know what it's for... it's a small pop-up with an area where I can enter data (dunno what it's looking for) and there's an 'ok' and a 'cancel' button. Closing the pop-up (clicking the 'X') does not work... I have to hit 'ok' or 'cancel' exactly 100 times (note: the data source excel file contains exactly 50 records). What is this text entry pop-up looking for? How can I get it to stop? All help is greatly appreciated! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Phone number formatting
The phone number is easy enough. Toggle the display in your merge source
document (ALT+F9) and the field in question will look something like { Mergefield PhoneNumber } add a formatting switch to the field thus { Mergefield PhoneNumber \# "(000)' '000'-'0000" } See also http://www.gmayor.com/formatting_word_fields.htm Toggling the display may also reveal in your document an Ask field (or two) that is the probable cause of the mysterious prompt. You can get it to stop by either removing it (or them) - in which case there is likley to be an associated REF field which will then produce an error, or by using a switch to make it prompt only at the start of the merge, but it would be a good idea to locate the field(s) before deciding what to do with it. I take it that you didn't create this merge document? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Merrick wrote: I'm doing a mail merge (creating letters) with data from an excel file. In the excel file, one column is formatted as 'Special' and 'Phone number'. The data entered into that column was 10 digits and it shows in excel as phone number format - ie: (xxx) xxx-xxxx . This is how I need it. When I merge that field into the document, it comes across as xxxxxxxxxx (without the parenthesis and dashes). How can I fix it so that the phone numbers come across in the same format as they show in excel? Another issue (dunno if related or not...): When I do the merge, I get a small pop-up which I don't know what it's for... it's a small pop-up with an area where I can enter data (dunno what it's looking for) and there's an 'ok' and a 'cancel' button. Closing the pop-up (clicking the 'X') does not work... I have to hit 'ok' or 'cancel' exactly 100 times (note: the data source excel file contains exactly 50 records). What is this text entry pop-up looking for? How can I get it to stop? All help is greatly appreciated! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Phone number formatting
Graham, THANK YOU! the format of the fax numbers... now perfect with
your formatting fix. Ask field(s) - yes, there was one Ask field which I removed (I dunno how it got there, shouldn't be there, and yes- it was me that created the document. I now have to hit 'ok' or 'cancel' 50 times (50 record excel spreadsheet) and there are no more Ask fields. Can it be something else? Thanks sooo much! Merrick "Graham Mayor" wrote: The phone number is easy enough. Toggle the display in your merge source document (ALT+F9) and the field in question will look something like { Mergefield PhoneNumber } add a formatting switch to the field thus { Mergefield PhoneNumber \# "(000)' '000'-'0000" } See also http://www.gmayor.com/formatting_word_fields.htm Toggling the display may also reveal in your document an Ask field (or two) that is the probable cause of the mysterious prompt. You can get it to stop by either removing it (or them) - in which case there is likley to be an associated REF field which will then produce an error, or by using a switch to make it prompt only at the start of the merge, but it would be a good idea to locate the field(s) before deciding what to do with it. I take it that you didn't create this merge document? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Merrick wrote: I'm doing a mail merge (creating letters) with data from an excel file. In the excel file, one column is formatted as 'Special' and 'Phone number'. The data entered into that column was 10 digits and it shows in excel as phone number format - ie: (xxx) xxx-xxxx . This is how I need it. When I merge that field into the document, it comes across as xxxxxxxxxx (without the parenthesis and dashes). How can I fix it so that the phone numbers come across in the same format as they show in excel? Another issue (dunno if related or not...): When I do the merge, I get a small pop-up which I don't know what it's for... it's a small pop-up with an area where I can enter data (dunno what it's looking for) and there's an 'ok' and a 'cancel' button. Closing the pop-up (clicking the 'X') does not work... I have to hit 'ok' or 'cancel' exactly 100 times (note: the data source excel file contains exactly 50 records). What is this text entry pop-up looking for? How can I get it to stop? All help is greatly appreciated! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Phone number formatting
Wait... I got it! There's a 'fillin' field. Here's the line:
To: { MERGEFIELD DocTitle } {MERGEFIELD DocName }{SET docname {FILLIN } } Since the DocName is from the spreadsheet, can I safely just remove SET docname {FILLIN } ? "Merrick" wrote: Graham, THANK YOU! the format of the fax numbers... now perfect with your formatting fix. Ask field(s) - yes, there was one Ask field which I removed (I dunno how it got there, shouldn't be there, and yes- it was me that created the document. I now have to hit 'ok' or 'cancel' 50 times (50 record excel spreadsheet) and there are no more Ask fields. Can it be something else? Thanks sooo much! Merrick "Graham Mayor" wrote: The phone number is easy enough. Toggle the display in your merge source document (ALT+F9) and the field in question will look something like { Mergefield PhoneNumber } add a formatting switch to the field thus { Mergefield PhoneNumber \# "(000)' '000'-'0000" } See also http://www.gmayor.com/formatting_word_fields.htm Toggling the display may also reveal in your document an Ask field (or two) that is the probable cause of the mysterious prompt. You can get it to stop by either removing it (or them) - in which case there is likley to be an associated REF field which will then produce an error, or by using a switch to make it prompt only at the start of the merge, but it would be a good idea to locate the field(s) before deciding what to do with it. I take it that you didn't create this merge document? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Merrick wrote: I'm doing a mail merge (creating letters) with data from an excel file. In the excel file, one column is formatted as 'Special' and 'Phone number'. The data entered into that column was 10 digits and it shows in excel as phone number format - ie: (xxx) xxx-xxxx . This is how I need it. When I merge that field into the document, it comes across as xxxxxxxxxx (without the parenthesis and dashes). How can I fix it so that the phone numbers come across in the same format as they show in excel? Another issue (dunno if related or not...): When I do the merge, I get a small pop-up which I don't know what it's for... it's a small pop-up with an area where I can enter data (dunno what it's looking for) and there's an 'ok' and a 'cancel' button. Closing the pop-up (clicking the 'X') does not work... I have to hit 'ok' or 'cancel' exactly 100 times (note: the data source excel file contains exactly 50 records). What is this text entry pop-up looking for? How can I get it to stop? All help is greatly appreciated! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Phone number formatting
If you are not using the FILLIN field then yes it can be removed.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Merrick wrote: Wait... I got it! There's a 'fillin' field. Here's the line: To: { MERGEFIELD DocTitle } {MERGEFIELD DocName }{SET docname {FILLIN } } Since the DocName is from the spreadsheet, can I safely just remove SET docname {FILLIN } ? "Merrick" wrote: Graham, THANK YOU! the format of the fax numbers... now perfect with your formatting fix. Ask field(s) - yes, there was one Ask field which I removed (I dunno how it got there, shouldn't be there, and yes- it was me that created the document. I now have to hit 'ok' or 'cancel' 50 times (50 record excel spreadsheet) and there are no more Ask fields. Can it be something else? Thanks sooo much! Merrick "Graham Mayor" wrote: The phone number is easy enough. Toggle the display in your merge source document (ALT+F9) and the field in question will look something like { Mergefield PhoneNumber } add a formatting switch to the field thus { Mergefield PhoneNumber \# "(000)' '000'-'0000" } See also http://www.gmayor.com/formatting_word_fields.htm Toggling the display may also reveal in your document an Ask field (or two) that is the probable cause of the mysterious prompt. You can get it to stop by either removing it (or them) - in which case there is likley to be an associated REF field which will then produce an error, or by using a switch to make it prompt only at the start of the merge, but it would be a good idea to locate the field(s) before deciding what to do with it. I take it that you didn't create this merge document? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Merrick wrote: I'm doing a mail merge (creating letters) with data from an excel file. In the excel file, one column is formatted as 'Special' and 'Phone number'. The data entered into that column was 10 digits and it shows in excel as phone number format - ie: (xxx) xxx-xxxx . This is how I need it. When I merge that field into the document, it comes across as xxxxxxxxxx (without the parenthesis and dashes). How can I fix it so that the phone numbers come across in the same format as they show in excel? Another issue (dunno if related or not...): When I do the merge, I get a small pop-up which I don't know what it's for... it's a small pop-up with an area where I can enter data (dunno what it's looking for) and there's an 'ok' and a 'cancel' button. Closing the pop-up (clicking the 'X') does not work... I have to hit 'ok' or 'cancel' exactly 100 times (note: the data source excel file contains exactly 50 records). What is this text entry pop-up looking for? How can I get it to stop? All help is greatly appreciated! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I retain phone number formatting in a merged document? | Mailmerge | |||
phone directory with addresses and phone number from existing fi. | Mailmerge | |||
loss of phone number formatting when merged | Mailmerge | |||
Phone number field formating | Microsoft Word Help | |||
How do I set my phone and fax number in the fax wizard? | Microsoft Word Help |