I am creating a macro that writes and sends emails based on information in an excel worksheet. I am using the following line to replace different placeholders in an outlook template: MyItem.HTMLBody = Replace(MyItem.HTMLBody, "PLACEHOLDER", FormatType(Range("J6"), 0)) I need to add a new line...