Share via

How do you print Address 3 using the Address Block feature in Word 2007?

Anonymous
2010-02-10T20:52:28+00:00

I have a data set containing all the fields I would like to use iwth the Address Block feature in Word. Included in the data set are Address 1, Address 2, and Address 3 (along with name, city, state, post code, country). All fields are mapped correctly under Match Fields..., including Address 3

When I preview the results or do a final merge, Address 3 will not print. How can I get Address 3 to print using the Address Block feature?

Using If..Then... statements is not an option for this situation. This is support of 50+ people that do not have the training (or time) to set up an If...then... statement each and every time letters and envelopes need to go out.

My specific question is how to enble the printing of Address 3 using the built-in functionality that Microsoft has provided. Not some workaround.

I am open to suggestions on how I could modify some of the default settings on each machine so that this can be accomplished. the point here  - again - is to use the built in feature provided by Microsoft for a one/two click process.

Thanks!

EDIT - I have come up with a minor solution on my own, which is to add the thrid line into the <<AddressBolck>> field (Ctrl+F9, add it in where I want it) and then save the selection as a seperate Building Block. Then adding the Quick Part to the Quick Access Toolbar you can get "one-click access". Not perfect, but works.

I would still like to get an answer on how to get the built in Address Block feature to print out Address 3.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2010-02-15T21:57:26+00:00

    You could save your desired configuration of mergefields as an autotext entry (myaddressblock) and then just insert that whenever you want to using it.


    Doug Robbins - Word MVP

    0 comments No comments

9 additional answers

Sort by: Most helpful
  1. Anonymous
    2013-01-13T21:52:13+00:00

    The advantages of using Address Block, besides its simplicity and automatic country formatting, also includes consistent appearance whether Title is present or not.  To be denied the option of a third line of address is extremely annoying, especially as the documentation on the Match Fields feature strongly suggests that it should be possible. 

    I am sure there are many like me who have wasted considerable time trying to get the additional line to print, in my case using Word 2003 and 2010. Please can Microsoft fix this irritating problem in what is otherwise a great product.

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2010-02-15T17:13:36+00:00

    I fail to see how "Address 3" is not "applicable for address block". While I certainly see that there are a host of additional fields that pop up in the field mapping section, it still seems rather ridiculous that the programming team and Microsoft decided to omit the third address line from an Address Block. This just seems stupid.

    Here is the pre-determined code that the developers created for the Address Block feature (default settings English language and United States region):

    {ADDRESSBLOCK\f"<<_FIRST0_>><<_LAST0_>><<_SUFFIX0_>>

    <<_COMPANY_

    >><<_STREET1_

    >><<_STREET2_

    >><<_CITY_>><<,_STATE_>><<_POSTAL_>><<

    _COUNTRY_>>"\l 1033 \c 2 \e "United States" \d}   <-- the modifiers may change based on your individual language and region settings

    It would be very easy to simply add _STREET3_ to the pre-determined set of mapped fields.

    I disagree with folks that say the Address Block is more headache than it is worth. It could be a very useful tool if it was implemented properly. As a data specialist, it makes my life much easier if I can deliver a standard set of fields for administrative staff to use. And as a support specialist, it is much easier to instruct users to use the big obvious "Address Block" button that is prominently displayed in the ribbon.

    As for your answer Doug, you seem to have missed the point. I am certainly very comfortable in working with individual merge fields. The problem becomes training dozens of other users - who may not necessarily have the skill set required to work with field mapping - to simply add in and address for letters and mailings.

    For instance, the Address Block does correctly handle the punctuation issues of the comma after city when mailing to North America (USA, Canada, Mexico all use the same City, State/Province format). the predetermined Address Block already inserts the comma after the city only if it is one of those countries. Otherwise it does not.

    To do this manually as you suggest, you need to insert and If..Then...Else... statement. And here there is no easy way to do this for "general office users". the Wizard only allows you to insert specific text, not merge fields. So you either:

    a) Alt+F9 and then Ctrl+F9 and write the whole thing out by hand

    b) Use the wizard to set it up (Field name: --> is not blank) and still have to Alt+F to modify the code.

        BTW - I did this by using {IF{MERGEFIELD State}<>"" "{MERGEFIELD City}," "{MERGEFIELD City}"}

    Most of you reading this will realize that it is not rocket science to figure that out. But again, the point is that for the majority of office workers who do not work with coding, that above is very intimidating to look at.

    Finally, I also realize the even with the addition of Address 3 as part of the standard Address Block, that some people would still not have all their addressing needs met. However, I go back to my original point where at least incorporate the field labeledaddress in theAddress Block.

    1 person found this answer helpful.
    0 comments No comments
  3. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2010-02-12T06:33:12+00:00

    The Address Block causes more problems than it is worth.  Just insert the individual merge fields that YOU want to use in the configuration that YOU want them.


    Doug Robbins - Word MVP

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2010-02-11T17:33:07+00:00

    Hi,

    Address blocks are set of pre-defined formats which cannot be modified. The fields which are under Required Fields for Address Block in the match field option are the ones that are used by the address block feature.

    The fields under Optional information are not applicable for address block. For choosing items under optional fields, you have to insert them manually using the Insert merge field option.


    Murali R, Microsoft Answers Support Engineer.

    • We appreciate your participation in MS Forums, Help us understand your needs better. To share your valuable Feedback please Click here.

    0 comments No comments