Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2009, 05:17 AM
hiteshkataria hiteshkataria is offline Mail Merge Windows XP Mail Merge Office 2003
Novice
Mail Merge
 
Join Date: Nov 2009
Posts: 3
hiteshkataria is on a distinguished road
Default Mail Merge

Hi,



I am using the Mail Merge wizard to print the address lables. The source for the addresses is in MS Excel. The lablel product used is Avery 8460. It accomodate 3 x 10 (30) labels in a page.
I will be printing all the 30 addresses in a single page.
My requirement is to have a margin on each label of the sheet, so that it will be easy while cutting the sheet.

Can you please help in this.

Thanks.
Reply With Quote
  #2  
Old 11-05-2009, 05:53 PM
zyzzyva57 zyzzyva57 is offline Mail Merge Windows Vista Mail Merge Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

After your Excel is plugged into your labels, then highlight the page, go to Home tab> Paragraph group > click the small arrow in the lower right corner of this group, and set your left and right margins to what you want
Reply With Quote
  #3  
Old 11-06-2009, 02:55 AM
hiteshkataria hiteshkataria is offline Mail Merge Windows XP Mail Merge Office 2003
Novice
Mail Merge
 
Join Date: Nov 2009
Posts: 3
hiteshkataria is on a distinguished road
Default

Hi,

Thanks for the note!
I am not able to get what you are trying to convey - "go to Home tab"...
It would be good, if you can be specific or a screenshot would help.

Thanks.
Reply With Quote
  #4  
Old 11-06-2009, 04:12 AM
zyzzyva57 zyzzyva57 is offline Mail Merge Windows Vista Mail Merge Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

I would simply work with the paragraph settings once I got my Mail Merge basic stuff working
Attached Images
File Type: jpg 1.jpg (61.7 KB, 13 views)
Reply With Quote
  #5  
Old 11-06-2009, 05:11 AM
hiteshkataria hiteshkataria is offline Mail Merge Windows XP Mail Merge Office 2003
Novice
Mail Merge
 
Join Date: Nov 2009
Posts: 3
hiteshkataria is on a distinguished road
Default

Seems there is confusion.
I need to have small markings (like borders) on each label, as shown in the screenshot.
http://www.mediafire.com/file/nwgywfdbjni/Screen.JPG
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Problem JohnRG Mail Merge 0 11-02-2009 02:50 AM
Mail Merge mail merge Anthony Outlook 1 09-29-2009 06:09 PM
problem in Mail merge rjagathe Mail Merge 0 08-12-2009 08:25 AM
Mail Merge Mohanss82 Mail Merge 0 01-21-2009 12:29 PM
HELP! Mail Merge! I'm an idiot mtomto Mail Merge 0 02-15-2006 04:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 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