Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2011, 04:19 PM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default Custom label size for merge

I need to merge from excel into word, but need a single list of addresses. I have not seen a label that allows me to do this, as all seem to be more than a single column. If I use form letters rather than labels I get the look I want but every name would be on a separate page. Is there a way to have my "labels" just be in one column on a page?
Reply With Quote
  #2  
Old 04-22-2011, 04:32 PM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dmwesq,

What you're describing sounds like a catalog/directory merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-22-2011, 04:33 PM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

Figured out how to make custom label - would have deleted this question if I could have - seems to let me edit but not delete - sorry.
Reply With Quote
  #4  
Old 04-22-2011, 04:54 PM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dmwesq,

If you figure out a solution before anyone replies, simply add a reply to your own thread saying so - preferably with something that says how you solve it - and mark the thread as solved.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 04-23-2011, 08:40 AM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi dmwesq,

What you're describing sounds like a catalog/directory merge.
Thanks Paul, that does indeed fit what I was looking for. Is there a way to suppress fields that are blank in any individual record? For example, I have a field in the merge for middle initial and for fax number. If a person has no MI or fax it puts spaces in that I would want removed in the merge.
Reply With Quote
  #6  
Old 04-23-2011, 01:55 PM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dmwesq,

You can suppress a paragraph break (or a line break) before or after an empty mergefield by doing the following:
select the mailmerge field to be suppressed (eg «MyData») and press Shift-F9 so that you get {MERGEFIELD MyData};
edit the field code so that you get {MERGEFIELD MyData \f ""} or {MERGEFIELD MyData \b ""}, depending on whether the line to be suppressed is following or before the mergefield;
move the paragraph break or line break to be suppressed into field code so that you end up with {MERGEFIELD MyData \f "¶
"} or {MERGEFIELD MyData \b "¶
"} (use a real paragraph break or line break in place of the '¶');
position the cursor anywhere in this field and press F9 to update it;
run your mailmerge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 04-23-2011, 06:53 PM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post

move the paragraph break or line break to be suppressed into field code so that you end up with {MERGEFIELD MyData \f "¶
"} or {MERGEFIELD MyData \b "¶
"} (use a real paragraph break or line break in place of the '¶');
Not quite sure I'm following this part - I don't see any breaks except for the line breaks - in between my fields I have spaces - here's my code when originally placed in Word

Quote:
«FirstName» «MI» «LastName» «Class» «Position»
«Organization»
«WorkAddress» «WorkAddress2»
«WorkCity», «WorkState» «WorkZip»
«WorkPhone» «Cell_Phone» «Email»
Reply With Quote
  #8  
Old 04-23-2011, 08:25 PM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dmwesq,

For your first line:
«FirstName» «MI» «LastName» «Class» «Position»
Select the «MI» field, press Shift-F9 to expose the code {MERGEFIELD MI} and change it to, say, {MERGEFIELD MI \b " "}, then press F9 again and delete the space between «FirstName» and «MI», so that you end up with:
«FirstName»«MI»

Your fax# field is missing, so I can't give specific instructions on that. If it's in-line with other fields, do something along the lines of the above; otherwise do as suggested in my first post.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 04-24-2011, 01:33 AM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

If I delete the space then the entries that do have a middle initial will now be missing a space between the first name and MI, so that won't do any good.

The "fax" field was accidentally pasted as the cell field, but I understand the same will apply to the other fields assuming I can get this to work at all.
Reply With Quote
  #10  
Old 04-24-2011, 02:00 AM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by dmwesq View Post
If I delete the space then the entries that do have a middle initial will now be missing a space between the first name and MI, so that won't do any good.
The \b and \f switches tell Word what to insert before/following the field if it isn't empty. So, if the MI field has anything in it, a space will be inserted!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 04-24-2011, 03:35 AM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

I think we are missing something in our dialog. Here is an example

John A. Smith
Bob Jones

Obviously my merge must have a field for first name, middle initial and last name. John A. Smith will work fine, unless I follow your example and after toggling the field to add the switch I delete the space in the merge fields, which will result in either JohnA. Smith or John A.Smith, neither of which is good.

If I don't delete the space then I end up with Smith appearing fine but will get Bob Jones, and in some cases I am even getting an extra space so it will read Bob Jones. Since this all needs to go to print I can't have multiple extra spaces. Maybe this is just something that is not possible to do?
Reply With Quote
  #12  
Old 04-24-2011, 06:02 AM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dmwesq,

Are you actually executing the merge, or only previewing it?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 04-24-2011, 10:00 AM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

Executing it.
Reply With Quote
  #14  
Old 04-24-2011, 02:36 PM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dmwesq,

The switch advice is taken straight from:
http://office.microsoft.com/en-us/wo...005186172.aspx
Although you'll see the switches expressed in capitals, the example shows usage with lower-case letters. You could try using capitals for the switch but that shouldn't make any difference.

If the \b & \f switches don't work on Macs, you'll need to use an IF field for the conditional paragraph breaks. For example:
«FirstName» «MI» «LastName» «Class» «Position»
«Organization»
«WorkAddress»{IF«WorkAddress2»<> "" "¶
«WorkAddress2»"}
«WorkCity», «WorkState» «WorkZip»
«WorkPhone» «Cell_Phone» «Email»

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
columns, labels, merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom label size for merge Label merge sulasno Mail Merge 2 03-16-2011 01:55 AM
Custom label size for merge Saving custom page size comptech Word 2 10-05-2010 06:01 AM
Custom caption label annoyance zac Word 1 08-29-2010 09:56 AM
unable to save custom label OldBlueEyes Word 0 05-07-2010 11:30 PM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:10 AM.


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