Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel: Copy Text Range and Strip Out Table (For Outlook etc)

Posted on 2015-02-15
2
Medium Priority
?
83 Views
Last Modified: 2015-02-16
Hi,

Attached is a sample Excel spreadsheet. Column A (yellow highlighted range) has some text across multiple rows. I would like the user to be able to be able to select this text and copy / paste it into Outlook. Currently if I do this, it's pasted into Outlook as a column of rows. I want to be able to paste it as 'normal' email text - formatting preserved.

I thought I could do this my creating a message box, however I can't select message box text to copy it directly to Outlook.

Is there another solution that allows me to copy and paste this text, preserve bolding - but strip out the table formatting?

Thanks.
ee-textstrip.xlsx
0
Comment
Question by:dabug80
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 2000 total points
ID: 40611937
When pasting into Outlook, choose Paste Special and select the Text option.
0
 
LVL 1

Author Closing Comment

by:dabug80
ID: 40613075
Thanks. This is a good simple solution. It doesn't preserve the bold formatting - but apart from that it's great.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

610 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