Skip to main content

Posts

Showing posts from June, 2013

Clearing invoices marked for emails send later or batch in Quickbooks 2013

One of the few great new features in Quickbooks 2013, is that fact that you can send batch emails.

The problem with this feature is what happens if you have a whole lot marked for batch, and you only want ot send one lot. Well it look like you are up the paddle without a stream.

Here is how I solved it.

What you need:

QB 2013
Outlook

Method

1. In Outlook take it off line, this varies per the version some you can just right click in the task bar others you need to go to Send/Receive->Work offline
2. Go to Quickbooks. Under preferences make sure the email is set to be sent via Outlook. I normally have this off, as since 2006 version I have had problems sending PDF files direct to clients, instead I use a gmail account that automatically forwards reply back to my accounts email. So I have this set to SMTP. But for this excercise, in Quick Books Edit->Preferences->Send Forms. I have set the Send Email Using to Outlook
3. Open up an invoice / estimate. Click on the arrow underneat…

VBA retrieve and current Row and Colum, in Excel

I wanted to store Row and Column in a VBA macro, and could not really find a good source for the how to anywhere so thought I would document how I did it:

  Dim actRow As Integer
  Dim actCol As Integer
  Dim actRange As String
  actRow = ActiveCell.Row
  actCol = ActiveCell.Column
' I actually want 2 rows up in the same colum.
  actRange = Chr$(Asc("A") + actCol) + CStr(actRow - 2)
  Range(actRange).Select


You can change the row and col by just adding 1.

Audible - solving the echo

I love audible, being in the car a lot I use the product a lot. Weather it is a book that is educational, motivational or fiction it is a great service.

So recently I got fustrated. I download a new book on to my iPhone and it had a terrible echo. I had downloaded books before where the audio quality was not very good, so assumed it must be the recording.

I requested that they exchange the book online which they did and I then I got a new book same problem.

Guess how easy it is to fix. On the front page, on the bottom right there is a speed setting, check what it is set too. My echo was caused by it being set to .75x

I changed it to 1x and echo gone ;)