vba - Excel VBS Mass Mailing Multiple Attachments -

i wrote vba script send emails arbitrary number of contacts excel file. excel file has column of email address's , attachment's, attachment's name of file attach email. want able add multiple attachments, separating each attachment ; in attachments column , making script go on add next attachment. trouble having don't know how without setting fixed number of attachments contacts. scenario trying capture is, 1 contact can have 3 attachments, 1 have 2 , 0 attachments.

you can split text in cell array, loop through array.

const delimiter = ";"  dim strcelltext string, strattachment string  dim strattachments() string  strcelltext = 'load cell text here  strattachments = split(strcelltext, delimiter)  each strattachment in strattachments    'attach attachment mail next