Hi Peder5000,
If I understand correctly, VBA is Microsoft visual basic for application?
Based on my research,you could not use e-mail/sms to achive it,but you could develop a desktop application by Lync 2013 SDK, including reading message sent to a Persistent Chat room, sending messages to a chat room, finding chat rooms, viewing a chat room
roster, filtering outgoing chat room messages, and extending chat room functionality with an add-in.
The following link for your reference.
https://msdn.microsoft.com/en-us/library/office/jj933070.aspx
Best Regards,
Leon-Lu
TechNet Community Support
Please remember to
mark the replies as answers if they help and
unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact
tnmff@microsoft.com