IF Statement within OutApp in VBA

**danfleysher** · 12-13-2016, 11:29 AM

Hey guys,

Two questions but 1. is more important.

1. How do I include an IF statement within the .body of an outlook e-mail. Essentially I have 5 lines in my excel file and only want to include those items in my e-mail if they're included. In the text, it's IF(B4="","",B4) but when I include IF RANGE("B4").VALUE = "" THEN "" ELSE RANGE("B4").VALUE, it's giving me an error.

2. Is it possible to create a messagebox that says if RANGE("B4").VALUE = "" THEN (create box that says "TEXT")

Please Login or Register  to view this content.

**pjwhitfield** · 12-13-2016, 11:37 AM

I would put your IF statement before the With OutMail, create a String variable to hold your .Body text and add to it using the IFs. The just set .Body = YourTextString