Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2017, 10:08 AM
tonysomerset tonysomerset is offline mm from Outlook to Labels Windows 10 mm from Outlook to Labels Office 2016
Novice
mm from Outlook to Labels
 
Join Date: Dec 2017
Posts: 5
tonysomerset is on a distinguished road
Unhappy mm from Outlook to Labels

Hi,
Set up my Outlook Contacts to show name and address then followed mm to print to a new labels document (Avery L7160). Used Mailing Fields Full_Name and Home_Address then updated and all labels populated. Here is where is start to go so wrong.
Problem 1 - select to omit country in label
Contact addresses correctly set to show Country/Region but mm within UK no need to Country! Tried to set Rule but ended up printing address plus 'Kingdom' on each label! Only solution to further split my Contact list into UK and non-UK.
Problem 2 - show correct name
Contract Outlook Names are shown with Last Name first (to keep same surnames together). However Merge Field Full_Name shows title, last name then first name then suffix! Solution, ignore the Full_Name filed and build up the name with the separate fields, title, firstname and so on.
Problem 3
Outlook Contacts Home (mailing) Address has a multiple line box for the Street field, followed by separate line fields for City, State, Postcode.
In UK we have many street addresses which require multiple lines ie House Name, Street Name, Hamlet before the next field, City, becomes relevant. So having abandoned Home_Addresses field (due to Problem 1) and built up the address Field by Field encounter the next problem. if the Street Field has more than one line the other lines to complete the street address are locked into a data field.
To fit within the label limits (and to make the address block presentable) I have had to change the paragraph setting to omit the 5.5pt space above setting. However the data field is locked.
Help 1 can anyone tell me how to how to override the datafield paragraph setting.
Problem 4
As an alternative Exported my Outlook Contacts to Excel. Interestingly it imports the Outlook Contact Field 'Street' as three Street Fields 1, 2 and 3 (as you would expect). Except only line 1 has any data the other two fields are blank, missing the necessary data to complete the address.
Help 2 can anyone tell me how to Export to Excel and retain the three Street Fields data.
Help 3 can anyone give me any pointers as to how to mm my Outlook Contacts on to Address Labels whilst retaining a useable printed name and address.


My head hurts and I cant think of another way around, surely MS has a working solution?
Reply With Quote
  #2  
Old 12-02-2017, 12:10 AM
gmayor's Avatar
gmayor gmayor is offline mm from Outlook to Labels Windows 10 mm from Outlook to Labels Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Don't use the AddressBlock field on your labels. This only really works for American address formats. Otherwise it is a pain to set up'. It is much better always to use the fields you require. See
http://www.gmayor.com/merge_labels_with_word_2007.htm which covers all you need to know about merging labels.


If you start the merge from Outlook - http://www.gmayor.com/mailmerge_from_outlook.htm one of the fields that is provided is the mailing address field. This has the country included when different from that in the regional settings and is the logical field to use for labels.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 12-02-2017, 05:08 AM
tonysomerset tonysomerset is offline mm from Outlook to Labels Windows 10 mm from Outlook to Labels Office 2016
Novice
mm from Outlook to Labels
 
Join Date: Dec 2017
Posts: 5
tonysomerset is on a distinguished road
Default ah but

Thanks Graham
Building up the address block as in my Problem 3 does not remove the issue of the multiple lines of Home-Street field. However I see your link that refers to Modify the 'Normal' style to remove the paragraph space padding. I'll give that a go.
Reply With Quote
  #4  
Old 12-02-2017, 06:47 AM
tonysomerset tonysomerset is offline mm from Outlook to Labels Windows 10 mm from Outlook to Labels Office 2016
Novice
mm from Outlook to Labels
 
Join Date: Dec 2017
Posts: 5
tonysomerset is on a distinguished road
Default sorted

Yeah, multiple Address_Street Field sorted!
Tip: change Font setting for Address_ City to All Caps, then comma then space then Address_Postcode.
For CountryRegion issue. Sort your data within MM to just United Kingdom so then leave out Address_CountryRegion.
I presume I will be able to sort data to Exclude United Kingdom and then add the Address_CountryRegion for non UK addresses. We shall we.
Reply With Quote
  #5  
Old 12-04-2017, 05:09 AM
tonysomerset tonysomerset is offline mm from Outlook to Labels Windows 10 mm from Outlook to Labels Office 2016
Novice
mm from Outlook to Labels
 
Join Date: Dec 2017
Posts: 5
tonysomerset is on a distinguished road
Angry from bad to worse

Thought I had the issues sorted, preview look okay. Went to finalise merge to new document and lost all the label table settings!
I see that on choosing labels start up in compatibility mode. So started anew, converted file. Repeated all previous steps to set fields and manage line spacing's.
Except MM didn't find Home_Address_PostCode. Had to use ZipPostCode. Probably need to match Home Postcode to the Zip field?
Everything looking fine in preview. Finalise Merge to new document and suddenly all the line spacings change despite my careful settings, suddenly 8pt are added below to the street field where there are multiple line!
Still cannot get the sheet to print within the Avery Label boxes!!
Is the answer to avoid all MS assistance and just type straight into the Avery Label template??!!
Reply With Quote
  #6  
Old 12-04-2017, 08:57 AM
tonysomerset tonysomerset is offline mm from Outlook to Labels Windows 10 mm from Outlook to Labels Office 2016
Novice
mm from Outlook to Labels
 
Join Date: Dec 2017
Posts: 5
tonysomerset is on a distinguished road
Unhappy and finally

After four days of effort, Ive got there! Thanks a bundle MS for making an easy task to incredibly challenging.
Download the label template direct from Avery. Save and open as a .doc. Convert to a .docx, save and open as new. Start MailMerge, select Labels, find your label type and then CANCEL, this will initiate the MM wizard. Find your Outlook data. I had selected and saved mine in a new folder under the full contact set. Add the Fields as above, Format the Fields as above, check the Preview then Final Merge with Edit to New Document. Make any individual adjustments for line length. Double check, triple check every Printer setting, in the document and every printer setting option as MS will keep setting back to Letter, override paper source and make sure to uncheck Auto adjust sizing for large documents and Normal Size is selected.
Good Luck!
Reply With Quote
Reply

Tags
address blocks, contact, labels

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mm from Outlook to Labels Mailing labels weamish Mail Merge 11 12-16-2011 05:18 AM
seeing labels msola1 Word 5 11-28-2010 03:03 PM
mm from Outlook to Labels Labels? Sarah O Word 2 11-12-2010 11:53 PM
39 labels in Word vishorizons Word 0 09-22-2010 01:10 PM
Envelopes and labels slaramie Word 0 07-31-2009 07:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft