Category Archives: Guest Posts
Dear Wannabe Guest Bloggers (and other news!)
I love you all. I really do. But here’s the thing: I don’t actually know most of you. So here’s the deal.
Until now, I haven’t set up any guidelines for guest post submissions. I liked the open-door philosophy: if you write it, I will take it! But I’m receiving a lot of prefab propositions that all sound eerily alike and don’t lead back to a blogger. Instead, it’s always someone who just wants to advertise a commercial website. Which is fine. But that’s not why I do this.
I want to support the blogging community. So to guest post for me, you have to have your own blog. It doesn’t have to be about writing, or reading, or anything specific. It can be about rutabagas. In fact, your guest post can even be about rutabagas- if you’re very clever and you somehow make it relevant.
This also helps to ensure that I’m receiving original content. If I know where you live, so to speak, I can trust you more. If I can trust you, then I can ask my readers to trust you, and ultimately this trust upholds the integrity of my site.
Sound fair? I think it does.
Otherwise, my guidelines remain the same. Include a bio and a photo and a good, original post (recycled or new- doesn’t matter), and I will let you hang out at this blog as often as you like. I’ll even give you content in return, if you want it.
In other news!
The talented Connor at Cities of the Mind- Freelance Writing recently reviewed this blog. You can read the review and his other reviews HERE. This is definitely a good place to get overviews on potentially awesome blogs. And who doesn’t want an introduction to that? Connor’s reviews are concise, informative, and accurate. It’s like going blog shopping with a blog expert. I doubt he’d claim to be an expert, though, but then that’s part of the reason we like him, right?
Also, speaking of guest blogging, I’m the guest this week at the Gritty Blog. Some of my regular readers might recognize this post about Believability in Fiction. It’s a good one, I think, and it was a fun one to write.
And speaking of GCP, I’d like to give a shout-out to some of our writers. Check out:
Jodi McClure’s blog, “The Swing”
Cynthia Ravinski’s author site
I’d also like to note that I’m looking forward to reading and reviewing Will Kosh’s book, Little Winged One: The First Book of Guardians. There are other books on my “to-review” digital stack, too, I know- I haven’t forgotten you… One I should probably mention is Liz Schulte’s Secrets: Guardian Trilogy Book One (what’s with all the guardian stuff, I wonder?) Out of the five authors that participated in the Blog Tour de Force, she was the only one who emailed me about a review. And I’m not including the prefab mass email requests. But honestly, these authors all gave their books away for free; of course they all deserve reviews. Secrets just got bumped up the list because I appreciate the personable approach.
One other thing. My son turned ONE YEAR OLD yesterday. Where did this year go?! My little monkey is growing up. He’s not even technically a baby any longer- he’s a toddler. I have a toddler. What?!
A Useful Spreadsheet Template for Writers’ Correspondences: Guest Post by Michael Seese
I’d like to welcome Michael Seese, author and former journalist and technical writer. Below, Michael takes us through the process of creating a useful spreadsheet to help freelance writers and fiction writers keep track of professional correspondences. Not only does he explain every step in detail, but he also includes photos AND has offered to email the template to anyone who’s interested- for free!
(This is the kind of guy that I’m talking about when I refer to the “helpful-generous-selfless-supportive-and-friendly writing community.”)
And The Geek Shall Inherit The Earth …
For those of you who don’t know me well, I used to be a computer programmer. As I used to say (boast), “I tell my computer what to do. Not vice versa.” A nice little skill that I developed was macro creation, specifically for applications in the Microsoft Office suite.
If you’re a writer, you probably face the same quandary I face: keeping track of your submissions. Who you queried, what their instructions are (“We respond to all queries” or “If you don’t hear back, assume we’re not interested.”), and when to follow up. The problem grows exponentially if you’re submitting different works to different agents and/or publishers.
So I developed a handy-dandy spreadsheet to keep track of my correspondence.
If you have no desire to learn about my system, go ahead and bow out now. But if you want to see my spreadsheet “in action,” keep reading.
As background, this actually was based on an Access database that I developed a few years back for the same purpose. That one got a bit cumbersome, as I found that in some cases I needed a way to have a “many-to-one” and/or a “one-to-many” relationship (to use the geek terms) between a work and a correspondence with someone. To clarify, if I’m sending a query letter to an agent, that’s one-to-one. But in many cases, a poetry publisher or magazine asks for five poems. So that’s many works in one email. But also, if I’m querying an agent (as mentioned, one-to-one) and he or she writes back and says, “Send more,” now I have one work, but many emails.
Clear as mud? I used to be a tech writer, so I hope I can still convey things like this.
So I came up with this spreadsheet. I’m sure this first image will be hard to see, so after it, I’ll describe what’s there.
(Please note, I use OpenOffice, which is an open-source — meaning free — app that works like the MS Office suite; Excel will look a little different, but functions basically the same way.)
This is the header row.
The columns are Key (I’ll explain later), Date, Follow Up Date, Response, Sent What?, Via, Email, To What?, Name, Who, Genre, Work, Details.
I tried to set it up so you can simply read it, left to right. So that would be (the column headers are in ALL CAPS)…
“On this 12/20/11 (DATE), I sent a query (SENT WHAT?) VIA email to an agent (TO WHAT?) at company NAME, and this person specifically (WHO). I sent my novella (GENRE) named Udopia (WORK). Addtional DETAILs are …
So a real-world example would be:
And it reads, “On 12/15/11, I submitted, using an online form to an anthology named Best Fiction. The recipient was not named. I sent a short story, “Tarantulas On Leashes.”
Now to explain a few things…
You’ll notice there is a “Key” field. In the above example, for both lines, it is 46. This was done to solve that one-to-many problem that I referenced earlier. Every entry should have at least two lines with the same key. The date you sent it, and the date that they say you will get a response by. Bear in mind, as I mentioned above, some say “If you don’t hear back in six weeks, assume no.” Fine. I can still put a date that is six weeks out in the Follow Up Date field, and copy that comment into the Response field. The beauty of this key field is that if I am sending multiple works to a single entity, there is one line for each work, plus the follow-up line, all sharing the same key. As you can see here:
Key 45 represents five works submitted to one anthology, plus there is the follow-up line.
If you use Excel a lot, this should be obvious, but you don’t need to “do math” to get the follow-up date. The “Key 45″ entity did not state a follow-up date, so I am assuming six weeks. Cell C14 is actually a formula which reads “=B45 + 42″ Seven days times six weeks = 42, naturally. Oh, and once I get a response, I delete the value from the “Follow Up Date” field, and put the date I heard back in the “Date” field. You can do whatever you want; you could leave it there. This just works for me.
You will notice that I have highlighted in red text to-do items. Likewise, if someone has said “no,” I color the text gray, to fade it out.
The Email column contains a hyperlink to where the actual email lives on my hard drive. Having it here allows me to call it up at will. Please note that I use an email program (Thunderbird) which brings emails down to my PC, as opposed to something like GMail, which keeps them on Google’s servers. Of course, since the field holds a hyperlink, you might be able to store the link to a webmail message. Hmmm.
Bear with me. There are only two things left to point out …
In order to keep things clean, I use the “group” function of my spreadsheet. In the previous images, I intentionally omitted the left-most portion of the screen. It actually looks like this:
You will notice a little box, with a minus sign in it. What that says is that I have “grouped” rows 2 and 3, as well as rows 4 and 5.
Once 2 and 3 are grouped, I can click on the minus sign to collapse or hide row 3, like thus:
I just think it’s neater to hide the details, once an entry is “closed.”
Please note that there is one weird quirk about both Excel and the OpenOffice spreadsheet. Logically, I would expect that I need to highlight everything I want in a group, and then choose the “group” command. But the reality is, you highlight ALL BUT the first. So in the example immediately above, I highlighted only row 3. Going up a bit to my “Key 45″ example, I highlighted rows 10 – 14 (but NOT row 9) before hitting the “group” button.
And finally, you can use filters (native to both Excel and the OpenOffice version) to create “mini-reports,” if you will. Do you want to know to which agents you’ve sent a given work? Filter on the book’s (or article’s) name in column L, “Work.” Do you want to know which works you’ve sent to a certain agent? Filter on his or her name in column J.
Had enough?
If you are a writer (or an agent) and would like a blank version, please leave a comment. I’d be more than happy to send you one. I’ll even throw in free “tech support,” though bear in mind, you get what you pay for.
Just kidding.
PS: I do realize that I didn’t mention macros after talking about them up top. This spreadsheet has no macros…yet!
I am a former journalist, but my current day job is in information security for a regional bank. Or, as my son could say even at age three, “Daddy keeps people’s money safe.” I have published three books: Haunting Valley, a collection of fictional ghost stories centered around my home town; Scrappy Business Contingency Planning, which teaches corporate BCP professionals how to prepare for bad things; and Scrappy Information Security, which teaches us all how to keep the cyber-criminals away. I also just learned that a short story of mine, “Worm Herding,” has been accepted by Pill Hill Press for their compilation, BUGS. Other than that, I spend my spare time rasslin’ with three young’uns.
You can reach Michael by visiting his blog, Absurd Person Singular, and by following him on Twitter @MSeeseTweets.
