How to send bid invitations from Outlook with mail merge

A bid invitation with 47 subcontractors in the To field is a small disaster waiting for the first reply-all. It's also, unfortunately, the easiest thing in the world to do in Outlook. This is the safer way: one personalised email per sub, from your own mailbox, without typing each one out by hand.

The three ways, ranked

One email per person, by hand, gives the best result and costs the most work. Fine under about ten recipients.

Mail merge from Word gives you a personalised message per person from your own account. Fiddly to set up the first time, fast every time after. No tracking.

Bcc to the list is fast, impersonal, and one click away from a reply-all incident. Avoid it if you possibly can.

By hand, done well

For a small scope, just write them. Three habits make it painless.

Save the invitation as a Quick Part: write it once, select it, then Insert, Quick Parts, Save Selection. Next time it's two clicks and you change the name and trade. (Templates worth saving.) Use the same subject line format every time, with project, trade and due date in it. And log each one in the tracking sheet as it leaves. Not after. You won't do it after.

Mail merge, step by step

Build the spreadsheet

One row per recipient, with these columns: FirstName, Email, Company, Trade, and then Project, Address, DueDate and DocsLink, which are the same on every row so the merge document is reusable across bids.

Filter your trade list to the scope and region, copy the rows in, and check every email address once. A merge sends cheerfully to typos.

Start the merge in Word

Mailings → Start Mail Merge → E-mail Messages. Then Select Recipients → Use an Existing List, and pick the spreadsheet.

Write the message with merge fields

Hi «FirstName»,

We're bidding «Project» at «Address» and would like a price from «Company» on the «Trade» scope.

Drawings and specs: «DocsLink»

Bids are due «DueDate». Please send your proposal to me directly.

Could you let me know by Wednesday whether you're bidding? A quick yes or no is all we need.

Thanks,
[Name]

Fields go in with Mailings → Insert Merge Field.

Preview it

Mailings → Preview Results, then step through several recipients, not just the first one. What you're looking for is a blank «FirstName». A blank field is the one thing that gives away a merge instantly.

Send

Finish & Merge → Send E-mail Messages. Choose the Email column for the To field, type the subject line, and pick HTML so the link is clickable. Word hands the messages to Outlook one at a time from the default account, so check which account is the default before you hit go, particularly if you have a shared mailbox set up.

The catches

Word's email merge can't attach files, so link to the documents instead, which is better practice anyway. There's one subject line for the whole merge, so do one merge per trade if you want the trade in the subject (and you do). Microsoft 365 throttles bulk sending, thousands of recipients a day with a per-minute cap; forty is fine, but a merge to your whole list of 300 should be split up. There's no tracking, so you'll know it sent and nothing more, and the spreadsheet stays the tracker. And formatting drifts, so keep the email plain: text, one link, no tables, no images.

Bcc, if you really must

Your own address in To. Everyone else in Bcc. Never, ever the reverse. Before sending, click into the To field and count the names. Name the trade in the body and ask for a reply anyway. And expect a lower response rate, for reasons that are worth understanding.

Three Outlook settings that will save you at some point

Delay sending by one minute. File → Options → Mail → Rules, and a rule to defer delivery on all messages by one minute. That minute is when you notice the To field is full of subcontractors.

A reply-all warning. Ask your admin to enable it, or use an add-in.

Categories on invitations. A colour per project, so Sent Items can be filtered down to one bid round when you need to reconstruct what went out.

Where Outlook stops being enough

Outlook plus a merge plus a spreadsheet is a legitimate way to run bid rounds, and plenty of good estimating departments run on it. It breaks at three predictable points.

The second estimator, because now there are two Sent folders and two versions of the tracking sheet. The second addendum, because you need everyone who received the original and hasn't declined, and that means rebuilding the recipient list from the sheet under time pressure. And the question "who hasn't looked at this?", which Outlook cannot answer, since read receipts are ignored by most clients.

At that point the options are a bidding platform, which moves your subs into a portal, or a tool that keeps the sending in your own mailbox and adds the tracking. Invite All is the second kind, and we think the best of them: it connects to Microsoft 365 or Google Workspace, sends one email per person from your address using the same placeholders as the merge above, drops them into Sent Items, and shows delivered, clicked, viewed and answered for each contact. It's the mail merge with the spreadsheet automated.

Until you hit those three points, though: Quick Parts, a merge, a delay rule and a tidy spreadsheet. It works, and it works for a long time.