Paste Excel


Everytime I try to copy a table from Excel (2007) to an Outlook e-mail
everything looks fine on the screen but when the message is sent the text of
the copied table is bold and of a different font that is barely readable.
The e-mails are html and in Excel I use the Paste/As Picture/Copy as
Picture/As
Shown When Printed option. Have also tried the As Shown On Screen option As
Picture and get the same results.

When I do the same in Word the paste seems to work fine. What's the best way
to insert an Excel table into an Outlook document?


Sponsored Links:



I copy cells from an Excel 2007 worksheet.

In Outlook 2007, I use Paste, Paste Special, Microsoft Excel Worksheet
Object to insert the copied Excel cells into the text section a new email
message.
I send the email to another person.

Other person receives my email message using Outlook 2007. However the
pasted Excel Object acts like a JPEG and cannot be opened and edited using
Excel. Why can't this person open the Excel Object and have it launch an
Excel window?




Is it possible to past excel rows to the body of an outlook appointment
and fit in all the information. When we try and do this it pastes ok
except some of the columns are off the page and you cannot scroll right
to see them even though i know they are there. I have tried using
paste special but none of the options seemed to work. I am guessing
that because this is such an unusual request that it cannot be done....

Thanks in advance

ICTUser




(This has been posted on two "excel" groups for two days with no response.
Maybe it's an uncommon issue.)

I have a user who's unable to paste an Excel 2003 chart into Outlook 2003
email message. In Outlook options, the checkbox is selected for "Use
Microsoft Office Word 2003 to edit e-mail messages".

When I tested this on my own computer running the same version of Office, if
the box is check, I have no problem pasting; if this box is cleared, I
cannot paste. But on his computer, it doesn't work regardless.

Thanks and regards,
TL




I frequently paste portions of excel cells into outlook messages. When I do
I often have problems with the widths of the cells being too narrow. Is
there an easy way to solve this without having to adjust widths?




Everytime I try to copy a table from Excel (2007) to an Outlook e-mail
everything looks fine on the screen but when the message is sent the text of
the copied table is bold and of a different font that is barely readable.
The e-mails are html and in Excel I use the Paste/As Picture/Copy as
Picture/As
Shown When Printed option. Have also tried the As Shown On Screen option As
Picture and get the same results.

When I do the same in Word the paste seems to work fine. What's the best way
to insert an Excel table into an Outlook document?




Hi,

I am Using Windows 2003 SP2 with Exchnage 2003,and configured OWA.

Problem: Whenever any of user recives a jpg contained mail while forwarding the same mail it shows "RED CROSS" on that file.
I any user paste Excel data direct in the mail the receiver tries to forward or reply the same time it stops working.

I downloaded MIME on few client but doing above mentioned activity it shows error on top :0x8007000d




I need Outlook Macro to Copy data from Outlook mail with Specific subject and Paste it the Excel sheet (Paste it in the Specific tab)

I am getting some 13 different mails every half an hour which contains tables of Data. I have to copy the tables and paste it in the Specific tab of the excel sheet manually.. I have created 13 tabs for 13 mails and 1 more tab for Graphs (Graphs will change based up on the value of the 13 table). So I have to paste it as Destination Format. Please anyone help me in this...

Sorry for my Poor English..




I am trying to copy and paste an Excel 2003 chart into an Outlook 2003 html
email but the Paste is not availabe. I can copy and paste the same chart
into Word 2003. The chart also shows up in the Clipboard.




I want to paste a table from Excel into Outlook (RTF). When a row has text
in column A (left justified) and a numeric value in column B (right
justified) Outlook makes everything in the row left justified which messes
up alignment of all columns containing numbers that should stay
right-aligned.

What's the problem?




When I cut/paste from Excel into an email (Outlook), the data pastes in HUGE
font. How do I reduce the size when pasting into an email?? Thanks!!




I use Excel 2003 and Outlook 2003, both are Office versions.

Every time I copy and try paste a range of cells from an Excel worksheet
into an Outlook email (not a file; just a range of cells), they look just
great--within the borders of the email page. I want to sent STATIC
images--no interactivity required.

When I send the emails, the recipients get an image/worksheet(?) in their
email that is far past the margins and the recipients can't see all the cells
that end up disappearing to off to the right.

I'm told there used to be a "snapshot" icon in Excel that allowed a static
image to be copied and then pasted into Outlook emails. I don't see that
icon in Excell 2003.

Is there a way to do this? I've tried copying the cell range into Paint, and
the copying that over to Outlook, but sometimes the image does get to the
recipient, especially if the recipient forwards the emai to someone else.

What do I need to do to send a STATIC image of a range of cells without
losing information off the side of the email page?




I am pasting an Excel pareto (as Windows Metafile Picture) into an email
message but it comes in an a super-duper high resolution 2 megabyte picture.
How do I get it down to around 100K? - I don't need hi-res (and wasted inbox
memory)




We have an excel worksheet that has fixed column widths and centered text.
When we copy this sheet and paste it into a POST in Outlook 2003, the
formatting is lost. The columns get narrower and the text becomes left
justified. If I paste the same worksheet into an Outlook 2007 post, the
formatting is preserved. I also notice that when pasting the sheet into
Outlook 2003, it takes a looooooooooooong time. Is there a way to fix this?

