Send Email

Location on ribbon: Tab DVD Addin → Group File and Print

Command ID: btnSendEmail

License required

This command needs an active DVDAddin account (Standard or PRO). During the trial period it is fully available.

What it does

The command opens a compose window that sends through Outlook, in which every field can point at an Excel cell instead of being typed. The cell value is read at the moment of sending, so the message always reflects the current state of the sheet.

Combined with batch mode, one click can produce dozens of different emails: each iteration writes a number into a driver cell, the sheet recalculates recipient, subject and body, and the relevant sheets can even be exported to PDF and attached automatically. That is how you issue inspection requests, progress notices, or payment reminders to many subcontractors without composing each message by hand.

How to use

1. Prepare the data sheet: columns for recipient address, recipient name, company, subject, body, and attachment paths.
2. Go to tab DVD Addin → group File and Print → click Send Email.
3. Fill in the message: From (Sender), To, Cc, Bcc, Subject, Salutation, Recipient name, Company, Body. For each field either type the text or click the ⤴ button to point at the cell that holds it.
4. Tick Add tab indent when the recipient list spans several lines and you want it indented.
5. In Link, put one link per line, either as Label: url or just the url.
6. In Attachments, put one file path per line, pick files through the Windows file dialog, or point at an Excel cell holding several paths (use Alt+Enter inside the cell for line breaks).
7. For batch sending, enable the Batch section: choose a Continuous range or a Discrete (1+3+5) list, and set the Driver cell (n) — that cell receives the iteration value before each email goes out.
8. To attach a PDF per iteration, enable Export sheet(s) to PDF and attach per iteration, select the sheets (Ctrl/Shift for several — they all go into one PDF) and enter a Base filename; the add-in appends _ + the iteration number + .pdf.
9. Click 💾 Save to remember the configuration, Preview to open the Outlook compose window for review without sending, or Send to dispatch.

Example

You have to issue inspection requests to 12 subcontractors, one work package each.

The Subcontractors sheet lists 12 rows of email, contact name, company and package title; cell B1 holds the subcontractor number and D1:D4 use INDEX against B1 to return the address, name, company and subject line. In the Send Email window you point To at D1, Recipient name at D2, Company at D3, Subject at D4, set the Driver cell to B1, choose Continuous 1 to 12, and enable PDF export of the RequestForm sheet with base name IR_Round2. Click Preview to check the first message, then Send: 12 emails go out, each with its own IR_Round2_1.pdf … IR_Round2_12.pdf.

Notes

• Microsoft Outlook must be installed and configured on the machine; the command sends through Outlook rather than talking to a mail server directly.
• Cell-linked fields are read at send time, so in batch mode each iteration produces different content.
• Always use Preview on the first iteration before clicking Send — sent mail cannot be recalled.
• The driver cell is genuinely overwritten during the run, so save the workbook before a large batch.
• Attachment paths must exist on the machine; a single cell can carry several paths as long as each one is on its own line (Alt+Enter).
• When several sheets are selected for PDF export, they are combined into one file per iteration.

Related

• Email Template — a ready-made file with the standard column layout for batch mail.
• Import Email — the other direction: pull messages and attachments from Outlook into the sheet.
• Batch print — the same driver-cell mechanism, used for printing and PDF export.
• Merge to Word — merge the same data into Word documents instead of emails.