fixed : export eMail message as EML file

Question :

I had a complaint about the amount of spam I was getting from one particular sender, so our system administrator asked me to send him samples of the eMails in EML-format so he can have a look into the eMail-headers and adjust the spam-filter.

But how do I export eMail messages as EML-files ?

 

Answer :

EML is short for eMail ; an .eml-file is the typical way for macOS (and MacOSX) to store individual eMails that are not in your mailboxes.

The easiest way to export an eMail message from Mail.app to an EML-file is to Drag&Drop :

  • in Mail.app, select the one eMail that you would like to export
  • click on the eMail and drag it out of your Mail.app onto your Desktop (simply put : “Drag&Drop”)
  • now, on your Desktop, the eMail will be automatically be saved as an EML-file
  • you can double check this by right-clicking on the eMail-file on the Desktop and choosing Get Info ; at ‘Kind:’ it will be listed as ‘Email message’, and at ‘Name & Extension:’ it will be listed with the ‘.eml’-file extension if you uncheck “Hide Extension”

Then you can share the eMail as an attachment in another eMail or put it on a USB-stick or upload it to your system administrator or whatever you like.

That’s it 😉

enjoy !

Advertisements

fixed : burn .iso to bootable Windows DVD-R in OSX 10.11 El_Capitan

Question :

As I need to install Windows in Boot Camp mode on my Mac, I’m trying to burn an .iso disk image of Windows 7 onto a DVD-R from within OSX 10.11 El_Capitan.

But when I right-click on the .iso-file and select “Burn Disk Image “windows-7.iso” to Disc” from the popup-list,  everything seems to go okay, but I end up with a DVD-R with just the .iso-file on it…

It’s not a bootable DVD-R of Windows 7 as I was intending to do… what is wrong ?

 

Answer :

In OSX 10.11 El_Capitan the procedure for doing this has slightly altered compared to previous versions of OSX :

  • right-click on the .iso-file and select “Open With” and then “DiskImageMounter(default)” from the popup-list
  • now the .iso will mount in the Finder
  • then start the Disk Utility application
  • in the window that opens, select the mounted .iso from the list on the left ; it’s listed with an unpronounceable name under “Disk Images”
  • then, in the top menu bar of the screen, go to “Images” and choose “Convert…” from the pulldown list
  • in the pulldown window that opens, select the original .iso-file and click “Open”
  • in the next pulldown window, at “Save As:” replace the temporary Untitled-name with the unpronounceable name of the mounted .iso you’ve seen before
  • then, at “Where:” choose a destination to create the converted .iso-file, and make sure “Encryption:” is set to “none” and “Image Format:” is set to “DVD/CD master” ; then click “Save”
  • now, a .cdr-file will be created in the location you selected at “Where:”
  • right-click on the .cdr-file and select “Burn Disk Image “[name].cdr” to Disc”
  • in the window that opens, select your SuperDrive (or external DVD-burner) and click on the triangular arrow at the far right side
  • the window will be extended, and at “Burn Options” choose the slowest speed possible (if this option is greyed-out, leave it as-is), and at “After Burning” choose “Verify burned data”
  • then put a DVD-R in your Superdrive (or external DVD-burner) and click “Burn”
  • now, the end result will be a bootable Windows installer-DVD

enjoy !

Donate Button (MacManusNL)

fixed : get usable (.tif or .jpg) pictures out of a PowerPoint-presentation

Question :

My colleague sent me a PowerPoint-presentation with pictures in it that I want to use in my own Keynote-presentation. But, whenever I select a picture in the PowerPoint-presentation and drag-&-drop it onto my Desktop (as I usually do in OSX to get a picture out of a website or alike), I get a file named “Picture Clipping.pictClipping”. When I double-click on that, I get a Finder window with the correct preview and a line of info saying “Clipping contents: TIFF image”. But I can’t import that .pictClipping file into my Keynote-presentation as a picture. Neither can I find any way to get the TIFF-image out of the .pictClipping-file.

What can I do ?

 

Answer :

You’ve stumbled upon a hard-to-tackle problem with PowerPoint-presentations.

The solutions is rather simple, but takes a some effort. You can choose to either export  only one picture, or export all pictures from the PowerPoint-presentation :

If you only need one picture :

1- make sure you have GraphicConverter installed (if you don’t have it, you can download it from the LemkeSoft.de website for FREE and use it in “try it”-mode)

2- open your PowerPoint-presentation and drag&drop the picture you need onto the Desktop ; it will appear as a file named “Picture Clipping.pictClipping”

