Microsoft Office Forums Return Address mail merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2016, 09:30 AM
GeorgeLawshe GeorgeLawshe is offline Return Address mail merge Windows XP Return Address mail merge Office 2003
Novice
Return Address mail merge
 
Join Date: Mar 2010
Location: Forney, Texas
Posts: 9
GeorgeLawshe is on a distinguished road
Default Return Address mail merge


I want to send out 60 3 5/8" X 6 1/2" envelopes with the same mailing address, but with a different return address merged from a excel worksheet.
I am using Microsoft Office Word 2010.
Can I do this, if so how?

Thanks
George
Reply With Quote
  #2  
Old 06-03-2016, 09:44 AM
Charles Kenyon Charles Kenyon is offline Return Address mail merge Windows 8 Return Address mail merge Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,878
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

This is how I would do it:
  1. Create a new document.
  2. Format it as an envelope under page layout.
  3. Insert two borderless frames or text boxes, one for the return address and one for your delivery address.
  4. Type the primary address into the second text box.
  5. Under the Mailings Tab, Start Mail Merge, pick letters.
  6. Tell Word to use your current document as the main document.
  7. Attach your data source.
  8. Insert merge fields for your return address.
  9. Save your primary merge document.
  10. Try finishing the merge to edit documents so you can check how it looks.
  11. Finish the merge to your printer or print the document you just created.
Mail Merge

Word Mailmerge Tips & Tricks | Windows Secrets Lounge
Reply With Quote
  #3  
Old 06-03-2016, 11:04 AM
GeorgeLawshe GeorgeLawshe is offline Return Address mail merge Windows 7 64bit Return Address mail merge Office 2010 64bit
Novice
Return Address mail merge
 
Join Date: Mar 2010
Location: Forney, Texas
Posts: 9
GeorgeLawshe is on a distinguished road
Default

Thanks, this worked great. Had some challenges since the envelope I had was not a standard so I created a custom envelope.

Thanks for your help, it sure made it easier,.

George
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge in sections with address list patrickpetersen Mail Merge 1 02-18-2015 10:57 PM
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Return Address mail merge mail merge address list disappeared janm Mail Merge 1 08-06-2012 11:41 PM
Mail merge and address book CDTom Mail Merge 0 01-17-2012 09:08 AM
Artwork with return address & mail merge labels slalemand Office 0 11-11-2010 12:10 PM


All times are GMT -7. The time now is 04:00 AM.


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