Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2015, 07:02 AM
gmayor's Avatar
gmayor gmayor is offline Envelope printing Windows 7 64bit Envelope printing Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
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 ofgmayor has much to be proud of
Default

This has nothing to do with macros. It's an autotext entry - there's no programming involved. Copy the text

{<PR_GIVEN_NAME> <PR_SURNAME>
}{<PR_COMPANY_NAME>


}{<PR_POSTAL_ADDRESS>}

to a blank document. Select it then press ALT+F3 give it the name AddressLayout (no spaces) and save it in the normal template. The insert address function will then use this format.
The only VBA programming is in the add-in which I suggested you might find useful and that is already done for you.
__________________
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
  #2  
Old 02-17-2015, 02:47 AM
sam2149 sam2149 is offline Envelope printing Windows 7 64bit Envelope printing Office 2010 32bit
Novice
Envelope printing
 
Join Date: Feb 2014
Posts: 13
sam2149 is on a distinguished road
Default

Thanks for all your advice it is much appreciated you taking the time and trouble to help me.

But as I said this only started as a little project to fill in some spare time but it has quickly developed into a major project and has started to do my head in.
I have found a way that suits what I need to do I have made a word document with the envelope size and style I wish to use and saved it as a document.

Then to print an address I start outlook 2010, select the record or record’s I wish to print, then go to mail merge, then select only selected records, then I need to select existing document with the envelope style I saved before, and then under merge option select envelope option and then print, this then prints the address just as I wanted, Job done.

There is one point I am not able to understand if I follow the above procedure it all works just fine I get the address printed as
Name
Address
Town
County
Post Code

But if first start Word 2010 then go to mailings, then select the create the single envelope option and pick an address from Outlook address book, the address is printed as below

Name
Address
Town, Post Code
County

As you can see the post code has jumped up 2 lines

I am not able to understand if I start a mail merge from word then import an address from outlook address book the post code is then on the same line as the town and not after the County line. But if I start outlook first then mail merge from outlook into word the address is printed ok ?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Envelope Printing shebewoman Word 6 03-06-2014 04:29 PM
Envelope printing Suddenly Envelope Addresses Printing in Reverse! Mendopaul Word 2 02-12-2014 02:47 PM
Envelope printing Envelope Printing is off target - need help please! mylan Word 2 10-24-2012 12:24 PM
Envelope printing Printing to Envelope Feeder rbrlaw Word 1 05-23-2011 11:38 AM
Envelope printing Envelope Printing Phil Misc 2 04-27-2010 11:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:12 AM.


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