NathanMowgli
New Member
- Joined
- May 26, 2022
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
Hi,
I have created some code via VBA that would copy a range (A1:Q120) within my excel worksheet (this worksheet is a dashboard, containing graphs and images) as a picture and then opens up an outlook email and pastes this image within the body of the email - and centers it, like a newsletter. Leaving me then to add any commentary and hit send.
However, whilst the imagine quality that pastes into the email looks fine, when you send it the image goes blurry / poor-quality to receivers - in particular mainly the images, not the graphs.
Does anyone have any solutions to this? I will upload my code shortly.
I have created some code via VBA that would copy a range (A1:Q120) within my excel worksheet (this worksheet is a dashboard, containing graphs and images) as a picture and then opens up an outlook email and pastes this image within the body of the email - and centers it, like a newsletter. Leaving me then to add any commentary and hit send.
However, whilst the imagine quality that pastes into the email looks fine, when you send it the image goes blurry / poor-quality to receivers - in particular mainly the images, not the graphs.
Does anyone have any solutions to this? I will upload my code shortly.