|
|
Paper and Access. $45.91 AVERY WHITE LSR MAILING – 100 SHTS 3-1/3″ X 4″… |
|
|
Avery White Laser Mailing – 100 Shts 3-1/3 X 4 (Office Supply / Paper And Access.) $44.00 AVERY WHITE LASER MAILING – 100 SHTS 3-1/3″ X 4″. AVERY WHITE LSR MAILING – 100 SHTS 3-1/3″ X 4″ -… |
|
|
AVERY WHITE LSR MAILING 100 SHTS 3-1/3 X 4 $37.07 AVERY WHITE LSR MAILING 100 SHTS 3-1/3″ X 4″… |
|
|
Avery Shipping Labels for Laser Printers with TrueBlock Technology, 3.333 x 4 Inches, White, Box of 600 (5164) $43.49 Make Avery White Shipping Labels part of your daily routine. Make Avery White Shipping Labels part of your daily routine. They’re available in a variety of sizes to fit any package and are guaranteed to be jam free and smudge free. Just fill in a free template from avery.com with your shipping information and then print sheet after sheet of professional-looking permanent labels directly from your … |
|
|
Avery Removable 3-1/3 x 4 Inch White ID Labels 150 Pack (6464) $11.99 Create and print your own labels. Labels stick stay and remove easily. Label Size – text: 3 1/3 x 4 Label Color(s): White Border Color(s): N/A Design: N/A.Unit of Measure : Pack… |
|
|
Avery Products – Avery – Shipping Labels with TrueBlock Technology, 3-1/3 x 4, White, 600/Box – Sold As 1 Box – TrueBlockTM Technology completely covers everything underneath, so you can reuse mailing tubes, boxes and more. – Jam- and smudge-free guaranteed! – Smooth feed sheet edges prevent adhesive build-up that causes jams. – Quick-drying sheets prevent smudging. - $26.41 Avery – Shipping Labels with TrueBlock Technology, 3-1/3 x 4, White, 600/Box – Sold As 1 BoxTrueBlockTM Technology completely covers everything underneath, so you can reuse mailing tubes, boxes and more. Jam- and smudge-free guaranteed! Smooth feed sheet edges prevent adhesive build-up that causes jams. Quick-drying sheets prevent smudging. Label Size – text: 3 1/3 x 4; Label Color(s): White; Bord… |
Avery 5164!
Five Ideas to Personalize a Funeral Ceremony or Memorial
Avery 5164 Questions
How do I mail merge word 2007 onto word aver labels 5164?
I have a word document in 2 columns with names, adresses, city, company, postal code etc… some are for Canada some are for the USA.
I want to insert these addresses on to Avery 5164 address labels with our company address as a return label. How do I do this easily?
I have read about needing to have an sql database but how do I do that? Can I insert an address block in front of all the company names & than how do I get it to merge onto my word label sheet? tyvm for any help.
Among other assumptions, I’m assuming you have Word 2007, and that you have a significant number of names so that cut and pasting would be impractical. From what you described, the document could have been formatted a couple of different ways. When you say that the document has 2 columns, you can have actual columns, or things that look like columns, but are not really columns which I call pseudo columns. Pseudo columns are created like so:
Jack Frost [tab][tab][tab]Victor Frost
1 North Pole Way[tab][tab][tab]2 North Pole Way
North Pole, NJ 07601[tab][tab][tab]North Pole, NJ 07601
Bob Bright [tab][tab][tab]Maggie Moth
22 Ivan Ho Way[tab][tab][tab]393 Manlott Dr
Hackensack, NJ 07601[tab][tab][tab]San Juan, PR 00601
The [tab] represents a tab character. If you did it this way, it’s a bit messy but still workable. To fix it up you need to do a search and replace to convert all multiple tabs to single tabs so that your document will look like:
Jack Frost [tab]Victor Frost
1 North Pole Way[tab]2 North Pole Way
North Pole, NJ 07601[tab]North Pole, NJ 07601
Bob Bright[tab]Maggie Moth
22 Ivan Ho Way[tab]393 Manlott Dr
Hackensack, NJ 07601[tab]San Juan, PR 00601
Then select the whole document, and click on the “Insert” tab. Click on the “Table” icon and select “Convert Text to Table”. Make sure you have the “Paragraphs” radio button selected under the “Separate text at” section. Click OK, then you will have a table with two columns.
Next, you need to cut the second column, then paste it at the bottom of the first column. The result is that you will have two columns of data. Make sure you have a two blank cells as your last two cells in the first column. (Paste the cut column into the very last cell of the first column)
Ok, save the file as an Plain text. Make sure that you you have “MS-DOS” selected and “Insert line breaks” Selected, and “End lines with” “CR/LF” in the “File Conversion” popup window.
Ok, now open the text document in Word. You should have one column of names and addresses.
**actual column start point**
Now you have one column of names that you need to convert to a table. Do a search and replace. Replace all double paragraph marks (^p^p) with single manual page breaks (^m). Next, replace all single paragraph marks (^p) with tab (^t). Now replace all manual page breaks (^m) with manual line breaks (^l). You can now use the file as a merge file, or open the text file directly in Excel, save it as an Excel document and use it as the merge table.
Now I’ll hand it off to Microsoft for merging directions:
http://office.microsoft.com/en-us/help/ha010349201033.aspx
The process would be much the same if you had two true columns. But first you would make the document into 1 column, and just go to the spot I marked as **actual column start point**, and continue.
Ok, so it’s not so easy, but it is the easiest way to do it in my opinion.
If you need a template for the 5164, we’ve got a few to choose from at:
http://www.macolabels.com/ml-0600-templates.html
Our ML-0600 is comparable to the Avery 5164 shipping label.
