Contextures

Contextures News 20200211

Excel Copy Paste Problems

February 11, 2020

Copy and paste problems, send customized reports, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Send PDF from Excel

There's a sample file on my Contextures site that lets you send emails to a list of people, and attach a customized report to each person, in PDF format.

I've finally made a page with notes on how the process works, and how you can change the settings, so the mailing works the way you need it to. There's a button to send test email first, so you can make sure that things are working correctly, before sending out the real emails.

Go to the Send Emails from Excel with PDF page, to see the instructions, and download the workbook. It contains macros, so you'll need to enable macros when you open the file, or the buttons won't work!

send emails from Excel with PDF attachment

On Contextures

Here are a couple of recent items from my Contextures site and blogs.

Copy and Paste Problems: Copying and pasting in Excel should be a simple thing, but occasionally you can run into problems. I've made a new video that shows a couple of those problems, and how you can avoid them. You can see the video on my Contextures blog, and there are written notes, if you'd rather read about the problems.

  • Problem 1 - an error message when copying multiple selections
  • Problem 2 - Excel silently changes your formulas to values

copying multiple selections

Excel Articles

Here are a few Excel-related articles that you might find useful or interesting.

Excel Questions: Microsoft's Excel Team is hosting an Ask Me Anything (AMA) session on Reddit tomorrow, Feb 12, from 10-11 AM Pacific Time. This Reddit AMA link should work shortly before the session starts. (Level-All)

Dashboards: Sorry, I forgot to mention this last week! Mynda Treacy shows how to make impressive interactive dashboards, using built-in Excel features, in her one-hour free webinars. If you're using Excel 2010 or later, sign up for the "Dashboards With Power Query & Power Pivot" session. Mynda offers full a Excel Dashboard Course or Power BI Course too - get 20% off if you register by Thursday, Feb. 13th.

Excel Humour: See what people said about Excel recently. Do any of your co-workers make Excel files that look like an Art Attack episode (do you remember that TV series?)

Also see: My Excel Products || Previous Issues

Map Class

This month, I'm having fun with an online map-making class. We're creating simple maps and grids, and looking at things from a new perspective. For example, here's my version of one section of a Copenhagen map. Maybe we'll visit there one day - Copenhagen looks like a beautiful city!

And if you're not taking an online map class, you can create awesome maps in Excel, with the new Map Charts (Excel 2019/365) feature.

weekly photo

NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200211ctx.html
I'll also post any article updates or corrections there.

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

contextures newsletter info

 

Related Links

Send Emails from Excel with PDF

Copy and Paste Problems

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: February 14, 2020 11:18 AM