View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tammy[_2_] Tammy[_2_] is offline
external usenet poster
 
Posts: 1
Default Setting the Send to Value xlDialogSendMail

I have recorded a marco for a command button on my form
that will do a file send to mail recipient (as
attachment) when clicked but I want to also assign the
address that the form will be emailed to as a default but
when I try recorded this in the macro it doesn't except
it. How do I assign the send to value? Help.
Thanks
Tammy