Mail merge problem Givvie 5/11/2006 10:49:01 AM I have inserted a field into a mail merge document and when I merge / view the document the numerical figure I have chosen ends up being a figure with many decimal points eg 720.234654 instead of 720 as it is in my data source (excel spread sheet) How do you get the figure to just be 720? I am using Word 2003 and excel 2003

Re: Mail merge problem "Graham Mayor" <gmayor[ at ]mvps.org> 5/11/2006 12:38:47 PM See http://www.gmayor.com/formatting_word_fields.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Givvie wrote: [Quoted Text] > I have inserted a field into a mail merge document and when I merge / > view the document the numerical figure I have chosen ends up being a > figure with many decimal points eg 720.234654 instead of 720 as it is > in my data source (excel spread sheet) > How do you get the figure to just be 720? > I am using Word 2003 and excel 2003

Re: Mail merge problem Givvie 5/11/2006 1:23:03 PM Thanx Graham - Although a little confusing to begin with I soon got the jist of it and managed to work it out from the info you supplied. cheeeeeeerrrrrssssss........;-) "Graham Mayor" wrote: [Quoted Text] > See http://www.gmayor.com/formatting_word_fields.htm > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Givvie wrote: > > I have inserted a field into a mail merge document and when I merge / > > view the document the numerical figure I have chosen ends up being a > > figure with many decimal points eg 720.234654 instead of 720 as it is > > in my data source (excel spread sheet) > > How do you get the figure to just be 720? > > I am using Word 2003 and excel 2003 > > >

