ValueListItems Function

[chevell]

I've got a Value List created with a lookup value based on a self relationship. I can add a field with a popup menu set to that value list and it will pop up the required values. If i add the function to a calculation field with text output, its empty. Am I doing something wrong? Thanks!

[sbg2]

Example attached

EmailFiles.zip

[chevell]

Ok, thanks. I got that part down. I am just trying to get your example to work with the ValueListItems calculation. This way, I can embed the data into the message body. That would be the preferred method. Thanks so much for your help!

[sbg2]

Not sure what you are missing, my example uses the ValueListItems function within the Mail script. The data is embedded in the message body via a calculation.

[chevell]

Nevermind, i got it. Probably the space in the original filename. Renamed it with quotes and its working. Thanks!