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.