Compile Error: Expected: list separator or )

[Kirsti]

Hi,

I have a script to send Reports via e-mail. There are 2 different sets of reports, which are basically using the same module, modified to reflect the correct report names etc.

The first one is working perfectly.

The second one includes so many reports, that they do not fit in one line of VBA, therefore I have tried to break them down using space underscore, however I am getting "Compile Error: Expected: list separator or )". Any suggestions? here is the section of code that is throwing the error:

blnSuccessful = FnSafeSendEmail( _
"abc@xyz.com; def@xyz.com", _
"Statistical Reports", _
strHTML, _
"R:\VRS1 Report 1 - YTD.snp; _
R:\VRS2 Report 2 - Month.snp; _
R:\VRS3 Report 3 - YTD.snp; _
R:\VRS4 Report 4 - Month and YTD.snp;")
Thanks,

Kirsti

[aytee111]

You need opening and closing quotes and & on every line.

"R:\VRS1 Report 1 - YTD.snp; " & _
"R:\VRS2 Report 2 - Month.snp; " & _

etc

[Kirsti]

Thanks! That fixed it - who knew it would be so easy?!

Kirsti