Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Add-ins for Outlook (http://www.outlookbanter.com/add-ins-outlook/)
-   -   Business Address: Format (http://www.outlookbanter.com/add-ins-outlook/80250-business-address-format.html)

J.R. Winder October 14th 08 05:54 PM

Business Address: Format
 
My dev group has developed and addin for Outlook 07 that enables 'Contact'
fields to be merged into MS Word 07 templates. The addin works fine however
the second line within the 'Business Address' field is including a leading
space when merging the field data into the Word template.

This is an example of how the fields are setup in the Template:
FullName
CompanyName
BusinessAddressStreet
BusinessAddressCity, BusinessAddressState BusinessAddressPostalCode

....and this is an example of how the data looks once the fields are merged
into the Word doc:
John Doe
John Does Landscaping
55 Main Street
Unit 4
Portsmouth, NH 03801

To me the logical cause to the leading space is due to there being two
'street' address lines. However the available fields within Outlook
Contact's does not include an BusinessAddressStreet1 and/or
BusinessAddressStreet2

Any thoughts on how to eliminate the leading space?

Thanks
JR


Ken Slovak - [MVP - Outlook] October 14th 08 06:21 PM

Business Address: Format
 
In cases like that there's a control character there usually as well as
possibly an actual space. You'd have to examine the text of the
BusinessAddressStreet property. You may find that you can't just blindly put
in the text from those properties but must do some text massaging to get
things the way you want them to look (or live with how they look now).

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"J.R. Winder" wrote in message
...
My dev group has developed and addin for Outlook 07 that enables 'Contact'
fields to be merged into MS Word 07 templates. The addin works fine
however the second line within the 'Business Address' field is including a
leading space when merging the field data into the Word template.

This is an example of how the fields are setup in the Template:
FullName
CompanyName
BusinessAddressStreet
BusinessAddressCity, BusinessAddressState BusinessAddressPostalCode

...and this is an example of how the data looks once the fields are merged
into the Word doc:
John Doe
John Does Landscaping
55 Main Street
Unit 4
Portsmouth, NH 03801

To me the logical cause to the leading space is due to there being two
'street' address lines. However the available fields within Outlook
Contact's does not include an BusinessAddressStreet1 and/or
BusinessAddressStreet2

Any thoughts on how to eliminate the leading space?

Thanks
JR



J.R. Winder October 14th 08 08:31 PM

Business Address: Format
 
Thanks Ken-
Do you know of anything I can do within the template that would eliminate
the control character and/or the actual space once the contact fields are
merged?

"Ken Slovak - [MVP - Outlook]" wrote in message
...
In cases like that there's a control character there usually as well as
possibly an actual space. You'd have to examine the text of the
BusinessAddressStreet property. You may find that you can't just blindly
put in the text from those properties but must do some text massaging to
get things the way you want them to look (or live with how they look now).

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"J.R. Winder" wrote in message
...
My dev group has developed and addin for Outlook 07 that enables
'Contact' fields to be merged into MS Word 07 templates. The addin works
fine however the second line within the 'Business Address' field is
including a leading space when merging the field data into the Word
template.

This is an example of how the fields are setup in the Template:
FullName
CompanyName
BusinessAddressStreet
BusinessAddressCity, BusinessAddressState
BusinessAddressPostalCode

...and this is an example of how the data looks once the fields are
merged into the Word doc:
John Doe
John Does Landscaping
55 Main Street
Unit 4
Portsmouth, NH 03801

To me the logical cause to the leading space is due to there being two
'street' address lines. However the available fields within Outlook
Contact's does not include an BusinessAddressStreet1 and/or
BusinessAddressStreet2

Any thoughts on how to eliminate the leading space?

Thanks
JR




Ken Slovak - [MVP - Outlook] October 14th 08 08:51 PM

Business Address: Format
 
Nothing that I know of just using a template, you'd have to write code for
that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"J.R. Winder" wrote in message
...
Thanks Ken-
Do you know of anything I can do within the template that would eliminate
the control character and/or the actual space once the contact fields are
merged?



J.R. Winder October 14th 08 09:10 PM

Business Address: Format
 
thanks. I'll get one my programmers to do just that.

JR

"Ken Slovak - [MVP - Outlook]" wrote in message
...
Nothing that I know of just using a template, you'd have to write code for
that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"J.R. Winder" wrote in message
...
Thanks Ken-
Do you know of anything I can do within the template that would eliminate
the control character and/or the actual space once the contact fields are
merged?





All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com