cparusso
02-17-2017, 09:07 AM
Hi,
At my job i have to write the same 5 or 6 emails very often and am trying to automate the process a little bit. I have created a pop-up window with several buttons (I have ony worked on one so far) that will hopefully be able to generate emails for me and include a chart taken from my excel spreadsheet.
Currently when I click the button it creates an email with the selected cells included in the body.
My primary issue with it right now is that when the cells are copied into the email they look quite obtuse, and when I select autofit they are made very tall, yet narrow and it is hard to read the contents.
My secondary issue with it right now is that the text gets pasted in at 12 pt. Times New Roman, when I would prefer to use 11 pt. Calibri.
I have attached the file that contains the macro I am working with. Is there any way to make this work correctly or is this a dead-end project?
Thank you,
cparusso
At my job i have to write the same 5 or 6 emails very often and am trying to automate the process a little bit. I have created a pop-up window with several buttons (I have ony worked on one so far) that will hopefully be able to generate emails for me and include a chart taken from my excel spreadsheet.
Currently when I click the button it creates an email with the selected cells included in the body.
My primary issue with it right now is that when the cells are copied into the email they look quite obtuse, and when I select autofit they are made very tall, yet narrow and it is hard to read the contents.
My secondary issue with it right now is that the text gets pasted in at 12 pt. Times New Roman, when I would prefer to use 11 pt. Calibri.
I have attached the file that contains the macro I am working with. Is there any way to make this work correctly or is this a dead-end project?
Thank you,
cparusso