Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-29-2013, 09:12 AM
bng bng is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
Novice
Mail merge custom labels with double mention of addresses
 
Join Date: May 2013
Posts: 4
bng is on a distinguished road
Default [SOLVED] Mail merge custom labels with double mention of addresses


Hello all,

I have a little problem with the Word 2010 mail merge. I want to print each address twice (next to each other, one for the document itself, one for the label to put on the letters). The background image is just for checking the layout, it is deleted when printed (can the image automatically be set not to print?).

The problem is that I can't find a way to enter each address twice using <<next record>><<address bloc>>. I can't get the counter to restart or I can't find a way to refer to record No. X.

An other problem I find is the tedious way of making the layout. I'd rather use text boxes which I would use to indicate the exacte spot, but for some weird reason Word doesn't seem to able to do this. I have tried working in two columns, with a small column on the right for the second address (not so in the attached file btw). Although that works, it is quite an archaic way of doing it. So if there is a better way, I'd love to hear about it.

Kind regards and thanks in advance for any help,

bng
Attached Files
File Type: xlsx Adress list.xlsx (8.9 KB, 7 views)
File Type: docx mail merge.docx (395.0 KB, 8 views)

Last edited by bng; 05-30-2013 at 04:57 AM.
Reply With Quote
  #2  
Old 05-30-2013, 12:41 AM
macropod's Avatar
macropod macropod is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
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 bng,

Simply restructure your field layout as:
«AddressBlock»
«AddressBlock»«Next Record»
«AddressBlock»
«AddressBlock»«Next Record»
«AddressBlock»
«AddressBlock»«Next Record»
«AddressBlock»
«AddressBlock»«Next Record»
«AddressBlock»
Note that the «Next Record» field only occurs after every second «AddressBlock» field.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-30-2013, 01:07 AM
bng bng is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
Novice
Mail merge custom labels with double mention of addresses
 
Join Date: May 2013
Posts: 4
bng is on a distinguished road
Default

Hello macropod,

Thanks for your reply. I have thought of that option too, but when I do it like that the duplicate addresses are under each other, instead of next to each other, even when I work in columns or use a table. Is there a way to get around that?

Thanks,
bng
Reply With Quote
  #4  
Old 05-30-2013, 01:10 AM
macropod's Avatar
macropod macropod is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
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

In that case, create a two-column table where you want the output to go, structured as:
|«AddressBlock»|«AddressBlock»«Next Record»|
|«AddressBlock»|«AddressBlock»«Next Record»|
|«AddressBlock»|«AddressBlock»«Next Record»|
|«AddressBlock»|«AddressBlock»«Next Record»|
|«AddressBlock»|«AddressBlock»«Next Record»|
where the | represent the cell boundaries.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-30-2013, 01:20 AM
bng bng is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
Novice
Mail merge custom labels with double mention of addresses
 
Join Date: May 2013
Posts: 4
bng is on a distinguished road
Default

The problem is that this results in the following output:

| A | B |
| A | C |
| B | C |

While what I need is:

| A | A |
| B | B |
| C | C |
Reply With Quote
  #6  
Old 05-30-2013, 01:45 AM
macropod's Avatar
macropod macropod is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
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

What kind of mailmerge are you doing? Using a label or directory merge, I get your second version. See attached (you will need to re-connect to your data source).
Attached Files
File Type: docx mail merge.docx (395.0 KB, 8 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-30-2013, 03:00 AM
bng bng is offline Mail merge custom labels with double mention of addresses Windows 7 32bit Mail merge custom labels with double mention of addresses Office 2010 32bit
Novice
Mail merge custom labels with double mention of addresses
 
Join Date: May 2013
Posts: 4
bng is on a distinguished road
Default

I am using label merge. I see the problem was that I wrote
|«AddressBlock»|«Next Record»«AddressBlock»|
instead of
|«AddressBlock»|«AddressBlock»«Next Record»|

Problem solved. Thank you very much for your help!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge is duplicating labels CathyLewis Mail Merge 4 05-26-2014 11:54 PM
Mail merge custom labels with double mention of addresses How to get mail merge to preview all addresses on labels rec Mail Merge 1 04-29-2011 10:32 PM
Mail Merge Adds Labels LRCote Mail Merge 1 10-05-2010 06:52 AM
Mail Merge - Labels borislibman Mail Merge 0 12-13-2009 07:24 PM
Labels Mail Merge borislibman Outlook 0 12-13-2009 07:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:39 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