ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy the body of an existing email in new emails generated via Excel with VBA. (https://www.excelbanter.com/excel-programming/353943-copy-body-existing-email-new-emails-generated-via-excel-vba.html)

[email protected]

Copy the body of an existing email in new emails generated via Excel with VBA.
 
Good afternoon,

I need to copy the body of an existing email (with images and specific
formats) in an automatically generated email via Excel. If I do it
from one email to another, everything is fine, the format and images
are kept. When it comes to Excel, that's where I start to get issues.
When I use standard copy-paste functions in VBA, it doesn't keep the
original format. I see two potential problems: or I don't use the
appropriate paste method, or I don't use the right object to create
HTML emails. If some could help me on that, it would be very
appreciated...

Thanks!



All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com