AddressLayout Syntax (any)

Topic

New Reply

I posted in the Word forum here but got no response.

Did I strike out because I used the word “code” ??

If so, then this is the right place. Could my fellow coders check this
out and see if you can decifer for me.

Reply | Quote

Replies

Kevin:
The braces and vertical bar indicate a mandatory choice VBA must make between the items listed inside the braces. In your case you have given VBA two choices to review, the items left of the vertical bar and the items right of the vertical bar.
So in your code there are three items left of the vertical bar PR_Company Name PR_Street Address PR_Locality on the right side you have only two PR_Street Address PR_Locality .
As you can see the only difference between the choices is the company name element.
In other words a left choice by VBA produces 3 lines a right choice produces 2 line.
To you it seems like an if / then type statement is being performed when VBA is using the Option Statement Syntax to get the job done.

As for the other items in your code (outside) the braces they are mandatory and will always generate data from the address book both before and after the code in braces.

Hope this helps.

Reply | Quote

This is interesting. Where did you learn this?

And what is “Option Statement Syntax”?

Reply | Quote

Ya’ll see the Word Post in the thread of the same name for the solution!

Man, if feels good to have bagged this one…

Reply | Quote