Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
Merging from excel, field is set for zip in excel, dropping the first zero
when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
See: http://www.gmayor.com/formatting_word_fields.htm
"Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
Thanks but isn't there an easy way, I mean it's a pretty basic thing, why
should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I don't recall this happening to me in the past and I didn't expect to have to write code to fix it "Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
Thanks but isn't there an easy way,
There are only really three types of "easy" approach to fixing this: a. change the way Word connects to Excel to DDE (I can't remember if Graham covers that on the page you looked at, but you need to check Word Tools|Options|General|"Confirm conversion at open" and reconnect to your sheet. DDE is the way Word used to work by default in version 2000 and earlier) b. if you have fewer than around 63 columns, copy/paste from Excel to Word and use the Word document as the data source c. use switches in the fields. I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I agree with you, but unfortunately that's the way it is now. Peter Jamieson "Mary jane" wrote in message ... Thanks but isn't there an easy way, I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I don't recall this happening to me in the past and I didn't expect to have to write code to fix it "Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
Thanks Peter, I'll try these ways. Frankly in this case there was only 61
recipients so I just edited manually, but I would like to know for larger groups. "Peter Jamieson" wrote: Thanks but isn't there an easy way, There are only really three types of "easy" approach to fixing this: a. change the way Word connects to Excel to DDE (I can't remember if Graham covers that on the page you looked at, but you need to check Word Tools|Options|General|"Confirm conversion at open" and reconnect to your sheet. DDE is the way Word used to work by default in version 2000 and earlier) b. if you have fewer than around 63 columns, copy/paste from Excel to Word and use the Word document as the data source c. use switches in the fields. I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I agree with you, but unfortunately that's the way it is now. Peter Jamieson "Mary jane" wrote in message ... Thanks but isn't there an easy way, I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I don't recall this happening to me in the past and I didn't expect to have to write code to fix it "Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
DDE is covered in my web page -
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm however, the method suggested at http://www.gmayor.com/formatting_word_fields.htm is simpler. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Jamieson wrote: Thanks but isn't there an easy way, There are only really three types of "easy" approach to fixing this: a. change the way Word connects to Excel to DDE (I can't remember if Graham covers that on the page you looked at, but you need to check Word Tools|Options|General|"Confirm conversion at open" and reconnect to your sheet. DDE is the way Word used to work by default in version 2000 and earlier) b. if you have fewer than around 63 columns, copy/paste from Excel to Word and use the Word document as the data source c. use switches in the fields. I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I agree with you, but unfortunately that's the way it is now. Peter Jamieson "Mary jane" wrote in message ... Thanks but isn't there an easy way, I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I don't recall this happening to me in the past and I didn't expect to have to write code to fix it "Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
Hi Graham,
okay now I am determined. I did try {mergefield Zip\#"00000"} and I still lost the zero, what am I doing wrong? "Graham Mayor" wrote: DDE is covered in my web page - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm however, the method suggested at http://www.gmayor.com/formatting_word_fields.htm is simpler. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Jamieson wrote: Thanks but isn't there an easy way, There are only really three types of "easy" approach to fixing this: a. change the way Word connects to Excel to DDE (I can't remember if Graham covers that on the page you looked at, but you need to check Word Tools|Options|General|"Confirm conversion at open" and reconnect to your sheet. DDE is the way Word used to work by default in version 2000 and earlier) b. if you have fewer than around 63 columns, copy/paste from Excel to Word and use the Word document as the data source c. use switches in the fields. I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I agree with you, but unfortunately that's the way it is now. Peter Jamieson "Mary jane" wrote in message ... Thanks but isn't there an easy way, I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I don't recall this happening to me in the past and I didn't expect to have to write code to fix it "Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zero dropping from zip codes in word mail merge
Assuming you inserted the field correctly using CTRL+F9 for the field
boundaries (or toggled the original field to edit the content) then simply update the field (F9) and run the merge. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mary jane wrote: Hi Graham, okay now I am determined. I did try {mergefield Zip\#"00000"} and I still lost the zero, what am I doing wrong? "Graham Mayor" wrote: DDE is covered in my web page - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm however, the method suggested at http://www.gmayor.com/formatting_word_fields.htm is simpler. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Jamieson wrote: Thanks but isn't there an easy way, There are only really three types of "easy" approach to fixing this: a. change the way Word connects to Excel to DDE (I can't remember if Graham covers that on the page you looked at, but you need to check Word Tools|Options|General|"Confirm conversion at open" and reconnect to your sheet. DDE is the way Word used to work by default in version 2000 and earlier) b. if you have fewer than around 63 columns, copy/paste from Excel to Word and use the Word document as the data source c. use switches in the fields. I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I agree with you, but unfortunately that's the way it is now. Peter Jamieson "Mary jane" wrote in message ... Thanks but isn't there an easy way, I mean it's a pretty basic thing, why should I lose the zero from a zip code when creating envelopes and letters when the column is set for zip code in excel? I don't recall this happening to me in the past and I didn't expect to have to write code to fix it "Mary jane" wrote: Merging from excel, field is set for zip in excel, dropping the first zero when merging into letters and envelopes. How do I change the field attributes so word does not drop the zero in that field?? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
Pre-set Query Conditions that cannot be changed | Mailmerge | |||
WP merge file to Word | Tables |