Content by Label Macro

[Martin Heinemann]

 Hello experts,

I want to create an alphabetical table of contents with the content by label macro. 

My idea was to create multiple label macros on one side for the content. One Macro for Sites who startswith A, one for Sites who starts with B, etc.

When I edit the label-macro, I can add a "with title " field.

What should I write in the title so that the Macro me only displays pages that begin with A.

sorry, english ist not my forte.

thanks for help

[Steffen Heller · Accepted solution]

My content by label macro doesn't have a "with title" field, so I don't know if we are talking about the same thing.

But generally, what you would have to do is

• create a page
• add different content by label macros for every letter of the alphabet
• go through all your pages and give them one of the letters as label

[Mei Ying Phuah]

Hi, can u show me an example on how to do that ?

[Steffen Heller]

Unfortunatelly, I don't have any example online.

[Mei Ying Phuah]

Is okay. However, do you have any idea that how can i extract the text in label by using excel vba?