At the moment I create quotations as a UserForm filled with data in an excel workbook which I attach to an email. This is rather a clumsy method which I hope to improve. I would like to be able to copy the UserForm straight into the body of the email.
I have discovered that the UserForm is invisible to most of the file types presented in the SaveAs routine of Excel. I had hoped that a PDF file would work. I can save the data that was in the UserForm in the PDF but, it seems, none of any extra images that are present. (I had tried replacing the form with a grid of inserted lines). They were not saved. I feel that there might well be a way to achieve my aim but have reached my limit. Can any one help please
John
Bookmarks