Hello,We want insert some informations in the body of our message that reporting the name of the sender (we choose @Author), the company name, title, division…We are managing the body of our memo, but when we have tried to insert something like @author, we have the right result, but if we try to insert others fields like CompanyName, the result is nothing.
What is it wrong? It seems that the fields are empty. Any suggestions?
Thanks
Subject: Insert Company Name, Title, etc in a body message
@Author is a system message that returns the name of the author of the current document. CompanyName would have to be looked up from the NAB using an @DBLookup.
Subject: RE: Insert Company Name, Title, etc in a body message
Hello again, now we have this problem:
we are looking @Dblookup…the syntax is
@Dblookup(class : cache ; server : database ; view ; key ; field ; … )
our big problem is the view…which is the view that contains the right informations?
Our silly notes version is a mixt between english and italian, after we did the upgrade from v5 to v6…how can we find the rith name of the view?
thanks again
Subject: RE: Insert Company Name, Title, etc in a body message
It would be easier to create a view that does what you need. Name in the first column, company in the second. Sort on first column.
@DBLookup (“”:Nocache;“Server”:“names.nsf”;“MyNewView”;@Name([CN];@Author);2)
would then return the company name if it finds the author name in the first column.
Subject: RE: Insert Company Name, Title, etc in a body message
thank you very muchYou have solved our problem!!
Now it works fine
Subject: RE: Insert Company Name, Title, etc in a body message
You can also use @NameLookup([Exhaustive];“CompanyName”;@Author)
Play with @NameLookup a bit, it should be easier to work with and consume less resources than @DBLookup.
HTH,
Charles
Subject: RE: Insert Company Name, Title, etc in a body message
you should be carefull doing this, depending on how many users you have and the number of emails they are sending, you could really put a lot of stress on your server by doing a lookup each time someone creates a message.
Subject: RE: Insert Company Name, Title, etc in a body message
the solution works fine, but do you have a solution to my problem that has better performance?
Subject: RE: Insert Company Name, Title, etc in a body message
well without knowing exactly why you want to do it this way why don’t you just have employees use signatures?
Subject: RE: Insert Company Name, Title, etc in a body message
Signature is a good idea, but if We use signature We have some problems:
the user can accidently change the text.
who receives the mail can change the text.
We want personalize the font.
What can we do?
Is there a way to work around these problems?
thank you