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
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
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
Code:
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