-
1
- #1
Rexxx
MIS
- Oct 16, 2001
- 47
- 0
- 0
I am having some trouble coding VBA to email an Excel attachment.
My vba sub copies cells to an excel form then emails the form as an excel file which is working swell but when the email with attachment opens it will not allow me to paste my Excel email recipients address (grabbed from an Excel cell and pasted in clipboard) into the To field. I have a whole Excel column full of addresses that my vba is coded to save to the clipboard each time to paste in the To field. The macro always stops with the email and attachment open and To field blank.
There must be another way to do this. Help!
My vba sub copies cells to an excel form then emails the form as an excel file which is working swell but when the email with attachment opens it will not allow me to paste my Excel email recipients address (grabbed from an Excel cell and pasted in clipboard) into the To field. I have a whole Excel column full of addresses that my vba is coded to save to the clipboard each time to paste in the To field. The macro always stops with the email and attachment open and To field blank.
There must be another way to do this. Help!