Copy and Paste from Excel to Outlook

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,860
Office Version
  1. 365
Platform
  1. Windows
I am copying the following;
[TABLE="width: 252"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]411040356
[/TD]
[TD][/TD]
[TD="colspan: 2"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">CARLSON 1-11
</form>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]411040366[/TD]
[TD][/TD]
[TD="colspan: 2"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">ANDERSON 1-14
</form>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">411040345
</form>[/TD]
[TD][/TD]
[TD="colspan: 2"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">LOGAN TRUST 1-14
</form>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">411040354
</form>[/TD]
[TD][/TD]
[TD="colspan: 2"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">CLELLA 1-19
</form>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">411040348
</form>[/TD]
[TD][/TD]
[TD="colspan: 2"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">INLOW 1-14
</form>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">411040370
</form>[/TD]
[TD][/TD]
[TD="colspan: 2"]<form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">A CROSS RANCH 5-36
</form>[/TD]
[/TR]
</tbody>[/TABLE]
No red borders what so ever, and when I paste it on Outlook, it comes like this,
[TABLE="width: 253"]
<tbody>[TR]
[TD]411040356
Bottom of Form

[/TD]
[TD][/TD]
[TD="colspan: 2"]Top of Form

CARLSON 1-11
Bottom of Form

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]411040366
[/TD]
[TD][/TD]
[TD="colspan: 2"]Top of Form

ANDERSON 1-14
Bottom of Form

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Top of Form

411040345
Bottom of Form

[/TD]
[TD][/TD]
[TD="colspan: 2"]Top of Form

LOGAN TRUST 1-14
Bottom of Form

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Top of Form

411040354
Bottom of Form

[/TD]
[TD][/TD]
[TD="colspan: 2"]Top of Form

CLELLA 1-19
Bottom of Form

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Top of Form

411040348
Bottom of Form

[/TD]
[TD][/TD]
[TD="colspan: 2"]Top of Form

INLOW 1-14
Bottom of Form

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Top of Form

411040370
Bottom of Form

[/TD]
[TD][/TD]
[TD="colspan: 2"]Top of Form

A CROSS RANCH 5-36
Bottom of Form

What is "Top of Form, and Bottom of Form" and how can I get rid of this?

Thanks
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
This is the very common use of excel which is useful for data compiling but sometimes I get the problem then I contact to ms outlook support which solves my every problem with my excel and outlook
 
Upvote 0
Thank for your advice.

Best regards,
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top