When you set up labels, you set them up like this.
Firstname�� Lastname
Address1
Address2
City, State� PostalCode
All of those are mail merge fields.....EXCEPT the comma.
So when you print out 17 labels on your 30-label sheet, you get a comma on EVERY label in the sheet. This is annoying.
To get around this, add a field in your data source, like your spreadsheet, that's just a comma. Make a new column anywhere, call it Comma, and type a comma in every row or record.
Then instead of typing the comma, just insert the Comma field.
This
=IF(City>""; City & ", " & State & " " & PostalCode; "")
doesn't work?
Posted by: N Morrison | August 03, 2008 at 02:33 AM
I think the condition has to be in the field, not the original spreadsheet. But if that works for you, please let me know step by step how you do it.
Solveig
Posted by: Solveig | August 03, 2008 at 02:00 PM
Hi,
Our service is hack Yahoo, hack Hotmail, hack MSN, hack AOL,
hack Gmail, hack any email passwords for only $150 USD.
Please click to visit us: http://www.milanorosa.com . Only
5 minutes and get a great service, why dont give us a try?
Email me at [email protected] for password crack!!!!
You just email me the email id to find out. I will give you password
within just two days. I will contact you after cracking the target id.
I will give you some proofs (you can decide which proofs you want).
If you are well satisfied with the proofs you can reply me.
there is no chance of cheating because you dont need to send any
money until you are well satisfied with the proofs given you.
You can pay me after that in paypal, Ikobo western union... After
getting the money i will send you the password. Email me the id
at [email protected] . If you want to find your wouldbe's,
girlfriend's, boyfriend's, or any other friend's Yahoo, Hotmail, MSN,
Rediffmail, AOL, Sify...or any email password.
The best method is to hire our company to get it for you.
Easy way to hack, all at http://www.milanorosa.com
Thank you,
Milano Rosa, Inc.
Contact us if you need our service. Thank you for reading this email.
Hack Yahoo, hack Hotmail, hack MSN, hack AOL, hack Gmail,.. for $150 USD.
We can hack hotmail, yahoo, gmail...within 2 days! [email protected]
Posted by: kinh | August 20, 2008 at 07:02 AM
Do you know facebook password hacking? This was a fantastic service from http://www.rayahari.com/hack-MySpace-passwords.php. So fast and they delivered exactly what they promised. I would definitely use them again. Thoroughly recommend. Thank for RayaHari.com extremely professional. Efficient and accurate service. I look forward to using your services again in the very near future. facebook hacking password You Can Do This In Five Minutes.
BTW, I found another website that can hack yahoo passwords and other one specialized in hack into hotmail passwords.
Diane Calhoun, Lincoln
England
Posted by: how to hack yahoo passwords | February 08, 2009 at 07:55 PM
http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.wowpowerleveling.me
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/
Posted by: wow power leveling | July 05, 2009 at 11:08 PM
123456
Posted by: k s | September 18, 2009 at 12:46 PM
Hello,
Have you Tried to Contact Hackers for Western Union and Money Gram Transfers and you were ripped.
The good Old Adage says:- Be Dogged because Persistence Succeeds
I do Western Union Transfers to any Receiving Country Worldwide.
I do a Minimumn of $1000 and a Maximum of $5000
I Sell the Western Union Bug for $350 (USD)
I sell USA and UK Bank Logins and make the transfers for you incase you dont know how to do it
Contact me if you are Interested in a Deal:-
Yahoo Chat ID:- justwubugger
Email:- [email protected]
Tel No:- +2348076049228
This is your Oppourtunity to get Rich.
Posted by: wu Bugger | December 15, 2009 at 04:29 AM