--
Thanks!




When I copy values from Excel cells individually and paste them into a OE message that I am composing, the behavior seems odd. For example:

1. (a) The font size and type does not match the existing font of the message; and (b) I cannot append the pasted text to an existing line, and I cannot continue typing on the pasted line. The pasted text is forced onto a new line, and any text typed after that is forced onto yet another new line.

2. When I hover the cursor at just the right spot, I get what I call an "object cursor"; two double-headed arrows crossing perpendicular. If I left-click in the state, I get what I call "object handles"; little outlined boxes at strategic places around the pasted text.

I work around this behavior by first pasting into Notepad, then copy-and-pasting into the OE message. Then the pasted text is treated no differently than if I had entered it manually.

Is there some way that I can get the latter behavior when I copy-and-paste directly from Excel into the OE message?

I am using WinXP Pro SP2 with Office 2003 (IE6). I set the following options:

a. Sending Format: Plain Text, MIME, encoding: Quoted Printable.

b. Compose Font: 10pt Courier New, Regular.

I do not want to use HTML.




How do I paste cells from Excel into a custom message form? I do not
want to send an attachment.

I have everthing else worked out.

I would like to copy certain cells in Excel then paste into the body
after vSect1 and send the e-mail.

I have copied this from the macro recorder in Outlook but do not know
what to do with it if anything.

Selection.PasteExcelTable False, False, False
Selection.TypeParagraph

Here is the code I do have:

Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
Set myNameSpace = objOutlook.GetNamespace("MAPI")
Set myOutBox = myNameSpace.GetDefaultFolder(olFolderOutbox)

With objOutlookMsg
Set objOutlookRecip = .Recipients.Add(strName)
objOutlookRecip.Type = olTo
.Subject = "Test Sub"
.Body = vSect1 & vbCrLf & vSect2
.Save
.Move myOutBox
End With




An unusual one this one but please read on.

If I manually copy a range of cells from an Excel worksheet and then paste
into a Draft email in Outlook (My Outlook 2003 uses HTML as draft format with
Word as editor) the resulting pasted cells look fine - colors and formatting
are maintained.

OK now to do it in VBA from Excel.

I copy the range of cells into Clipboard with :-

Range(Cells(aa, 4), Cells(bb, 17)).Select
Selection.Copy

I then obtain the contents of Clipboard and place into a String variable
with :-

Set MyData = New DataObject

MyData.GetFromClipboard
strClip = MyData.GetText

I then create an Outloook object within VBA and build a Draft message using
strClip as part of the Message body.

This all works OK and the Draft message is created but the resulting pasted
range of cells in the Draft message does not look very good, the values are
mis-aligned and wrapped around with any color formatting is lost. It does not
give me the same pretty result as manually cutting and pasting the cells.

Does anyone know how I can preserve the formatting using the VBA method so
that the resulting pasted cells looks as good as the manual method?

Thanks.




Hi,

Does anyone have a code for selecting a contact for Outlook in a
userform and paste it in a Excel spreadsheet. I have a code that is
not very efficent as i want to select from about 1000 contacts.

Thanks

Oggy




Hi,

Does anyone have a code for selecting a contact for Outlook in a
userform and paste it in a Excel spreadsheet. I have a code that is
not very efficent as i want to select from about 1000 contacts.

Thanks

Oggy




I am trying to paste an excel shart in the body of an outlook message.
I already managed to do this through exporting the chart and then
importing, but the chart loses a lot of quality so I am trying to find
a way to paste the chart through the clipboard.

the only thing missing in my code would be the procedure to paste the
chart that is already on the clipboard. here's what I have:

Sub SendEmail()

Dim theApp, theNameSpace, theMailItem, myAttachment, Msg

'create a new Outlook Application Object,
'direct it to the proper NameSpace,
'create a new Mail Item and set the attachments collection
Set theApp = CreateObject("Outlook.Application")
Set theNameSpace = theApp.GetNamespace("MAPI")
Set theMailItem = theApp.CreateItem(0)
Set myAttachment = theMailItem.Attachments
theMailItem.Display

' campo mensagem '
Workbooks.Open "Test.xls"
Sheets("Sheet1").Select
ActiveSheet.ChartObjects("Grafico").Activate
ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen,
Format:=xlPicture
Sheets("Sheet1").Cells(1, 1).Select

'add recipients to MailItem
theMailItem.Recipients.Add "
theMailItem.subject = "Anything"
theMailItem.Body = Msg

theMailItem.Send
theNameSpace.Logoff

End Sub

I found the code below on this same newsgroup that supposedly would do
the job, but it is not working. Does anyone know why?

Sub Pastebody()
Set tmpBody =
Item.GetInspector.ModifiedFormPages("Message").Con trols("Message")
tmpBody.SetFocus
Item.GetInspector.CommandBars.Item("Menu
Bar").Controls("Edit").Controls("Paste").Execute
End Sub

Thanks