3- right-click on the “Picture Clipping.pictClipping”-icon and select “Open with…” from the pulldown menu that appears, then select “Other…” and select GraphicConverter 9 from the list that appears

4- GraphicConverter will now display the picture ; select “File” from the top menu bar, and “Save As…” from the pulldown menu that appears

5- in the window that opens, select select the destination folder and at “File Format:” choose JPEG/JFIF, PNG or TIFF and click the “Save”-button

6- then in the Finder, go to the destination folder and drag&drop the picture into your Keynote-presentation

…that’s it 😉

If you need multiple (or even all) pictures  :

1- make sure you have GraphicConverter installed (if you don’t have it, you can download it from the LemkeSoft.de website for FREE and use it in “try it”-mode)

2- right-click on the PowerPoint-presentation’s icon and click on “Duplicate” from the pulldown list that appears ; if your original was named “presentation.ppt” the duplicate will be named “presentation copy.ppt”

3- select the icon of the “presentation copy”-file and change the .ppt or .pptx file extension into .dat (when asked “Are you sure… ?”, click on the “Use .dat”-button)

4- now, right-click on the “presentation copy.dat”-file’s icon and click on “Open With” in the pulldown list that appears, then select “GraphicConverter” and click on it

5- in GraphicConverter, you will now see only the first picture from the PowerPoint-presentation, but in the bottom bar, you will see “Page: 1 of X” (in which X is the total number of pictures), there you can scroll through all pictures ; then, from the “File”-menu, select “Convert & Modify”

6- in the window that opens, you will see 3 columns : in the left column, make sure that “Function: Convert” is selected, and “Destination Format:” is set to JPEG/JFIF, PNG or TIFF

7- in the middle column, you will see the “From:”-button and the file named “presentation copy.dat” (with the first picture as it’s icon) ; in the right column you will see the “To:”-button ; there you should select your desired destination folder

8- then, click on the “Go”-button at the bottom of the left column (and all pictures will be exported the way you have asked)

9- do not forget to drag the “presentation copy.dat”-file to the Trash (and empty the Trash)

10- in the Finder, you can now open the destination folder and drag&drop the picture(s) you need into your Keynote-presentation

…that’s it – enjoy !

Donate Button (MacManusNL)

fixed : hashtags making text unreadable in Excel

Question :

Somebody sent me an Excel spreadsheet in which some of the data is unreadable since it has been replaced by text consisting of hashtag signs only…

I’ve seen this happening before, and the remedy used to be just to broaden the column, since all number that are too large to fit their cell width are automatically made unreadable…

However, in this case, if I broaden the column width, some of the hashtag text will turned into readable numbers, but other hashtag text will remain, no matter how wide I make the column…

What is wrong ?

And how can I fix this ?

 

Answer :

This seems to be a problem with Excel for Windows files that are opened in Excel for Mac (possibly more specifically with data copied or converted from another application into Excel on a Windows-PC). So PC-users will not be warned on forehand that their Excel output is not suited for use on Macs…

Fixing it turns out to be rather simple (but annoying) :

• open the file in Excel for Mac

• select the cells that are effected (or preferably even the entire column), then go to “Format” in the top menu bar

• from the dropdown-menu that appears, select “Cells…” and a window entitled “Format Cells” will open

• make sure the “Number”-tab is selected and make sure that you select “Number” or “General” from the list (make sure that it is something else than what was previously selected ; anything seems to be okay, as long as it is not “Accounting”)

• no return to your spreadsheet to check if the hashtag texts have disappeared (if not : try again)

That’s it !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : copy a row into a column (or a column into a row) in MS Excel

Question :

I have this column full of data in MS Office’s Excel, and now I need the exact same data range in another spreadsheet, but this time as a row…

Do I really need to re-type all data ?

Isn’t there an easier solution ?

Answer :

Yes, there is a far simpler way to copy data from a row into a column (and vice versa) in Excel.

You can just copy & paste, or “Paste Special” to be exact… it goes like this :

– in Excel, select the range of cells you want to use (or copy)

– then press the CMD + C key-combo (or select “Copy” from the Edit-menu)

– then go to the page (a.k.a. “sheet”) you want the copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– then press the SHIFT + CMD + V key-combo (or select “Paste Special” from the Edit-menu)

– …and in pop-up window that opens, put a check-mark in front of “Transpose” and click “OK”

– now the data from your original row (or column) will ‘magically’ appear as a column (or row)…

…that’s it !

enjoy ! 😉

Donate Button (all)