Office & Productivity Software forum

General discussion

Word '03 Mail Merge

by 3n8rgr8 / January 10, 2007 3:40 AM PST

Is there any way to use the mail merge to create one whole sheet of mailing labels PER NAME?

Discussion is locked
You are posting a reply to: Word '03 Mail Merge
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Word '03 Mail Merge
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Yes, there is.
by Kees Bakker / January 10, 2007 7:18 AM PST
In reply to: Word '03 Mail Merge

All you've got to do is put as many identical lines in the data source as there are labels on a page. Personally, I would use MS-Access, and then an inner join between the data table and a table with the exact number of records in it (contents don't matter). You get a socalled 'cartesian product' and that's exactly what you want in this special case (most of the time cartesian products in a relational system are an error).

Doing it in Excel takes a little bit more work, although it can easily be automated in a macro: repeat (copy the data, paste after the end) enough times, then sort on the identification.

Hope this helps.


Kees

Collapse -
Have a Read
by darbhc / January 10, 2007 8:27 AM PST
In reply to: Yes, there is.

I feel from your enquiry you are trying to print out group
list of your friends/business associates on address labels so you can attach to envelopes?
If so have a look at Microsoft Web Site of
http://support.microsoft.com/kb/826838

If you require further personal assistace let me know hcdarbs hotmail.com [insert @ between]
Hope may help?

Collapse -
Or ...
by Kees Bakker / January 10, 2007 7:23 AM PST
In reply to: Word '03 Mail Merge

use the experience of a member wanting just the opposite: http://forums.cnet.com/5208-6129_102-0.html?forumID=29&threadID=225761&messageID=2359538

The idea: define a table where each cell has the exact dimensions of a label. Don't use labels, but merge to letters. Each letter is a page, and each page is the table, and every cell of the table is filled with exactly the same fields (that comes from the same record in the data source). It's a rather strange letter, but it's a perfect page with labels.

Choose between these two approaches.


Kees

Collapse -
Thanks
by 3n8rgr8 / January 10, 2007 8:50 PM PST
In reply to: Or ...

Thanks! I'll try these ideas.

Popular Forums

icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

FALL TV PREMIERES

Your favorite shows are back!

Don’t miss your dramas, sitcoms and reality shows. Find out when and where they’re airing!