Forum Discussion

katrina bethea's avatar
katrina bethea
Brass Contributor
Mar 26, 2019
Solved

vba sending email w/ attachment

long bit of code and im sure you all don't need all of it but its here for reference. The email portion works fine when under strBody i have text or a range with "". the problem im having is with get...
  • JKPieterse's avatar
    Mar 27, 2019
    You cannot add attachments by adding the path to the body, you need the .AddAttachment method:
    .AddAttachment "C:\Users\tabor\Documents\" & WBname & ".xlsx"

Resources