Incorrect order for macro to paste into new email

[SubwAy]

Hi all,

By combining several threads, I have the following macro to extract three ranges from a workbook and paste it as bitmap into a new email.

I have three issues that I can't seem to work around:

• the ranges are not pasted as bitmap (maybe as a picture or as an object) and they are not as clear as the bitmap option would give
• the text which I want the email to start with (Hi team, etc) appears first as the macro executes but the ranges/images are pasted before it instead of after
• inserting blanks or return to line between the ranges/images

Does anyone have any idea how to fix this?

Please Login or Register  to view this content.

Thanks in advance for your help.
S

[SubwAy]

Hi folks,

I believe I know why the ranges/pictures are being pasted prior to the text but cannot work out how to fix it.

Looking at how the email is getting built while the macro runs, the cursor stays at the beginning of the text selection rather than the end therefore everything pasted precedes the text. Can anyone think of a way to go around this?