Hi all,
I’m hoping that you can help me a predicament that I have.
I have built a DB for my sports club listing equipment andequipment on loan.
To cut a long story short, I have created a report from a querywhich I can e-mail using the e-mail address in a text box by a command buttonusing the macro EmailDatabaseObject.
See my macro design in the image below.
This works well but I sometimes need to e-mail the report tomore than one e-mail address but I am having a problem with the macro withregards to the ‘To’ field in the macro.
My question is how do I separate two e-mail address in themacro? I have tried , : ; / . but keep getting an invalid value message.
The only symbol that the macro will accept is & but thiswill not separate the addresses in Outlook. See below for Outlook image.
Can anyone help please.