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.
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!
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.
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.
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.
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.
Last updated: February 14, 2020 11:18 AM