Copying from Word To Gmail Adds Weird Characters

I have a VBA Program (in MS Access) that creates a Word Document and add data into it. It works as expected, no issues here. The problem comes when copying the data and pasting it in the Gmail, it add weird characters at the end.

IH89l.png

And of course that's not how it looks in the Word Document.

xMgNZ.png

It doesn't matter what part I copy, it always add the characters at the end.

8cK6D.png

0LIz5.png

I have tried changing different settings in Word, check the string that I'm copying from VBA and nothing seems to work. Of course, copying into Notepad and then to Gmail is not option because it looses the formatting. Neither is an option set the formatting in Gmail to Text because it looses the standard.

Do you guys have an idea on how to solve this issue? I have seen different posts and I don't find a good solution. Maybe there's no solution after all.

Not enough information here to do much troubleshooting. Are you copying and pasting manually, or is this done in your VBA? Does the same thing happen if you paste it into a different app, like a different Word document, Excel, or an Outlook email body? Can you attach a sample Word document that causes this? Can you provide the VBA code that creates the Word document?

this has been cross posted here


From forum rules
8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

amartinez988, you have enough experience here to know the rules. Thanks to kev_ for pointing this out and also for providing the link.

Please take the time to review our rules. There aren't many, and they are all important.

No one gave me a solution in the other forum guys so that's why I posted here. Sorry about that.

And yes, I'm manually copying from word and pasting it into Gmail. First thing I thought was that my code have and special character at then that was being replaced with this weird symbols but no. It wasn't anything after the last letter. To make sure, I copied until the middle the string leaving the last outside and still added the weird characters at the end. I'm pretty sure it's not a code problem. It seems to be a compatibility problem between MS Word and HTML (Gmail).

Please test this

Create a NEW word document manually - keep it simple - type a sentence - copy and paste some of it into gmail - does it still add funny characters?

(I do this without any problems)

First 2 times it pasted it perfectly, third time the symbols came back again.

2018-03-09 11_12_20-Inbox - [email protected] - CV Advisors Mail.png

Ok we are getting somewhere (hopefully )

What are you pasting that is different in the 3rd test?
- something is triggering the funny characters (may be more than one thing)
- if you can establish that then perhaps it can be eliminated

Create the simplest document that does not cause funny characters and save it - keep going back to this for EVERY test - no combo tests

Test a few scenarios and report back
If ONLY text and numbers do you get funny characters even if 1000 characters.. (I expect this to always work without funny characters because I do not have any problems when I do this even with 1000 characters)
Add paragraphs..
Add a table etc do you get funny characters...
Add header
Add footer
Test for EVERYTHING that is in the document created by your VBA

Word formatting may be the problem
Go back to letter and numbers
apply each format being applied by VBA ONE by ONE and test

The solution is to determine exactly what is triggering the problem and then prevent VBA from introducing it
- you said in post#1 that the VBA is creating this document - so VBA can be told to behave differently

I cannot reproduce this in my Gmail account. Can you please provide a Word document that causes this problem and specify exactly which text you are copying? There is no reason to rule out a code problem, so I'll ask again for you to provide your code.

Originally Posted by amartinez988

No one gave me a solution in the other forum guys so that's why I posted here. Sorry about that.

It's fine to post in multiple places, but you need to provide a link to the other places. Most other forums have the same rule (I don't know about Stack Overflow). This is described very clearly in the rules, which everyone should read.

Originally Posted by amartinez988

No one gave me a solution in the other forum guys so that's why I posted here. Sorry about that.

That ignores the advice you were given there but dismissed out of hand:

Without seeing your code and a sample of the actual content you're trying to copy, it's impossible to diagnose the issue.