A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mailmerge labels line spacing



 
 
Thread Tools Display Modes
  #11  
Old December 13th, 2008, 04:33 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default mailmerge labels line spacing

Actually, it was your naming the macro
Normal.NewMacros.MailMergePropogateLabel that introduced the spelling error.

However, to answer your question, if you copy the template into the
Word\Startup folder of the other machines, it will do its magic.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jsloan1223" wrote in message
...
Hey Doug, I think Peter is correct, but since I copied the code from the
first message, it doesn't really make any difference, and I already had
that
part correct. (for the untrained eyes: there is a misspelling a vs o in
the
second msg from Doug, but it is correct in the first message taht lists
the
code)

Can I just copy over my labelmacro.docm to other machines and voila it
magically works?

Jocelyn


"Doug Robbins - Word MVP" wrote:

IF the name of the macro is Sub MailMergePropogateLabel(), it will run
automatically when you take the Propogate Label or Update Labels step of
setting up a label type mail merge main document. You do not need to add
it
to a toolbar.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jsloan1223" wrote in message
...
okay maybe I don't know what I"m doing. I created a new template called
labelmacro.dotm and saved it in the startup folder as directed. I have
the
macro available to me, and I have added it to my toolbar, but it does
not
automatically apply itself to mailmerge labels.

Originally when I created the macro, it named it as
Normal.NewMacros.MailMergePropogateLabel

Where did I do something wrong? (and how do I fix it?)

Jocelyn


"Doug Robbins - Word MVP" wrote:

Assuming that you have the macro in a template (.dotm) other than the
Normal.dotm template, save it in C:\Documents and
Settings\Applications
Data\Micorosoft\Word\Startup.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jsloan1223" wrote in message
...
I managed to get the macro created and saved, but I don't know how to
put
it
into a template that is saved in the word/startup folder. My
templates
are
stored in c:\docs and settings\username\application
data\microsoft\templates\*.dotm

Can I add it to the normal template (how?) so that it makes
everything
always single spaced? (I already change the default line spacing
when
I
first install office 2007 onto their machines. If I can just copy my
a
normal.dotm file onto their machines, that would be a fairly easy
workaround.)

Jocelyn Sloan, Network+
Technology Coordinator
Diocese of Fargo
www.fargodiocese.org

"Doug Robbins - Word MVP" wrote:

Use Shift+Enter instead of Enter to create each new line in the
label
content. Then the 5.5pt space before will only apply to the first
line
of
the label and99.9% of the time will not cause a problem.

Alternatively, put the following macro in a template that you save
in
the
Word\Startup folder and it will run when the user propagates the
label
setup, changing the spacebefore to 0 and also overcoming a problem
that
occurs if the user is using a Tablet PC or a PC that has "tablet
like"
functionality available.

snip








  #12  
Old February 21st, 2010, 04:14 PM posted to microsoft.public.word.mailmerge.fields
hjg
external usenet poster
 
Posts: 2
Default mailmerge labels line spacing



"jsloan1223" wrote:

Hi, does anyone know how to make word 2007 sp1 default to SINGLE SPACING
(with no extra spacing of any kind) on mailmerge labels?

Everytime I try a new labels mailmerge, it adds extra space between the
lines. I have 40 users who do not appreciate having to change the style every
time they create labels. I have actually been asked this question twice
before lunch today.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.