I’m working on a script to insert a few lines of text into a new outlook email, then a couple blank lines, then a selection from excel.
I can do either or correctly. That is, paste the text, or paste the selection.
But trying to do both and not have the table obliterate the previously pasted text, or have the selection pasted in as a bunch of . System.__ComObject lines is proving tricky. set-clipboard and get-clipboard work very, very poorly with excel.
Ideally I’d paste the leading text. Then get the selection from excel. Then paste that in with one or two blank lines between it and the leading text, and then have the signature show up correctly.