Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailing Address merge field has space between street and city
I am using Word and OL 2007.
When I use "mailing address" as a merge field, it pulls the correct info into my letter, but has what looks to be about a 6 pt blank space between street address and then c/s/z. When I highight the offending section and look under page layout, the "spacing after" is blank. When I hit the down arrow, it reverts to 0, and the spacing is now correct. I then save the document and then re-run the merge, but the space comes back. What am I missing? Brian |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailing Address merge field has space between street and city
It seems like you might be using the AddressBlock and that one of the fields
that it is using from the data source does not contain any data. Instead of using the AddressBlock, just insert the individual mergefields in the configuration that you want them. -- 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 "bsharp" wrote in message news I am using Word and OL 2007. When I use "mailing address" as a merge field, it pulls the correct info into my letter, but has what looks to be about a 6 pt blank space between street address and then c/s/z. When I highight the offending section and look under page layout, the "spacing after" is blank. When I hit the down arrow, it reverts to 0, and the spacing is now correct. I then save the document and then re-run the merge, but the space comes back. What am I missing? Brian |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailing Address merge field has space between street and city
Thanks.
Is "address 1" always the mailing address? By the way, I may want to take you up on some consulting services. Can you provide info on how that works, fees, etc? Brian "Doug Robbins - Word MVP" wrote: It seems like you might be using the AddressBlock and that one of the fields that it is using from the data source does not contain any data. Instead of using the AddressBlock, just insert the individual mergefields in the configuration that you want them. -- 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 "bsharp" wrote in message news I am using Word and OL 2007. When I use "mailing address" as a merge field, it pulls the correct info into my letter, but has what looks to be about a 6 pt blank space between street address and then c/s/z. When I highight the offending section and look under page layout, the "spacing after" is blank. When I hit the down arrow, it reverts to 0, and the spacing is now correct. I then save the document and then re-run the merge, but the space comes back. What am I missing? Brian |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge a label mailing and include my return address? | Mailmerge | |||
mail merge is putting extra space in between city and state | Mailmerge | |||
FULLNAME merge field: how do I get it to just show the first name, i.e. everything before the space and nothing after the space. | Mailmerge | |||
mail merge using only the "this is the mailing address" field? | Mailmerge | |||
return address label City state will not print | Microsoft Word Help |