VBA code to mail to multiple recipients/multiple attachments through Excel

[Fillonte]

Hi guys,

I have a macro to convert a sheet of my wb into pdf and email it. As long as it's one single sheet and one recipient for the mail, everything works great.

However I can't seem to be able to have the macro:

1) mail the file to multiple recipients;

2) attach to the email more than one file;

Is there a way to do it?

This is the code I'm using for the sending part of the macro

 MailFromMacWithMail bodycontent:="" & vbNewLine & vbNewLine & "", _
                            mailsubject:="", _
                            toaddress:="", _
                            ccaddress:="", _
                            bccaddress:="", _
                            attachment:=PDFfolder & PDFfileName & ".pdf", _
                            displaymail:=False

I can't manage to add more addresses or attachments no matter what I do (I have no background into coding whatsoever though).

I'm on a Mac using Mail, but if there's no other solution, I could try Outlook (even though I kinda hate it).

Thanks in advance for any help

 

[Fillonte]

Gonna try with a small bump.

Thanks anyway

 

[Fillonte]

I've tried to add

 Dim myaddress
myaddress = Array("address1@gmail.com", "address2@gmail.com")

and use "myaddress" in "toaddress" line of the mailing code, but I end up getting a"Byref argument type mismatch error".

I'm definitely lost on this.

 

[Fillonte]

Anyone with any insight on the issue today?

I'm still totally stuck here and I really need to finish this project.

Thanks in advance