Re: Mail merge problem Cindy M -WordMVP- <C.Meister-C[ at ]hispeed.ch> 5/11/2006 1:45:07 PM Hi =?Utf-8?B?R2l2dmll?=, [Quoted Text] > I have inserted a field into a mail merge document and when I merge / view > the document the numerical figure I have chosen ends up being a figure with > many decimal points eg 720.234654 instead of 720 as it is in my data source > (excel spread sheet) > How do you get the figure to just be 720? > I am using Word 2003 and excel 2003 > You have a number of choices. The "simplest" is probably to include a numerical formatting switch in the mail merge field code: 1. Alt+F9 to display the field codes 2. At the end of the field, type in the switch. Example: { Mergefield Total \# "0" $ 3. Alt+F9 again to hide the field codes. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)

Re: Mail merge problem Squeak 5/12/2006 6:38:01 PM Hello all... I too am trying to format an AMT filed and a SSN filed imported from EXCEL. where do I include the switch? this is my field: «OUTDENTALAMT____» "Cindy M -WordMVP-" wrote: [Quoted Text] > Hi =?Utf-8?B?R2l2dmll?=, > > > I have inserted a field into a mail merge document and when I merge / view > > the document the numerical figure I have chosen ends up being a figure with > > many decimal points eg 720.234654 instead of 720 as it is in my data source > > (excel spread sheet) > > How do you get the figure to just be 720? > > I am using Word 2003 and excel 2003 > > > You have a number of choices. The "simplest" is probably to include a > numerical formatting switch in the mail merge field code: > > 1. Alt+F9 to display the field codes > 2. At the end of the field, type in the switch. Example: > { Mergefield Total \# "0" $ > 3. Alt+F9 again to hide the field codes. > > Cindy Meister > INTER-Solutions, Switzerland > http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) > http://www.word.mvps.org > > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) > >

Re: Mail merge problem Squeak 5/12/2006 6:40:02 PM Hello all... I too am trying to format an AMT filed and a SSN filed imported from EXCEL. where do I include the switch? this is my field: «OUTDENTALAMT____» thanks for the help

Re: Mail merge problem "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/12/2006 9:24:16 PM Press Alt+F9 to toggle on the display of field codes and see "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at: http://www.gmayor.com/formatting_word_fields.htm -- 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 "Squeak" <Squeak[ at ]discussions.microsoft.com> wrote in message news:31FACBC2-FDC0-4337-9CA8-2183686EEAD1[ at ]microsoft.com... [Quoted Text] > > > Hello all... > > I too am trying to format an AMT filed and a SSN filed imported from > EXCEL. > where do I include the switch? > > this is my field: «OUTDENTALAMT____» > > > thanks for the help >

Re: Mail merge problem Christina 6/27/2006 10:07:02 PM I am a newbie and don't understand what you mean by saying to press ALT+F9 to display the field codes. Where do I do this in excel or word? "Cindy M -WordMVP-" wrote: [Quoted Text] > Hi =?Utf-8?B?R2l2dmll?=, > > > I have inserted a field into a mail merge document and when I merge / view > > the document the numerical figure I have chosen ends up being a figure with > > many decimal points eg 720.234654 instead of 720 as it is in my data source > > (excel spread sheet) > > How do you get the figure to just be 720? > > I am using Word 2003 and excel 2003 > > > You have a number of choices. The "simplest" is probably to include a > numerical formatting switch in the mail merge field code: > > 1. Alt+F9 to display the field codes > 2. At the end of the field, type in the switch. Example: > { Mergefield Total \# "0" $ > 3. Alt+F9 again to hide the field codes. > > Cindy Meister > INTER-Solutions, Switzerland > http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) > http://www.word.mvps.org > > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) > >

Re: Mail merge problem "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 6/28/2006 3:42:29 AM In Word. -- 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 "Christina" <Christina[ at ]discussions.microsoft.com> wrote in message news:9BBCDA6C-CF8A-4BBC-B93C-986BF895AC29[ at ]microsoft.com... [Quoted Text] >I am a newbie and don't understand what you mean by saying to press ALT+F9 >to > display the field codes. Where do I do this in excel or word? > > "Cindy M -WordMVP-" wrote: > >> Hi =?Utf-8?B?R2l2dmll?=, >> >> > I have inserted a field into a mail merge document and when I merge / >> > view >> > the document the numerical figure I have chosen ends up being a figure >> > with >> > many decimal points eg 720.234654 instead of 720 as it is in my data >> > source >> > (excel spread sheet) >> > How do you get the figure to just be 720? >> > I am using Word 2003 and excel 2003 >> > >> You have a number of choices. The "simplest" is probably to include a >> numerical formatting switch in the mail merge field code: >> >> 1. Alt+F9 to display the field codes >> 2. At the end of the field, type in the switch. Example: >> { Mergefield Total \# "0" $ >> 3. Alt+F9 again to hide the field codes. >> >> Cindy Meister >> INTER-Solutions, Switzerland >> http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) >> http://www.word.mvps.org >> >> This reply is posted in the Newsgroup; please post any follow question or >> reply in the newsgroup and not by e-mail :-) >> >>

Re: Mail merge problem hirendra7158 6/24/2007 2:57:00 AM SIr/Ma'am, I really do not know whether this si the right plateform or place to ask you my question, but encouraged by your reply I am tempted to ask you. Please pardon me and direct me toa right place if you find this place to be incorrect. but please please reply. After Mail merging, in Word 2003, names and data of 100 students, in to a small five line document that needs to posted to parents of each student, printing each of the Mail Merged document on a separate A4 sized sheet of paper is uneconomical. I am trying to print TWO merged documents on a single A4 sized sheet. How do I do it. PLease guide and oblige. thanks. I would be grateful if you will send me a copy of the reply to "hirendra7158[ at ]yahoo.co.in" also. Many thanks. "Cindy M -WordMVP-" wrote: [Quoted Text] > Hi =?Utf-8?B?R2l2dmll?=, > > > I have inserted a field into a mail merge document and when I merge / view > > the document the numerical figure I have chosen ends up being a figure with > > many decimal points eg 720.234654 instead of 720 as it is in my data source > > (excel spread sheet) > > How do you get the figure to just be 720? > > I am using Word 2003 and excel 2003 > > > You have a number of choices. The "simplest" is probably to include a > numerical formatting switch in the mail merge field code: > > 1. Alt+F9 to display the field codes > 2. At the end of the field, type in the switch. Example: > { Mergefield Total \# "0" $ > 3. Alt+F9 again to hide the field codes. > > Cindy Meister > INTER-Solutions, Switzerland > http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) > http://www.word.mvps.org > > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) > >