I have a form (sheet) that has ActiveX control check boxes, dependent drop downs and fill in cells. I have tried the CDO version of converting this and sending as HTML in gmail, however, the activeX controls do not convert nor does the outline formatting. I really want to have VBA script to convert it to a PDF and attach in an email via gmail automatically, but I haven't been able to figure it out. Is it possible? If so, please guide me. If not, would using Form controls work instead? Any other better ideas??
Below is my current code:
Thanks for any help!![]()
Please Login or Register to view this content.
Bookmarks