View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Vikram Vikram is offline
external usenet poster
 
Posts: 11
Default Auto email from excel with custom subject

Hi Ron

I used your code above. I changed the lable & textbox name to suit my
userform. For some reason my subject and body of the email is coming
blank. If I have just one default subject and body then it works fine,
but doesnt allow me to pick current details from userform fields.

any suggestions?? I have referenced Outlook Object library. Is there
anything else I need to do in the set up of the worksheet/workbook?

cheers