Passte pastes text as pic

[Peter Kinross]

Using Word 2010.
I have been using VBA to copy and paste text & pics that I use as my business signature. I have been using this for years and it has worked flawlessly. About a year or so ago I had to add a bit to the the signature. Ever since then the formatting of the paste has been so messed up, I have had to revert to pasting the whole thing as a pic. This doesn't reproduce wonderfully in emails, so I want to fix it, but can't. The only way I can get the sig to paste as text with pictures (hand written signature & logos) is to use Paste as formatted text (RTF), but the formatting is all over the place. Frustrating.
Tried: DataType:=wdPasteHTML; DataType:=wdPasteRTF & DataType:=wdPasteOLEObject

[Rudi]

It could be the formatting of the last paragraph in the Word doc that messes around with your signature?

Have you tried pasting your sig into a frame or a textbox. Here is some sample code to try test the theory...

Code: Select all

Sub InsertTextBox()
    Dim Box As Shape
    Set Box = ActiveDocument.Shapes.AddTextbox( _
        Orientation:=msoTextOrientationHorizontal, _
        Left:=50, Top:=50, Width:=100, Height:=100)
        'The solution for you:
        Box.TextFrame.TextRange.Text = "Sig here..."
End Sub

[Peter Kinross]

Thanks Rudi. That solution wouldn't work. I didn't try the code, I just tried it manually, no dice, formatting all over the place.
I have solved the problem though. I re-formatted the signature removing all text boxes, columns and section breaks. It now copies & pastes beautifully in Word.
However, I can't get it to paste into the Outlook 2010 signatures section. There, only the text is pasted. But I tried the pasting the whole thing as an image and the result is far better than pasting as an image previously, so I guess that will do.
Thanks again.

[Peter Kinross]

I found a solution.
I had to:

• Reduce the width of the whole part that was to be pasted.
  I did reduce the page width markers, but also inserted para markers where I wanted each line to finish.
  Combined the 3 graphics (logos) into one.

Pastes beautifully as a signature in Outlook now.

[Rudi]

TX for the update and your solution.
Have a great day!