excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1713717%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713717%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%3C%2FP%3E%3CP%3EI%E2%80%99ve%20a%20problem%20with%20excel.%20Only%20in%20the%20last%20week%2C%20I%20realized%20that%20if%20I%20copy%20a%20table%20containing%20data%20(number%20and%20text)%20from%20excel%20and%20copy%20it%20as%20I%20always%20did%20in%20outlook%2C%20it%E2%80%99s%20copied%20only%20as%20text%2C%20losing%20the%20formatting%20as%20a%20table%20with%20data%20number.%3CBR%20%2F%3EIf%2C%20on%20the%20other%20hand%2C%20I%20copy%20raw%20data%20from%20a%20computer%20system%20interfaced%20with%20a%20chemical%20laboratory%20instrument%2C%20it%20would%20copy%20and%20paste%20as%20a%20numerical%20series%2C%20even%20if%20the%20symbol%20of%20N%20(Newton)%20was%20present%20in%20the%20cell%2C%20now%20instead%20it%20also%20drags%20me%20the%20symbol%20N%20and%20recommends%20only%20the%20%22paste%20as%20text%20%22.%20What%20happened%3F%20Why%20can't%20I%20do%20%22special%20paste%22%20anymore%3F%20Why%20does%20it%20seem%20like%20I%20can't%20format%20anymore%3F%20There%20are%20also%20other%20copy%20paste%20problems%20but%20I%20don't%20know%20how%20to%20explain%20them%20in%20a%20few%20lines%2C%20so%20I%20start%20to%20understand%20what%20is%20wrong%20with%20the%20formatting.%3CBR%20%2F%3EI%20have%20Microsoft%20Office%20Professional%20Plus%202016.%3CBR%20%2F%3EI%20installed%20some%20programs%20and%20unistalled%20them%20in%20these%20last%20weeks.%3C%2FP%3E%3CP%3EThank%20you%20ll%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1713717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1713944%22%20slang%3D%22de-DE%22%3ESubject%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713944%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F809339%22%20target%3D%22_blank%22%3E%40PBinda%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20I%20can%20help%20you%20with%20this%20information.%3C%2FP%3E%3CH1%20id%3D%22toc-hId-553280499%22%20id%3D%22toc-hId-553280498%22%20id%3D%22toc-hId-553280498%22%20id%3D%22toc-hId-553280498%22%3E%3CFONT%20size%3D%224%22%3EAdd%20a%20table%20to%20a%20message%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fadd-a-table-to-a-message-59766ab4-0fe5-4520-ba0b-e34f8b8cd025%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fadd-a-table-to-a-message-59766ab4-0fe5-4520-ba0b-e34f8b8cd025%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId--1254173964%22%20id%3D%22toc-hId--1254173965%22%20id%3D%22toc-hId--1254173965%22%20id%3D%22toc-hId--1254173965%22%3E%3CFONT%20size%3D%224%22%3EPaste%20options%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fpaste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fpaste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1733636%22%20slang%3D%22en-US%22%3EBetreff%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20read%20briefly%20what%20is%20reported%20in%20the%20two%20links.%20Unfortunately%20it%20explains%20how%20to%20use%20excel%20and%20all%20its%20features%2C%20which%20I%20already%20know%20how%20to%20use%2C%20but%20unfortunately%20I%20have%20not%20found%20an%20answer%20in%20case%20of%20this%20non-dysfunction%20excel-outlook%20and%20excel-instrumental%20data%20recording%20program.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20find%20an%20answer%20regarding%20the%20formatting%20problem.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20try%20again...so%20I%20hope%20to%20find%20the%20answer%20to%20this%20problem.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20help%3C%2FP%3E%3CP%3EP.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Dear All,

I’ve a problem with excel. Only in the last week, I realized that if I copy a table containing data (number and text) from excel and copy it as I always did in outlook, it’s copied only as text, losing the formatting as a table with data number.
If, on the other hand, I copy raw data from a computer system interfaced with a chemical laboratory instrument, it would copy and paste as a numerical series, even if the symbol of N (Newton) was present in the cell, now instead it also drags me the symbol N and recommends only the "paste as text ". What happened? Why can't I do "special paste" anymore? Why does it seem like I can't format anymore? There are also other copy paste problems but I don't know how to explain them in a few lines, so I start to understand what is wrong with the formatting.
I have Microsoft Office Professional Plus 2016.
I installed some programs and unistalled them in these last weeks.

Thank you ll

3 Replies
Highlighted

@PBinda 

 

Maybe I can help you with this information.

Add a table to a message

https://support.microsoft.com/en-gb/office/add-a-table-to-a-message-59766ab4-0fe5-4520-ba0b-e34f8b8c...

Paste options

https://support.microsoft.com/en-gb/office/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad?ui=en-...

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

@Nikolino  Thank you for your help.

 

I tried to read briefly what is reported in the two links. Unfortunately it explains how to use excel and all its features, which I already know how to use, but unfortunately I have not found an answer in case of this non-dysfunction excel-outlook and excel-instrumental data recording program.

 

I can't find an answer regarding the formatting problem.

I try again...so I hope to find the answer to this problem.

Thank you for your help

P.

Highlighted

@PBinda 

Try this example.

The example assumes that the e-mail and workbook are already open and copies the area from B2 to C6 into the e-mail - including all formatting.

So that the declaration of the variables is possible, please add references to the Word and Excel libraries to the project (in VBA via Extras / References).

 

 

Sub PasteFormattedTable()
  Dim Doc As Word.Document
  Dim wdRn As Word.Range
  Dim Xl As Excel.Application
  Dim Ws As Excel.Worksheet
  Dim xlRn As Excel.Range

  Set Doc = Application.ActiveInspector.WordEditor
  Set wdRn = Doc.Range

  Set Xl = GetObject(, "Excel.Application")
  Set Ws = Xl.Workbooks("Mappe1.xls").Worksheets(1)

  Set xlRn = Ws.Range("b2", "c6")
  xlRn.Copy

  wdRn.Paste
End Sub

'untested

 

add info:

The VBA editor is the development environment for your own VBA functions. To open it, press ALT + F11 in Outlook. If necessary, press CTRL + R to display the project explorer. This lists all modules belonging to the project.
Where do I add macros?

At the beginning there is only the module ThisOutlookSession, which you can see under Project1 / Microsoft Office Outlook Objects. Double-click the entry to open the module in the code window. You can copy all macros into this module. This concerns e.g. all of the VBA examples we offer. (In the few exceptions where code belongs in another module, this is pointed out to you.)

Since a code module can accommodate any number of functions or macros, this one module will usually be sufficient. As your code collection grows, it can make sense to move related functions into separate modules. This allows you to improve the overview, but this is not technically necessary.

 

Maybe it will work with VBA

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)