|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
December 8th 08, 07:27 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Blank Line in Mail Merge Address Labels
Help please….I am getting a blank line in some of my address labels. I use
Outlook 2003 and have a defined view of Christmas Cards. I then use the Outlook merge facility and when prompted set up my labels in Word 2003. Next I configure an address block and propagate my addresses. However, when I merge to a new document all addresses with two lines in the street address field have a blank line between the street address and the city – see illustration below. Those labels which only have one line in the street field do not have a blank line. Haddon 8a Main Street Timbuktu All suggestions welcome 
|
|
#2
December 8th 08, 08:03 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
"BobRob" wrote in message
... Help please….I am getting a blank line in some of my address labels. I use Outlook 2003 and have a defined view of Christmas Cards. I then use the Outlook merge facility and when prompted set up my labels in Word 2003. Next I configure an address block and propagate my addresses. However, when I merge to a new document all addresses with two lines in the street address field have a blank line between the street address and the city – see illustration below. Those labels which only have one line in the street field do not have a blank line. Haddon 8a Main Street Timbuktu All suggestions welcome I had that - I found I had to edit the addresses in Outlook and put two address lines in the "Street" box as opposed to just the street. -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#3
December 8th 08, 08:37 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
|
|
#4
December 8th 08, 08:41 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
Gordon,
Thanks for your suggestion. However I do put two lines in the outlook street field. Using the example I enter in the street field Haddon 8a Main Street Any other suggestions? "Gordon" wrote: "BobRob" wrote in message ... Help please….I am getting a blank line in some of my address labels. I use Outlook 2003 and have a defined view of Christmas Cards. I then use the Outlook merge facility and when prompted set up my labels in Word 2003. Next I configure an address block and propagate my addresses. However, when I merge to a new document all addresses with two lines in the street address field have a blank line between the street address and the city – see illustration below. Those labels which only have one line in the street field do not have a blank line. Haddon 8a Main Street Timbuktu All suggestions welcome I had that - I found I had to edit the addresses in Outlook and put two address lines in the "Street" box as opposed to just the street. -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#5
December 8th 08, 08:46 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
"BobRob" wrote in message
... Gordon, Thanks for your suggestion. However I do put two lines in the outlook street field. Using the example I enter in the street field Haddon 8a Main Street Any other suggestions? "Gordon" wrote: "BobRob" wrote in message ... Help please….I am getting a blank line in some of my address labels. I use Outlook 2003 and have a defined view of Christmas Cards. I then use the Outlook merge facility and when prompted set up my labels in Word 2003. Next I configure an address block and propagate my addresses. However, when I merge to a new document all addresses with two lines in the street address field have a blank line between the street address and the city – see illustration below. Those labels which only have one line in the street field do not have a blank line. Haddon 8a Main Street Timbuktu I think you have to play with it - I think it depends on how many other lines are in the address - sorry, that's all I can think of. -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#6
December 8th 08, 09:57 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
You haven't constructed your merge properly. Do not use derived fields in a
merge. Use the individual address element fields and be sure you follow the conventions posted here in the "Insert Address" section: http://www.gmayor.com/Macrobutton.htm -- Russ Valentine [MVP-Outlook] "BobRob" wrote in message ... Gordon, Thanks for your suggestion. However I do put two lines in the outlook street field. Using the example I enter in the street field Haddon 8a Main Street Any other suggestions? "Gordon" wrote: "BobRob" wrote in message ... Help please….I am getting a blank line in some of my address labels. I use Outlook 2003 and have a defined view of Christmas Cards. I then use the Outlook merge facility and when prompted set up my labels in Word 2003. Next I configure an address block and propagate my addresses. However, when I merge to a new document all addresses with two lines in the street address field have a blank line between the street address and the city – see illustration below. Those labels which only have one line in the street field do not have a blank line. Haddon 8a Main Street Timbuktu All suggestions welcome I had that - I found I had to edit the addresses in Outlook and put two address lines in the "Street" box as opposed to just the street. -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#7
December 8th 08, 10:05 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
"Russ Valentine [MVP-Outlook]" wrote in message
... You haven't constructed your merge properly. Do not use derived fields in a merge. So the mailing address is a derived field? -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#8
December 8th 08, 10:42 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Blank Line in Mail Merge Address Labels
Yes. Outlook creates it from individual address elements according to the
option you have selected in "This is the Mailing Address" -- Russ Valentine [MVP-Outlook] "Gordon" wrote in message ... "Russ Valentine [MVP-Outlook]" wrote in message ... You haven't constructed your merge properly. Do not use derived fields in a merge. So the mailing address is a derived field? -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mail Merge Labels from Word 2007 | Peter G[_3_] | Outlook - Using Contacts | 1 | December 6th 08 03:38 PM |
| Mail Merge to create labels | shopbox | Outlook - Using Contacts | 1 | October 31st 06 08:55 PM |
| Outlook contact to Word Mail Merge result blank line before City, State, Zip | Randy | Outlook - Using Contacts | 6 | October 5th 06 01:37 AM |
| mail merge contacts to labels - addresses don't appear on labels? | robin | Outlook - Using Contacts | 1 | June 23rd 06 10:08 PM |
| How to add second page of labels in contacts mail merge? | Rons Bicycle Works | Outlook - Using Contacts | 1 | January 23rd 06 02:06 PM |
Hybrid Mode
