Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2019, 02:15 AM
ajh19742000 ajh19742000 is offline Code for displaying UK postcodes correctly Windows 10 Code for displaying UK postcodes correctly Office 2013
Novice
Code for displaying UK postcodes correctly
 
Join Date: Dec 2015
Posts: 10
ajh19742000 is on a distinguished road
Default Code for displaying UK postcodes correctly


Hello,
I am performing mail merges with letters and labels however our enquirers dont always use the correct way of submitting their postcodes for example PL47BJ or CH345TY. Is there a code within the mail merge field I can use to ensure the correct spacing is used to display these postcodes correctly? For example PL4 7BJ or CH34 5TY?
Thanks
Reply With Quote
  #2  
Old 01-08-2019, 01:29 PM
macropod's Avatar
macropod macropod is offline Code for displaying UK postcodes correctly Windows 7 64bit Code for displaying UK postcodes correctly Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

No, there is no field coding for that - if the data have been poorly formatted on input into your data source, that's how the mailmerge will output them.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Heading not displaying correctly lucasar Word 1 06-03-2016 03:45 PM
Emails not displaying correctly in Outlook 2002 bacoms Outlook 0 02-26-2015 07:51 AM
Table of contents not displaying correctly while print preview sumayya.shaikh Word 5 01-05-2015 02:52 AM
Code for displaying UK postcodes correctly Identifying Postcodes. Chayes Word VBA 13 09-21-2013 06:29 AM
Why is the TOC displaying as a code? ponomariov Word 1 09-28-2012 03:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


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