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 the easiest thing to do in Outlook. This article is the safer way: a personalised email per sub, from your own mailbox, without typing each one.

The three ways, ranked

1. One email per person, by hand. Best result, most work. Fine under ten recipients.
2. Mail merge from Word. Personalised, one message per person, from your account. Fiddly to set up, fast after that. No tracking.
3. Bcc to the list. Fast, impersonal, and one click from a reply-all incident. Avoid.

Method 1: by hand, done well

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

1. Save the invitation as a Quick Part. Write it once, select it, Insert, Quick Parts, Save Selection. Next time it's two clicks and you change the name and trade. Templates worth saving.
2. Use the same subject line every time, with project, trade and due date.
3. Log each one in the tracking sheet as it leaves. Not after. You won't.

Method 2: mail merge, step by step

1. Build the spreadsheet

One row per recipient. Columns:

• FirstName
• Email
• Company
• Trade
• Project, Address, DueDate, DocsLink (same on every row, so the merge document is reusable)

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

2. Start the merge in Word

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

3. 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]

Insert fields with Mailings → Insert Merge Field.

4. Preview

Mailings → Preview Results, and step through several recipients. Look for a blank «FirstName». A blank field is the giveaway that this was a merge.

5. 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 messages to Outlook one at a time from the default account, so check which account is default first.

The catches

1. No attachments. Word's email merge can't attach files. Link to documents instead, which is better anyway.
2. One subject for all. Do one merge per trade so the trade can be in the subject.
3. Sending limits. Microsoft 365 throttles bulk sending (thousands of recipients a day and a per-minute cap). Forty is fine; a merge to your whole list of 300 should be split.
4. No tracking. You'll know it sent. You won't know who opened it. The spreadsheet is still the tracker.
5. Formatting drift. Keep the email plain: text, one link, no tables or images.

Method 3: Bcc, if you must

• Your own address in To. Everyone else in Bcc. Never the reverse.
• Before sending, click into To and count the names.
• Name the trade and ask for a reply anyway.
• Expect a lower response rate. Why.

3 Outlook settings that save you

1. Delay sending by one minute. File → Options → Mail → Rules, a rule to defer delivery on all messages by 1 minute. That minute is when you notice the To field is full of subcontractors.
2. Reply-all warning. Ask your admin to enable it, or use an add-in.
3. Categories on invitations. A colour per project, so Sent Items can be filtered to one bid round.

Where Outlook stops being enough

Outlook plus merge plus a spreadsheet is a legitimate way to run bid rounds. It fails at three predictable points:

1. The second estimator. Two Sent folders, two versions of the tracking sheet.
2. The second addendum. You need everyone who received the original and hasn't declined, which means rebuilding the recipient list from the sheet.
3. "Who hasn't looked at this?" Outlook can't tell you. Read receipts are ignored by most clients.

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

Until you hit those three points: Quick Parts, mail merge, a delay rule and a tidy spreadsheet. It works.