Before e-mailing the file to another Excel user, verify their version of Excel. Make sure you save as the Excel file to an older version than the recipient has, or the same version. You can then compress the Excel file in a crossplatform Zip format before e-mailing it. Control-mouse click in the Finder to archive or compress it. In mail, make sure the attachment toolbar paperclip icon is visible with View menu - Customize Toolbar on a window that is set to compose the message.
Then use that paperclip to attach the Zip file. When the file dialog box comes up to choose the zip file, be sure to set it to send Windows Friendly Attachments. I'm not used to Windows Metafile (which, after all, was designed for exchanging information in a Microsoft Windows environment). The above graphics came from Excel on a Mac, and can be pasted into an Apple Mail document. 'A Brody' offered you a solution where one is sending information to an end user who has Excel (on either platform), and that end user will be able to manipulate the file. If I understand you correctly - particularly when you mentioned a 'pasted object' - it sounds like you want the email recipient to view the object and make sense of it, but not manipulate it or change any data. Using my method, it appears to me that the chart and graph are converted to PDFs when they're inserted into the email.
Type the word you want to replace in the 'Find What' text field and the word you want as a replacement in the 'Replace With' text field. To replace one occurrence of the word, click 'Replace.' Click 'Replace All' to replace every occurrence. If you don't necessarily want to replace every instance of a word, click 'Next.'
At least I receive them in an email as PDFs. What do you expect the recipient(s) of your email do be able to do with this pasted object? What's the difference between a 'simple column table' and a 'nicely formatted table?' Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.
In previous versions of Outlook, I regularly exported some of my Outlook Calendar, Contacts and Mail data to Excel files to work with it from there or imported data into Outlook from Excel. You also have some which involve Excel. However, now that I’ve upgraded to Outlook 2016, the option to import from or export to an Excel file is no longer available. Why has it been taken away and what is the alternative now? The Import and Export Wizard of Outlook 2013 and Outlook 2016 has indeed been “cleaned up” by removing some old or redundant file formats. This included the Excel option as well.
Even though the xlsx-format has been the standard since Office 2003, the Import and Export Wizard still only supported the old xls-format. Instead of updating the wizard to support the xlsx-format, they took it out completely as you can basically achieve the same with the csv-format which Excel supports as well. Opening csv-exports in Excel The steps to export your data to a csv-file instead of an xls-file are the same with the exception that you now choose for “Comma Separated Values”;. File- Open & Export- Import/Export- Export to a file To export to Excel choose: Comma Separated Values. Once you have saved the csv-file, you can open it in Excel via a simple double click on the csv-file or via the “File- Open” command in Excel 2013 or the “File- Open- Browse” command in Outlook 2016 and setting the file type filter to “All files (.)” or to “Text Files (.prn;.txt;.csv”). In most cases, this will open the file as if it was an xls-file and you can directly start working with it.
Single column issue In some cases, everything will show up in a single column and with a lot of commas visible. That happens when your default list separator in the Regional Settings of Windows isn’t set to a comma. This can be fixed easily from within Excel in the following way:. Click on the “A” column to select the entire column. Select the Data tab. Click on: Text to Columns. In the Convert Text to Columns Wizard which opens, select: Delimited.
On the second screen select: Comma. Press Finish. When you want to save it as an actual Excel file, choose File- Save As and set the “Save as type” dropdown to “Excel Workbook (.xlsx)” or Excel 97-2003 Workbook (.xls). Quick Excel exports via Copy & Paste You actually don’t need the Import and Export Wizard at all when you want to Export something to Excel. When your folder is in a List view in Outlook, you can simply select the items which you want to export and then copy them (CTRL+C) in Outlook and paste them (CTRL+V) directly in Excel.
You can refine this by customizing you View in Outlook by adding or removing columns so just the data which you need will get copied so you won’t have a lot of empty columns or unwanted data in Excel either. In addition, you can apply a filter to your View in Outlook already so you won’t have to filter them afterwards in Excel. For a step-by-step example on how to do this for Contacts see the guide:. Save as csv in Excel and then import When you have an Excel file which you want to import into Outlook, you must first save the file as a csv-file in Excel;. File- Save As and set the “Save as type” dropdown to “CSV (Comma delimited) (.csv)”.
Save As dialog in Excel 2013. Save As dialog in Excel 2016. You may get the following warning when saving your file: Some features in your workbook might be lost if you save it as CSV (Comma delimited). Do you want to keep using that format? Simply choose “Yes” as you’ll still keep the original Excel file as well. You can now import that csv-file into Outlook just as you would have done with an Excel file but now of course choose to import a “Comma Separated Values” file.
In most cases, when you get at the “The following actions will be performed” step, the option to import your csv-file is selected and you can press Finish to complete the Import process. In some cases however, this option is not selected.
In that case, do not select it but press Cancel as forcing the import will create broken items. If the csv-file isn’t automatically selected when importing, something is wrong. The reason is because with some Regional settings, Excel uses the semi-colon (; ) as a delimiter for a csv-file instead of a comma, which Outlook expects. This can easily be fixed by doing a quick “Find and Replace” in Notepad or by changing the delimiter in your Regional Settings in Windows to a comma and resaving the csv-file. For detailed instructions about that see: Last modified: May 26, 2017.