Adding Two Excel Screenshots to Outlook with a Line Break in-between

Dear all,

I am copying a range of cells (These range of cells varies). from Excel and copying it to email outlook as a daily routine. Currently, the range of cells is too long and i have to manually split them into 2 images and resize them accordingly. Otherwise, the image will be shrunk and too small for anybody to read.


I am trying to copy them twice (instead of one whole chunk), but the second image (using .GetInspector.WordEditor.Range(0,2).Paste) turns out to be on the right side of the first image rather than below.
How can I add a link break in-between?

I also understand that if I save the pictures and then embed it (like most folks would do), rather than .CopyPicture, I HAVE to attach them. Is this true?
Thank you.

Please Login or Register  to view this content.