Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Formatting Avery labels

brambles

Likes # 0

Posted February 4, 2012 at 5:05PM

I do a lot of mail merging to produce a file for printing off Avery labels which is fairly straightforward. However I do have a presentation problem because the name/address always starts in the top left hand corner of the label. Obviously it needs to be left aligned. I want the address to be away from the left edge and down from the top more. Anyone know how I can get the address central - not centre aligned.

Thanks

Brambles

Like this post
wiz-king

Likes # 0

Posted February 4, 2012 at 5:10PM

What program are you using to do the mail-merge?

Like this post
brambles

Likes # 0

Posted February 4, 2012 at 6:17PM

wiz king I am using Microsoft Word 2007 - I have no problems doing it only the aesthetics of the printed appearance I am not satisfied with.

Thanks for responding

Brambles

Like this post
Woolwell

Likes # 0

Posted February 4, 2012 at 6:33PM

On the first label, on the home tab on the ribbon you can use the normal word editing features to indent, centre, etc. To move it down a bit, highlight the first line only, choose paragraph and then increase the number pts in spacing before until you are satisfied. Remember after you have set up the first label to click on update labels.

Like this post
wiz-king

Likes # 0

Posted February 4, 2012 at 7:09PM

To move the whole labels text over a bit you can highlight the text then format > paragraph > indent all.( I am not sure if the exact wording - I dont use Office 2007 but have 2003 and they moved things about for 2007!)

Like this post
lotvic

Likes # 0

Posted February 4, 2012 at 10:57PM

Basically same as wiz-king

I'm also using Word 2003 and this is how I do it:

I go to Edit dropdown menu and choose 'Select All' or can put cursor inside one cell and Ctrl+A (hold down Crtl and press A on keyboard)

on Format Menu: click on 'Reveal Formatting' and a pane opens on the righthand side, at the bottom I tick the box for 'Show all formatting marks' so I can see where name & address will be in each label cell. (or can click on top toolbar icon that looks like a reversed letter P)

In the pane on the right and under 'Paragraph' I can click on 'Alignment' to alter it and also can click on 'Indentation' to alter the space between label edge and text.

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.