I want to center-align an email I sent from excel range selection using VBA but I'm not sure where to put it in the code. Someone suggested me to just add a column to my range. Is there anyway I can put the code in VBA. Btw, I'm really new at this language (like just an hour ago). Here's my code, I got it from a microsoft page:
Sub Send_Range()
ActiveSheet.Range("D4:L23").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Item.To = "ABZ@123.com"
.Item.Subject = "REMINDER: HELLO TEST" & " " & Format(Now, "mmmm yyyy")
.Item.Send
End With
End Sub
A simple version of what Scott is referring to would be