Need to create a project schedule? Try our Gantt Chart Template!

Print a Yearly Calendar on a Business Card

What is a good way to get somebody to look at your business card more than once? If you're a real estate agent, you probably already have a good idea - stick a yearly calendar on your card.

People love calendars reference calendars, and the more convenient they are the better. Of course, people are also in love with their phones, so they may not need to carry a calendar in their wallet. But, there's still the fridge. If you get as much mail from local real estate agents as I do, you probably have plenty of calendar magnets for your fridge by now.

I'm sure there are other businesses that could benefit from printing calendars on the back of their business card. If that sounds like a good idea to you, or if you just want to create a little business card magnet for your own use, you can download the new Business Card Calendar template found on my Business Cards page.

Creating the Business Card Calendar Is Easy

Microsoft Excel is a great tool for creating calendars, but not very good at printing to specific dimensions. Microsoft Word is great for printing business cards, so we've come up with a simple and easy hybrid solution.

First, Create the Calendar With Excel

Business Card Calendar Creator

Click to View Screenshot

On the business card template page, you'll find a link to download the Excel template (see screenshot on the right).

In the Excel template, enter the year and the starting month. If you want the calendar to start on a Monday, you can do that, too. The template also lets you check a box to make the calendars stack top to bottom.

If you want to use a few preset shading options, you can choose those options from the drop-down box, or choose "No Shading" and format the calendar however you see fit.

Copy and Paste into Word

Business Card Calendar Template

Click to View Screenshot

To get the calendar into the business card template for Word, just select the cells containing the calendar from Excel and press Ctrl+c to copy to your clipboard.

The next part is the trick ...

When you paste the copied calendar from your clipboard into Word, paste it as a Picture.

If you're using Word 2003, you can go to Edit > Paste Special > Picture (Enhanced Metafile).

If you're using Word 2010 or later, you can choose "Picture" from the paste options after you've pasted the calendar using Ctrl+v.

After you have the calendar inside one business card, you can select it and copy/paste into the other business cards.

Thanks

A big thanks to Nathan Smith for his initial suggestion and ideas for the business card calendar.

Comments

8 comments… add one
  • Hi Vertex,
    thanks a ton for helping us out with excel tools and calendars. particularly i am amazed by the diversity of your calendar designs! thanks again and keep the show going.
    regards
    LL

    Reply
  • As usual a very nice setup and useful tool!

    Thanks for all you do!

    Reply
  • Hi, thanks for this. I’m just starting a shift rota for the year and was looking for some way to put it on a credit card size print, so I could carry it about. Your process and templates have let me do that by simply adding shading to the cells corresponding to the days I am working, which is great.

    One issue I have is that when I copy the Excel data as a picture the text of the month names does not show properly but is pixelated and unreadable. I am using Word and Excel 2007.

    Reply
    • @John, I don’t have a ready answer for you. Keep trying different things, Googling, or whatever and you’ll likely find a solution. When I want to capture an image, I often use a screen capture rather than the “Copy as a Picture” technique within Excel.

      Reply
  • Thanks so so so so much. it was really helpful. To be frank i didn’t know Excel can even do such a thing. thumbs up.

    Reply
  • Great !!!Thanks for sharing !

    Reply
  • Do you have a template for printing one month at a time on a business card? I want to make a small desk calendar!

    Reply
    • I don’t, but that’s an interesting idea. You could move the monthly calendars around to fit business card paper. It would probably take some trial and error to get the spacing just right. I’d recommend practicing with regular paper instead of using your business card paper (overlay and hold up to the light to see if you have the spacing correct for the business cards).

      Reply

Leave a Comment

Your Name will be displayed along with your comment. Your Email and IP address are stored with the comment and used to identify/prevent spam (via a service provided by Automattic.com), but are not shared publicly. See our privacy policy to learn more.

Cancel reply