View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbjtc jbjtc is offline
external usenet poster
 
Posts: 17
Default Insert Senders Name into Message Body

I have a macro that sends an e-mail automatically.

Does anyone know of vba code to insert the senders name into the main
message body of the email being sent. Here is a snapshot of my code:

..To = "
.CC = ""
.BCC = ""
.Subject = "Req" & " " & Sourcewb.Name
.Body = "FYI"

' NEED SPACE HERE

' then "KIND REGARDS"

' then "SENDERS NAME HERE"

Any help would be much appreciated.
Thanks
--
jj