Solved

Excel pasting "top of form" and "bottom of form" to Outlook or Word

Posted on 2014-02-12
6
6,980 Views
Last Modified: 2014-03-05
We're running into an issue where a couple users, when they copy a row from Excel and then paste it into a new Outlook message or Word document, one of the cells has the text "top of form" at the top of the cell's data, and the text "bottom of form" at the bottom of the Excel's data.

I've tried in Outlook changing to html/rich/plain text but it keeps doing it.
Any settings within Excel or Outlook or Word I can adjust to keep it from doing this?

Screenshot/Example.

First screenshot is what the cell in Excel is:
cellafter
Second screenshot shows what Outlook or Word does to it after we've copied and pasted that cell from Excel to Outlook e-mail or Word:
cellbefore
0
Comment
Question by:garryshape
  • 4
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 39854876
In Word, try going to File - Options - Display. Make sure "Hidden Text" is unchecked.

Flyster
0
 

Author Comment

by:garryshape
ID: 39855090
Hmm that doesn't appear to be it, although I'm trying to show it on MY setup since the issue doesn't occur for me.

I'll have the user try it next when available.

Any other ideas? This one's very strange!
0
 

Author Comment

by:garryshape
ID: 39856326
Ok, no hidden elements are checked to show under the "Display" options, neither in Word or in Outlook's Editor options.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 39856558
I personally never ran into this situation. I can't even seem to duplicate it. When you paste it. are you given any options for "Paste Special?" If so, I would try each option to see if one would work.
0
 

Author Comment

by:garryshape
ID: 39856597
If they copy the row/cell to the clipboard then go into Outlook e-mail to paste in a new message, if they choose Paste Special and choose "Microsoft Excel Worksheet Object", it will get rid of the "top of form" and "bottom of form" text from the cell.

Though that's sort of a tedious work-around when they have to keep pasting individual rows from different sheets one at a time.

I cannot re-create the problem on my system, either.
0
 

Author Closing Comment

by:garryshape
ID: 39907036
Yes, paste special will help get rid of it.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question