Choose your edition, then follow the guide for your tool.
Getting started
1. What LAVL does
LAVL creates code from the settings you choose. A card is one feature. Code is a set of instructions for another program. Choosing a card does not immediately change Outlook or Excel. You must apply the generated code in that program.
Example
Turn on “Attachment required” → LAVL creates VBA code → after you put that code in Outlook, it checks attachments when you click Send.
2. Start in six small steps
Save the HTML file on your PC. Its name should end in .html.
Double-click it to open it in Edge or Chrome.
Choose Outlook VBA, Excel, or AutoHotkey at the top.
Start with one feature and enter its settings. Use practice data first.
Review the output on the right. Copy it or save it as a file.
Follow the instructions for that program below and check the result.
3. A small dictionary
VBA / macro
Instructions that run inside Outlook or Excel to perform a task.
Formula
A calculation placed in a cell, such as =SUM(A2:A4).
Keyword
A word used to choose which item to check. “Report” matches a subject containing Report.
To / CC / BCC
Main recipients / carbon copy / blind carbon copy. BCC addresses are hidden from the other recipients.
Folder path
A folder location, such as C:\Work\Reports.
JSON
A file that stores your card settings. It is not a macro to run in Outlook or Excel.
Milliseconds (ms)
1000ms is one second; 500ms is half a second.
4. Saving settings is different from applying code
Browser settings are intended for use on the same PC and in the same browser. Keep an exported settings JSON or a LAVL-generated code file too, where the tool supports it. This helps when you move to another PC or clear browser data.
After changing cards, copy the new code and replace the previous generated code in the target program. Changing this HTML does not update code already installed in Outlook or Excel.
Official reference links
The instructions are built into this file. These optional links need internet access.
The illustrations show PRO. In FREE, use only the features and fields described below. Additional condition rows and other PRO controls shown in a picture are unavailable in FREE.
PRO screen: use the left menu to choose a feature.
Custom rule example
Subject contains Quote, body lacks Delivery date → show a warning. A different subject is outside this rule.
Custom rule example
Outlook VBA
1. Check your Outlook version
Use classic Outlook for Windows. New Outlook and browser mail do not run this VBA code. If your workplace blocks macros, ask your IT team about the approved setup.
2. Build your first check
Open Basic send checks.
Turn on Subject template placeholders.
Enter [Customer] as a phrase to detect. Put separate phrases on separate lines.
[Customer] document update should trigger this check. Alex document update should not trigger it.
Review the code on the right. Other enabled checks may still produce their own warnings.
3. Apply the code in Outlook
Open File → Options → Customize Ribbon and select Developer.
Open Developer → Visual Basic, or press Alt+F11.
Double-click Microsoft Outlook Objects → ThisOutlookSession in Project Explorer. Press Ctrl+R if the explorer is hidden.
Back up any existing code in a text file. If it contains your own code, check how it should be merged before replacing it.
Click Copy code in LAVL and paste the generated code into ThisOutlookSession. Replace the previous complete LAVL code. Do not add a second Application_ItemSend procedure.
Choose Debug → Compile VBAProject to check for errors, then save with Ctrl+S.
Close Outlook completely and reopen it. Create a test mail addressed to yourself.
Include a forbidden phrase, click Send, and check the warning. Cancel the send, fix the phrase, and try again.
If something goes wrong
No warning: check the switch, subject keyword, installed code and Outlook restart.
Duplicate name error: check for two Application_ItemSend procedures or duplicate functions.
Other subjects are checked: see whether the scope is All mail.
Sending stays blocked: fix the reported condition, or disable it in LAVL and apply the regenerated code.
Feature-by-feature reference · 21 features
Subject template placeholders
Example card in PRO: compare its settings with your screen.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter [Customer]. Subject “[Customer] update” warns; “Alex update” does not trigger this check.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Body template placeholders
Example card in PRO: compare its settings with your screen.
Detect unfinished text left in a mail body.
Setting
Example or available choices
One per line
[Contact name]
[Details to confirm]
Scope
All messages / Matching subjects only
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter [Contact]. A body that still contains [Contact] triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Maximum subject length
Example card in PRO: compare its settings with your screen.
Warn when the subject is longer than your limit.
Setting
Example or available choices
Maximum characters
120
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 80 characters. A 95-character subject triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Too many recipients
Example card in PRO: compare its settings with your screen.
Check the total number of To, CC and BCC recipients.
Setting
Example or available choices
Maximum recipients
15
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set the limit to 15. A mail addressed to 16 people triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Sensitive information terms
Example card in PRO: compare its settings with your screen.
Look for terms you choose in the subject and body.
Setting
Example or available choices
General terms, one per line
National ID number
Bank account number
Password
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter “password”. A body containing “temporary password” triggers a warning; this does not detect every possible secret.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Same subject sent again too soon
Example card in PRO: compare its settings with your screen.
Remember the last subject and send time during the Outlook session.
Setting
Example or available choices
Confirm Time(seconds)
60
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 60 seconds. Sending the same subject again within that period triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
All-uppercase English subject
Example card in PRO: compare its settings with your screen.
Flag English subjects written mostly in capitals.
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
“PLEASE REVIEW TODAY” may trigger a warning. Use “Please review today” for a calmer subject.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Repeated punctuation
Example card in PRO: compare its settings with your screen.
Warn about too many consecutive exclamation or question marks.
Setting
Example or available choices
Minimum repeated marks
3
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set the repetition count to 3. “Update!!!” triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Minimum body length
Example card in PRO: compare its settings with your screen.
Warn when the body has fewer characters than the configured minimum.
Setting
Example or available choices
Minimum characters
20
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 20. A body containing only “Thanks” triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Additional CC beyond shared addresses
Example card in PRO: compare its settings with your screen.
Require at least one CC address outside the shared-address list for target subjects.
Setting
Example or available choices
Shared CC
team-a@example.com
team-b@example.com
Subject triggers
[Collaboration]
[External request]
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set subject “Quote” and shared CC team@example.com. CC containing only that address warns; adding alex@example.com provides an additional CC.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Check each required CC
Example card in PRO: compare its settings with your screen.
Check that every required address is included in CC.
Setting
Example or available choices
One per line
Enter your own value
Scope
Matching subjects only / All messages
Matching subjects (one per line; blank = all messages)
Example: [Report]
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Require team@example.com and review@example.com. If review@example.com is missing, it is listed in the warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Duplicate recipients
Example card in PRO: compare its settings with your screen.
Look for the same recipient in To, CC or BCC more than once.
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
alex@example.com in both To and CC triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Blocked addresses or domains
Example card in PRO: compare its settings with your screen.
Warn if a recipient matches a configured blocked address or domain.
Setting
Example or available choices
One item per line
person@example.com
@external.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Block old@example.com. A mail addressed to that address triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
External recipients
Example card in PRO: compare its settings with your screen.
Treat addresses outside your internal-domain list as external.
Setting
Example or available choices
Internal domains
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register example.com as internal. client@outside.test is external and triggers the check.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
External recipients with attachments
Example card in PRO: compare its settings with your screen.
Warn when a mail combines an external recipient and an attachment.
Setting
Example or available choices
Internal domains
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
With example.com as internal, a PDF sent to client@outside.test triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Many visible external recipients
Example card in PRO: compare its settings with your screen.
Warn when too many external addresses are visible in To or CC.
Setting
Example or available choices
External recipient limit
5
Internal domains
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set a threshold of 5. Five external addresses in To/CC trigger a warning suggesting BCC review.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Confidential text sent externally
Example card in PRO: compare its settings with your screen.
Combine confidential keywords with an external-recipient check.
Setting
Example or available choices
Sensitive terms, one per line
Confidential
HR information
Payroll
Contract
confidential
salary
Internal domains
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register “salary” and internal domain example.com. “Salary review” sent outside that domain triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Personal email domains
Example card in PRO: compare its settings with your screen.
Flag recipients on the personal-mail domains you list.
Setting
Example or available choices
Domains to check, one per line
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register gmail.com. Sending to a Gmail address triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Attachment required
Example card in PRO: compare its settings with your screen.
Check that a target mail has at least one attachment.
Setting
Example or available choices
Range
Only matching subjects / All emails
Required subject text (one per line; blank = all subjects)
e.g. [Report]
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Target subject “Report”. “Weekly Report” without an attachment triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Total attachment size
Example card in PRO: compare its settings with your screen.
Check the combined size of all attachments.
Setting
Example or available choices
Size (MB)
20
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 20MB. Attachments totaling 25MB trigger a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Risky file extensions
Example card in PRO: compare its settings with your screen.
Look for attachment extensions you choose.
Setting
Example or available choices
Details
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register .exe. An attached program.exe triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
The illustrations show PRO. In FREE, use only the features and fields described below. Additional condition rows and other PRO controls shown in a picture are unavailable in FREE.
PRO screen: use the left menu to choose a feature.
Excel
1. Read a cell address
A2 means column A, row 2. A2:A4 means the three cells A2, A3 and A4. A:A means all of column A. Data usually starts at row 2 when row 1 contains headings.
2. Try a sum yourself
Enter 10 in Excel cell A2, 20 in A3 and 30 in A4.
In LAVL, choose Easy formula builder → Range sum.
Set the range to A2:A4. The range picker is a practice grid; it does not read your actual Excel file.
Click Copy formula. The formula is =SUM(A2:A4).
Paste it into empty cell B2 in Excel and press Enter. The result is 60.
Keep the result cell outside A2:A4 so that the formula does not refer to itself.
Put 0.1 in D1 and =A2*$D$1 in B2. Copy it to B3: it becomes =A3*$D$1. The rate still comes from D1.
4. What FREE includes
FREE provides eight basic calculation formulas. VBA macros and advanced formulas are PRO features. The card reference below covers only the formulas available in FREE.
Understand common formula errors
#NAME?: check the function name and Excel version.
#VALUE!: check data types and range sizes.
#DIV/0!: check whether a denominator is zero.
#SPILL!: clear cells blocking a multi-cell result.
Formula appears as text: change the cell format to General, then press F2 and Enter.
Separator error: regional settings may require semicolons instead of commas.
Card-by-card reference · 8 cards
Range sum
Example card in PRO: compare its settings with your screen.
Worked example
10, 20 and 30 total 60.
Input
Starting example
Text Range
B2:B100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=SUM(B2:B100)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Average
Example card in PRO: compare its settings with your screen.
Worked example
10, 20 and 30 average 20.
Input
Starting example
Average Range
C2:C100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=AVERAGE(C2:C100)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Round a number
Example card in PRO: compare its settings with your screen.
Worked example
Round 12.345 to 2 decimal places: 12.35.
Input
Starting example
Number Cell
D2
Decimal Places
0
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=ROUND(D2,0)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Sum visible rows
Example card in PRO: compare its settings with your screen.
Worked example
After filtering, sum only the rows still visible.
Input
Starting example
Sum Range
E2:E100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=SUBTOTAL(109,E2:E100)
Compatibility: Excel 2007+
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Percentage change
Example card in PRO: compare its settings with your screen.
Worked example
Previous 100, current 120: (120-100)/100 = 20%. Format the result as Percentage.
Input
Starting example
Value Cell
B2
Current Value Cell
C2
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=IFERROR((C2-B2)/B2,0)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Maximum value
Example card in PRO: compare its settings with your screen.
Worked example
The maximum of 10, 20 and 30 is 30.
Input
Starting example
Number Range
D2:D100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=MAX(D2:D100)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Minimum value
Example card in PRO: compare its settings with your screen.
Worked example
The minimum of 10, 20 and 30 is 10.
Input
Starting example
Number Range
D2:D100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=MIN(D2:D100)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Rank values
Example card in PRO: compare its settings with your screen.
Worked example
Find each score’s rank within a score range.
Input
Starting example
Current Value
D2
All Range
$D$2:$D$100
Sequence(0=Value 1up)
0
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=RANK.EQ(D2,$D$2:$D$100,0)
Compatibility: Excel 2010+
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
The illustrations show PRO. In FREE, use only the features and fields described below. Additional condition rows and other PRO controls shown in a picture are unavailable in FREE.
PRO screen: use the left menu to choose a feature.
AutoHotkey
1. What AutoHotkey is
AutoHotkey is a Windows program that performs mouse moves, clicks and typing in a chosen order. LAVL creates a .ahk script for those actions. Install AutoHotkey v2 to run it. This edition generates v2 scripts.
2. Your first practice in Notepad
Open Notepad and create a blank document.
In LAVL’s AutoHotkey tool, set the macro name to Practice.
Use hotkey ^Numpad8. The symbol ^ means Ctrl, so this is Ctrl+numeric keypad 8. Choose an available combination if your keyboard has no numeric keypad.
Add a Type text card and enter Hello, this is a practice message..
Save the AHK file. Check that its filename ends in .ahk.
Double-click the saved file to run it. A running script appears in the Windows notification area.
Click Notepad’s typing area, then press your hotkey. The practice sentence should appear.
When finished, right-click the script icon in the notification area and choose Exit.
3. Use coordinates
X is the horizontal position and Y is the vertical position. The values depend on the selected coordinate mode. Do not mix screen and active-window coordinates.
Download and run the helper. Place the mouse at your target point and press Ctrl+Alt+1 to copy its coordinates.
Paste into the X field of a move or coordinate-click card. Check that X and Y are both filled.
Keep the target window in the same position and size. Test a move card first.
Add a click only after verifying the point. Recheck coordinates after changing screen resolution, scaling or window position.
4. Order and waits
Cards run from top to bottom. Drag them to reorder them and remove unused cards. Increase recognition or completion waits if the program needs more time. 500ms is half a second.
Example sequence
Move to an input field → left-click → type text. Typing before clicking may put the text in the wrong place.
5. Four FREE cards
FREE provides move, left-click, double-click and text-entry cards. Extended actions are PRO features. Start with the Notepad example and a short typing sequence.
Hotkey does nothing: check that the .ahk file is running, v2 is installed, the hotkey is free and the intended window is active.
Old behavior after editing: save the new AHK file, exit the previous script and run the new file.
With the helper running, use Win+Esc for an emergency stop. To close a script fully, choose Exit from its notification-area icon.
Action-by-action reference · 4 cards
Move to coordinates
Example card in PRO: compare its settings with your screen.
Worked example
Move the pointer to X 300, Y 200 without clicking.
Click the matching action to add one card.
Fill in the text, coordinates, key or image settings shown on that card.
Place it in the intended order. Add a suitable wait for the target program to respond.
Save the new AHK file, run it, and test the hotkey in a practice window.
Left-click
Example card in PRO: compare its settings with your screen.
Worked example
Click once at the current pointer position.
Click the matching action to add one card.
Fill in the text, coordinates, key or image settings shown on that card.
Place it in the intended order. Add a suitable wait for the target program to respond.
Save the new AHK file, run it, and test the hotkey in a practice window.
Double-click
Example card in PRO: compare its settings with your screen.
Worked example
Double-click a file icon at the current pointer position.
Click the matching action to add one card.
Fill in the text, coordinates, key or image settings shown on that card.
Place it in the intended order. Add a suitable wait for the target program to respond.
Save the new AHK file, run it, and test the hotkey in a practice window.
Type text
Example card in PRO: compare its settings with your screen.
Worked example
Enter Hello to type that sentence in the focused input field.
Click the matching action to add one card.
Fill in the text, coordinates, key or image settings shown on that card.
Place it in the intended order. Add a suitable wait for the target program to respond.
Save the new AHK file, run it, and test the hotkey in a practice window.
Getting started
1. What LAVL does
LAVL creates code from the settings you choose. A card is one feature. Code is a set of instructions for another program. Choosing a card does not immediately change Outlook or Excel. You must apply the generated code in that program.
Example
Turn on “Attachment required” → LAVL creates VBA code → after you put that code in Outlook, it checks attachments when you click Send.
2. Start in six small steps
Save the HTML file on your PC. Its name should end in .html.
Double-click it to open it in Edge or Chrome.
Choose Outlook VBA, Excel, or AutoHotkey at the top.
Start with one feature and enter its settings. Use practice data first.
Review the output on the right. Copy it or save it as a file.
Follow the instructions for that program below and check the result.
3. A small dictionary
VBA / macro
Instructions that run inside Outlook or Excel to perform a task.
Formula
A calculation placed in a cell, such as =SUM(A2:A4).
Keyword
A word used to choose which item to check. “Report” matches a subject containing Report.
To / CC / BCC
Main recipients / carbon copy / blind carbon copy. BCC addresses are hidden from the other recipients.
Folder path
A folder location, such as C:\Work\Reports.
JSON
A file that stores your card settings. It is not a macro to run in Outlook or Excel.
Milliseconds (ms)
1000ms is one second; 500ms is half a second.
4. Saving settings is different from applying code
Browser settings are intended for use on the same PC and in the same browser. Keep an exported settings JSON or a LAVL-generated code file too, where the tool supports it. This helps when you move to another PC or clear browser data.
After changing cards, copy the new code and replace the previous generated code in the target program. Changing this HTML does not update code already installed in Outlook or Excel.
Official reference links
The instructions are built into this file. These optional links need internet access.
PRO screen: use the left menu to choose a feature.
Mail test example
Quote#1234 [Customer] has a valid number but still contains a forbidden placeholder, so it produces a warning. Quote#1234 Acme meets this example condition.
Mail test example
Format check example
Quote# followed by four digits is required. [Customer] is forbidden. Select the block to change Required / Optional / Forbidden.
Format check example
Custom rule example
Subject contains Quote, body lacks Delivery date → show a warning. A different subject is outside this rule.
Custom rule example
Outlook VBA
1. Check your Outlook version
Use classic Outlook for Windows. New Outlook and browser mail do not run this VBA code. If your workplace blocks macros, ask your IT team about the approved setup.
2. Build your first check
Open Basic send checks.
Turn on Subject template placeholders.
Enter [Customer] as a phrase to detect. Put separate phrases on separate lines.
[Customer] document update should trigger this check. Alex document update should not trigger it.
Review the code on the right. Other enabled checks may still produce their own warnings.
3. Use different conditions for different subjects
Choose Specific subjects only.
For the first condition, enter subject keyword Quote and forbidden phrase [Amount].
Use + Add template to add a second condition. Enter keyword Schedule and forbidden phrase [Date].
Quote update [Amount] triggers the first condition. Schedule update [Date] triggers the second.
A subject-specific condition needs a subject keyword. Read the status message and complete missing values.
4. Format checks: WHEN → CHECK → RESULT
WHEN selects the mail. CHECK describes the required content. RESULT says what happens if it does not match.
Set the subject keyword to Report.
Choose Body as the location to check.
Add a fixed-text block Total quantity: and a number block allowing 1 to 5 digits.
Total quantity: 120 is a passing example. Total quantity: pending fails because no number is present.
A required block must appear. An optional block may be absent. Must not be present forbids that content.
Choose a warning popup or a sending block in RESULT. A sending block requires the problem to be fixed.
Test independent conditions first. A linked condition runs only after its prerequisite passes. If conditions share subject keywords, test their priority order too.
5. Understand the mail preview
Enter a sample subject, body, To, CC and attachment count. Results refresh when settings change. If the preview lists enabled checks not evaluated, it has not tested those checks. Actual attachment sizes, extensions and resolved account addresses require an Outlook test.
Test both outcomes
Try one mail containing the forbidden phrase and one with it removed. Then send a practice mail to yourself in Outlook and compare the warning.
6. Apply the code in Outlook
Open File → Options → Customize Ribbon and select Developer.
Open Developer → Visual Basic, or press Alt+F11.
Double-click Microsoft Outlook Objects → ThisOutlookSession in Project Explorer. Press Ctrl+R if the explorer is hidden.
Back up any existing code in a text file. If it contains your own code, check how it should be merged before replacing it.
Click Copy code in LAVL and paste the generated code into ThisOutlookSession. Replace the previous complete LAVL code. Do not add a second Application_ItemSend procedure.
Choose Debug → Compile VBAProject to check for errors, then save with Ctrl+S.
Close Outlook completely and reopen it. Create a test mail addressed to yourself.
Include a forbidden phrase, click Send, and check the warning. Cancel the send, fix the phrase, and try again.
7. Run button-based mail tasks
Template mail, reply drafts and selected-mail saving are separate macros. They do not run automatically when you click Send.
For a composing task, open a mail draft. For a saving task, select the target mails in the Outlook mail list.
Use Alt+F8 or Developer → Macros, choose the generated public macro, and run it.
For a reusable button, open File → Options → Quick Access Toolbar, choose commands from Macros, then add your macro.
For Outlook features with a typed folder path, create that folder first. These differ from the Excel PDF folder picker.
If something goes wrong
No warning: check the switch, subject keyword, installed code and Outlook restart.
Duplicate name error: check for two Application_ItemSend procedures or duplicate functions.
Other subjects are checked: see whether the scope is All mail.
Sending stays blocked: fix the reported condition, or disable it in LAVL and apply the regenerated code.
Feature-by-feature reference · 46 features
Subject template placeholders
Example card in PRO: compare its settings with your screen.
Two subject conditions: Quote uses [Customer]; Schedule uses [Project]. Set the scope to Specific subjects, enter Quote in the first subject field, then use Add template / Add condition to add Schedule. A subject containing neither keyword does not use these conditions. If both keywords appear, both conditions apply.
Field in the picture
Example setting
One per line
[Customer]
Range
Only matching subjects
Subject keywords (one per line; match text contained in the subject)
Quote
Detect unfinished text left in a subject.
Setting
Example or available choices
One per line
[Customer]
[Document number]
[Action taken]
Range
All emails / Only matching subjects
Subject keywords (one per line; match text contained in the subject)
Example: [Report]
Example: Work completed
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter [Customer]. Subject “[Customer] update” warns; “Alex update” does not trigger this check.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Body template placeholders
Example card in PRO: compare its settings with your screen.
Two subject conditions: Quote uses [Date]; Schedule uses [Time]. Set the scope to Specific subjects, enter Quote in the first subject field, then use Add template / Add condition to add Schedule. A subject containing neither keyword does not use these conditions. If both keywords appear, both conditions apply.
Field in the picture
Example setting
One per line
[Date]
Range
Only matching subjects
Subject keywords (one per line; match text contained in the subject)
Quote
Detect unfinished text left in a mail body.
Setting
Example or available choices
One per line
[Contact]
[Details to review]
Range
All emails / Only matching subjects
Subject keywords (one per line; match text contained in the subject)
Example: [Report]
Example: Work completed
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter [Contact]. A body that still contains [Contact] triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Maximum subject length
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Maximum characters
120
Warn when the subject is longer than your limit.
Setting
Example or available choices
Maximum characters
120
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 80 characters. A 95-character subject triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Too many recipients
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Maximum recipients
15
Check the total number of To, CC and BCC recipients.
Setting
Example or available choices
Maximum recipients
15
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set the limit to 15. A mail addressed to 16 people triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Sensitive information terms
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
General terms, one per line
national ID
bank account number
password
Look for terms you choose in the subject and body.
Setting
Example or available choices
General terms, one per line
national ID
bank account number
password
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter “password”. A body containing “temporary password” triggers a warning; this does not detect every possible secret.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Same subject sent again too soon
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Confirm Time(seconds)
60
Remember the last subject and send time during the Outlook session.
Setting
Example or available choices
Confirm Time(seconds)
60
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 60 seconds. Sending the same subject again within that period triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
All-uppercase English subject
Example card in PRO: compare its settings with your screen.
Flag English subjects written mostly in capitals.
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
“PLEASE REVIEW TODAY” may trigger a warning. Use “Please review today” for a calmer subject.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Repeated punctuation
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Minimum repeated marks
3
Warn about too many consecutive exclamation or question marks.
Setting
Example or available choices
Minimum repeated marks
3
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set the repetition count to 3. “Update!!!” triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Minimum body length
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Minimum characters
20
Warn when the body has fewer characters than the configured minimum.
Setting
Example or available choices
Minimum characters
20
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 20. A body containing only “Thanks” triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Additional CC beyond shared addresses
Example card in PRO: compare its settings with your screen.
Two subject conditions: Quote uses team@example.com; Schedule uses shared@example.com. Set the scope to Specific subjects, enter Quote in the first subject field, then use Add template / Add condition to add Schedule. A subject containing neither keyword does not use these conditions. If both keywords appear, both conditions apply.
Field in the picture
Example setting
Shared CC
team@example.com
Subject triggers
Quote
Require at least one CC address outside the shared-address list for target subjects.
Setting
Example or available choices
Shared CC
team-a@example.com
team-b@example.com
Subject triggers
[Collaboration]
[External request]
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set subject “Quote” and shared CC team@example.com. CC containing only that address warns; adding alex@example.com provides an additional CC.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Check each required CC
Example card in PRO: compare its settings with your screen.
Two subject conditions: Quote uses review@example.com; Schedule uses planner@example.com. Set the scope to Specific subjects, enter Quote in the first subject field, then use Add template / Add condition to add Schedule. A subject containing neither keyword does not use these conditions. If both keywords appear, both conditions apply.
Field in the picture
Example setting
One per line
review@example.com
Range
Only matching subjects
Subjects to check (one phrase per line · included in subject)
Quote
Check that every required address is included in CC.
Setting
Example or available choices
One per line
review@example.com
archive@example.com
Range
Only matching subjects / All emails
Subjects to check (one phrase per line · included in subject)
Example: [Report]
Example: Work completed
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Require team@example.com and review@example.com. If review@example.com is missing, it is listed in the warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Duplicate recipients
Example card in PRO: compare its settings with your screen.
Look for the same recipient in To, CC or BCC more than once.
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
alex@example.com in both To and CC triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Blocked addresses or domains
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
One per line
person@example.com
Warn if a recipient matches a configured blocked address or domain.
Setting
Example or available choices
One per line
person@example.com
@external.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Block old@example.com. A mail addressed to that address triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
External recipients
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Internal domains
@example.com
Treat addresses outside your internal-domain list as external.
Setting
Example or available choices
Internal domains
@example.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register example.com as internal. client@outside.test is external and triggers the check.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
External recipients with attachments
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Internal domains
@example.com
Warn when a mail combines an external recipient and an attachment.
Setting
Example or available choices
Internal domains
@example.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
With example.com as internal, a PDF sent to client@outside.test triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Many visible external recipients
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
External recipient limit
5
Internal domains
@example.com
Warn when too many external addresses are visible in To or CC.
Setting
Example or available choices
External recipient limit
5
Internal domains
@example.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set a threshold of 5. Five external addresses in To/CC trigger a warning suggesting BCC review.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Confidential text sent externally
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Sensitive terms, one per line
Confidential
HR information
Payroll
Contract
confidential
salary
Internal domains
@example.com
Combine confidential keywords with an external-recipient check.
Setting
Example or available choices
Sensitive terms, one per line
Confidential
HR information
Payroll
Contract
confidential
salary
Internal domains
@example.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register “salary” and internal domain example.com. “Salary review” sent outside that domain triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Personal email domains
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Domains to check, one per line
@gmail.com
@yahoo.com
@hotmail.com
@outlook.com
Flag recipients on the personal-mail domains you list.
Setting
Example or available choices
Domains to check, one per line
@gmail.com
@yahoo.com
@hotmail.com
@outlook.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register gmail.com. Sending to a Gmail address triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Attachment required
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Range
Only matching subjects
Required subject text (one per line; blank = all subjects)
e.g. [Report]
Check that a target mail has at least one attachment.
Setting
Example or available choices
Range
Only matching subjects / All emails
Required subject text (one per line; blank = all subjects)
e.g. [Report]
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Target subject “Report”. “Weekly Report” without an attachment triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Total attachment size
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Size (MB)
20
Check the combined size of all attachments.
Setting
Example or available choices
Size (MB)
20
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 20MB. Attachments totaling 25MB trigger a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Risky file extensions
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Details
.exe,.bat,.cmd,.js,.vbs,.ps1
Look for attachment extensions you choose.
Setting
Example or available choices
Details
.exe,.bat,.cmd,.js,.vbs,.ps1
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register .exe. An attached program.exe triggers a warning.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Automatically add CC
Example card in PRO: compare its settings with your screen.
Two subject conditions: Quote uses review@example.com; Schedule uses planner@example.com. Set the scope to Specific subjects, enter Quote in the first subject field, then use Add template / Add condition to add Schedule. A subject containing neither keyword does not use these conditions. If both keywords appear, both conditions apply.
Field in the picture
Example setting
Range
Only matching subjects
Add CC addresses after the user accepts send warnings.
Setting
Example or available choices
Details
team@company.com; office@company.com
Range
All emails / Only matching subjects
Subject keywords
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Target subject “Quote”; add review@example.com. A matching mail receives that CC before sending.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Automatically add BCC
Example card in PRO: compare its settings with your screen.
Two subject conditions: Quote uses archive@example.com; Schedule uses records@example.com. Set the scope to Specific subjects, enter Quote in the first subject field, then use Add template / Add condition to add Schedule. A subject containing neither keyword does not use these conditions. If both keywords appear, both conditions apply.
Field in the picture
Example setting
Range
Only matching subjects
Add BCC addresses after the user accepts send warnings.
Setting
Example or available choices
Details
Enter your own value
Range
All emails / Only matching subjects
Subject keywords
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Target “Report”; add archive@example.com. A matching mail receives that BCC.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Subject prefix and suffix
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
front
[Enter text]
Add fixed text to the start or end of a subject.
Setting
Example or available choices
front
[Enter text]
back
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Prefix “[Review] ” turns “Monthly report” into “[Review] Monthly report”.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Mail importance
Example card in PRO: compare its settings with your screen.
Set the outgoing mail importance.
Setting
Example or available choices
Option 2Option 1Option 0
Option 2 / Option 1 / Option 0
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Choose High. The mail is marked as high importance before sending.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Read and delivery receipts
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Confirm text
true
Confirm text
false
Request a read receipt, delivery receipt, or both.
Setting
Example or available choices
readReceipt
On / Off
deliveryReceipt
On / Off
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enable Read receipt. A recipient may decline it, so receiving a receipt is not guaranteed.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Delayed delivery
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
minutes
2
Set a future delivery time.
Setting
Example or available choices
minutes
2
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set 2 minutes. Outlook schedules delivery for two minutes later; actual delivery depends on Outlook and the account.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Body font
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Size
10
Apply a configured font and size to the outgoing body.
Setting
Example or available choices
Font name
Enter your own value
Size
10
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Choose Arial, 10pt. Test whether the final message appearance is acceptable.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Table borders and sizing
Example card in PRO: compare its settings with your screen.
Apply solid borders and content-based sizing to mail tables.
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
A table with inconsistent borders is formatted before sending.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Highlight words
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
One per line
Important
Needs review
Highlight the selected keywords in yellow.
Setting
Example or available choices
One per line
Important
Needs review
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register “Urgent”. That word is highlighted where it appears in the body.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Replace subject text
Example card in PRO: compare its settings with your screen.
Replace one phrase with another in the subject.
Setting
Example or available choices
Find in subject
Text to find
Replace with
Replacement text
subjectReplacements
Review request => Review request
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set “Old name => New name”. The matching subject phrase is replaced.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Replace body text
Example card in PRO: compare its settings with your screen.
Replace one phrase with another in the body.
Setting
Example or available choices
Find in body
Text to find
Replace with
Replacement text
bodyReplacements
[Contact] => Alex Kim
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set “[Contact] => Alex”. The placeholder becomes Alex.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Insert text at the top
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Text to insert
Hello.
Add a fixed opening to the mail body.
Setting
Example or available choices
Text to insert
Hello.
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter “Hello,”. It is inserted before the existing body.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Insert text at the bottom
Example card in PRO: compare its settings with your screen.
Add a fixed closing to the mail body.
Setting
Example or available choices
Text to insert
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter “Thank you.”. It is inserted after the existing body.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Highlight matching lines
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
One per line
*
Highlight an entire paragraph containing a keyword.
Setting
Example or available choices
One per line
*
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register “Urgent”. The paragraph “Urgent: review today” is highlighted.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Insert an image at a placeholder
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Image pathEnter the full file path. Quotation marks added when copying a path are removed automatically.
C:\Work\image.png
Replace a configured text marker with an image file.
Setting
Example or available choices
Text to find
Enter your own value
Image path
C:\Work\image.png
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Put [Image] in the body and set an existing PNG path. Test that the picture replaces the marker.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
Applied settings: this card is included in the generated code.
Create a standard mail draft
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Macro name · letters, digits, underscores
CreateTemplateMail
Subject
[Work]
Outlook Keep default signature
true
Create a new draft with preset recipients, subject, body and attachments.
Setting
Example or available choices
Macro name · letters, digits, underscores
CreateTemplateMail
To
Enter your own value
CC
Enter your own value
Subject
[Work]
Body
Enter your own value
templateKeepSignature
On / Off
Attachment paths, one per line
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Save a “Monthly update” template. Running its macro opens a draft for review; it does not automatically send it.
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Create a reply draft
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
CreateReplyDraft
Opening text for reply
Hello.
I will review this and reply.
Method
Reply
Open a reply to the selected mail with a preset opening.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
CreateReplyDraft
Opening text for reply
Hello.
I will review this and reply.
Method
Reply / Reply all / Forward
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Select one mail and run the macro. A reply draft opens with “I will review this and reply.”
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Remove your address from Reply All
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
SMTP addresses (one per line)
my.name@company.com
Remove configured personal addresses from a Reply All draft.
Setting
Example or available choices
SMTP addresses (one per line)
my.name@company.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Register your address. It is removed from To/CC in the generated Reply All draft.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
This is an option for the reply-draft macro. Enable the main reply-draft feature as well.
Applied settings: this card is included in the generated code.
Choose a reply account
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
can be used SMTP Address
shared@company.com
Use a matching configured Outlook account for a reply draft.
Setting
Example or available choices
can be used SMTP Address
shared@company.com
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Enter shared@example.com, an account already added in Outlook. Check the draft’s From account.
Apply the generated code in Outlook and test the feature using a mail addressed to yourself.
This is an option for the reply-draft macro. Enable the main reply-draft feature as well.
Applied settings: this card is included in the generated code.
Insert standard text in an open draft
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
InsertStandardTextToCurrentMail
Add reusable text to the mail you are composing.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
InsertStandardTextToCurrentMail
Text to insert
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Open a draft and run the macro to insert “Please review the attached document.”
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Attach fixed files to an open draft
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
AddFixedAttachmentsToCurrentMail
Attach files from the paths you list.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
AddFixedAttachmentsToCurrentMail
Attachment paths, one per line
Enter your own value
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
List C:\Work\Guide.pdf. Run the macro in a draft and check the added attachment.
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Rename attached files
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
RenameCurrentMailAttachments
Rename matching mail attachments without changing the original files.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
RenameCurrentMailAttachments
Find in attachment name
Text to find
Replace with
Replacement text
attachmentRenameRules
Final
Report => Report">
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Set “draft => final”. Check the attachment name in the draft before sending.
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Save selected-mail attachments
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
SaveSelectedMailAttachments
Save Folder
C:\Work\Attachments
Date at start of filename
Add
Save attachments from mails selected in the Outlook mail list.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
SaveSelectedMailAttachments
Save Folder
C:\Work\Attachments
Date at start of filename
Add / Do not add
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Create C:\Work\Attachments, select two mails, and run the macro. Check the saved files in that folder.
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Save selected mails as MSG
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
SaveSelectedMailsAsMsg
Save Folder
C:\Work\MailArchive
Save selected mails as individual Outlook message files.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
SaveSelectedMailsAsMsg
Save Folder
C:\Work\MailArchive
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Create C:\Work\MailArchive, select mails in the list, and run the saving macro.
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
Export a selected-mail list to CSV
Example card in PRO: compare its settings with your screen.
Field in the picture
Example setting
Alt+F8 Macro name · letters, digits, underscores
ExportSelectedMailsToCsv
CSV All Path
C:\Work\Exports
Write a list of selected mails to a CSV output.
Setting
Example or available choices
Alt+F8 Macro name · letters, digits, underscores
ExportSelectedMailsToCsv
CSV All Path
C:\Work\Reports
Find this feature and turn on its switch.
Fill in the settings above. Replace example addresses, words and folder paths with your own values.
If the scope is specific subjects, enter a subject keyword. Test one matching subject and one non-matching subject.
Worked example
Choose a destination folder, select mails, run the macro, then open the resulting CSV in Excel.
Apply the generated code, then run the named macro from Outlook’s macro list.
Applied settings: this card is included in the generated code.
PRO screen: use the left menu to choose a feature.
Excel
1. Read a cell address
A2 means column A, row 2. A2:A4 means the three cells A2, A3 and A4. A:A means all of column A. Data usually starts at row 2 when row 1 contains headings.
2. Try a sum yourself
Enter 10 in Excel cell A2, 20 in A3 and 30 in A4.
In LAVL, choose Easy formula builder → Range sum.
Set the range to A2:A4. The range picker is a practice grid; it does not read your actual Excel file.
Click Copy formula. The formula is =SUM(A2:A4).
Paste it into empty cell B2 in Excel and press Enter. The result is 60.
Keep the result cell outside A2:A4 so that the formula does not refer to itself.
Put 0.1 in D1 and =A2*$D$1 in B2. Copy it to B3: it becomes =A3*$D$1. The rate still comes from D1.
4. Try a conditional sum
Enter Complete, Pending and Complete in A2:A4. Enter 100, 200 and 300 in B2:B4.
Choose the conditional-sum card. Set sum range to B2:B4, criteria range to A2:A4 and criterion to "Complete".
=SUMIFS(B2:B4,A2:A4,"Complete") returns 400.
Criteria and sum ranges must cover matching rows. Different range sizes can cause errors.
Check each card’s Excel version requirement. Functions such as XLOOKUP, FILTER and UNIQUE are not available in every older Excel version.
5. Apply an Excel VBA macro
Make a copy of your workbook and open that copy in Excel.
Use Save As → Excel Macro-Enabled Workbook (.xlsm). An .xlsx file cannot keep VBA macros.
Select a VBA card in LAVL and open the VBA output tab.
In Excel, press Alt+F11 → Insert → Module. Choose the correct workbook project.
Paste the complete generated code and save. Do not paste another copy of a macro with the same name below it.
Return to Excel and press Alt+F8. Select the macro name and run it.
Select the target cells first for operations that use the selected range. Try deletion operations on a copy.
6. Save PDFs and backup copies
Run a PDF or timestamped-backup macro. A destination folder picker opens.
Choose a folder. Cancel closes the macro without saving.
The active-sheet PDF is named SheetName.pdf. If it exists, the macro asks before replacing it.
The all-sheets macro exports each visible worksheet of the active workbook. A sheet is skipped if you decline to replace its existing PDF.
The backup macro copies the active workbook to a name such as Report_backup_20260930_051000.xlsm. The original stays in place. Save the original at least once before backing it up.
If the PDF layout is cut off, review Excel’s print area, page orientation, margins and scaling.
Understand common formula errors
#NAME?: check the function name and Excel version.
#VALUE!: check data types and range sizes.
#DIV/0!: check whether a denominator is zero.
#SPILL!: clear cells blocking a multi-cell result.
Formula appears as text: change the cell format to General, then press F2 and Enter.
Separator error: regional settings may require semicolons instead of commas.
Card-by-card reference · 63 cards
Range sum
Example card in PRO: compare its settings with your screen.
Worked example
10, 20 and 30 total 60.
Input
Starting example
Text Range
B2:B100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=SUM(B2:B100)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Average
Example card in PRO: compare its settings with your screen.
Worked example
10, 20 and 30 average 20.
Input
Starting example
Average Range
C2:C100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=AVERAGE(C2:C100)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Round a number
Example card in PRO: compare its settings with your screen.
Worked example
Round 12.345 to 2 decimal places: 12.35.
Input
Starting example
Number Cell
D2
Decimal Places
0
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=ROUND(D2,0)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Sum visible rows
Example card in PRO: compare its settings with your screen.
Worked example
After filtering, sum only the rows still visible.
Input
Starting example
Sum Range
E2:E100
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=SUBTOTAL(109,E2:E100)
Compatibility: Excel 2007+
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Percentage change
Example card in PRO: compare its settings with your screen.
Worked example
Previous 100, current 120: (120-100)/100 = 20%. Format the result as Percentage.
Input
Starting example
Value Cell
B2
Current Value Cell
C2
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=IFERROR((C2-B2)/B2,0)
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
IF condition
Example card in PRO: compare its settings with your screen.
Worked example
If A2 is 80 or more, show Pass; otherwise show Review.
Input
Starting example
Text Cell
C2
details
>=
TextValue
80
Text when
"Text"
Text when
"TextConfirm"
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=IF(C2>=80,"Text","TextConfirm")
Compatibility: All Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Conditional sum
Example card in PRO: compare its settings with your screen.
Worked example
Complete rows with amounts 100 and 300 total 400.
Input
Starting example
Sum Range
D2:D100
Condition Range
B2:B100
Condition
"Text"
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=SUMIFS(D2:D100,B2:B100,"Text")
Compatibility: Excel 2007+
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Conditional count
Example card in PRO: compare its settings with your screen.
Worked example
Two rows labeled Complete produce a count of 2.
Input
Starting example
Condition Range
B2:B100
Condition
"Complete"
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=COUNTIFS(B2:B100,"Complete")
Compatibility: Excel 2007+
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Look up a value
Example card in PRO: compare its settings with your screen.
Worked example
Find order A-1001 in the ID column and return its amount from another column.
Input
Starting example
Value
A2
Text Range
Text!A:A
Text Range
Text!C:C
Text when
"None"
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
=XLOOKUP(A2,Text!A:A,Text!C:C,"None")
Compatibility: Microsoft 365 / 2021+
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
INDEX and MATCH lookup
Example card in PRO: compare its settings with your screen.
Worked example
Find a product code and return a value even from a column to its left.
Input
Starting example
Value
A2
Text Range
Text!C:C
Text Range
Text!A:A
Choose the card and change its ranges to match your worksheet.
Copy only the formula starting with =, not the heading or explanation.
Paste it into an empty result cell outside the source range and press Enter.
Check the result on a small set of values before extending it to more rows.
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Convert data to an Excel table
Example card in PRO: compare its settings with your screen.
Worked example
Select a data block with headings and turn it into an Excel table.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Freeze the first row
Example card in PRO: compare its settings with your screen.
Worked example
Keep the first row visible while scrolling.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Show hidden sheets
Example card in PRO: compare its settings with your screen.
Worked example
Show worksheets hidden using Excel’s sheet visibility setting.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Save every visible sheet as PDF
Example card in PRO: compare its settings with your screen.
Worked example
Choose one folder and export each visible worksheet as a separate PDF.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Combine Excel files from a folder
Example card in PRO: compare its settings with your screen.
Worked example
Select a folder containing compatible Excel files and combine their rows.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Windows Text
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Split data into sheets by value
Example card in PRO: compare its settings with your screen.
Worked example
Create separate sheets for each distinct category in the reference column.
Input
Starting example
Text Column Text(A=1)
2
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Remove duplicate rows
Example card in PRO: compare its settings with your screen.
Worked example
Select a range and remove repeated rows using the macro’s reference column.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
Refresh queries and PivotTables
Example card in PRO: compare its settings with your screen.
Worked example
Refresh workbook queries, connections and PivotTables.
Choose the card, copy the VBA output, and paste it into a standard module in the target .xlsm workbook.
Select the target workbook or cells, then run the named macro with Alt+F8.
Review the changed cells or the saved files. PDF and backup cards ask for a folder when they run.
Compatibility: Text Excel
Example result shown by the tool. This is an illustration, not a calculation of your workbook.
PRO screen: use the left menu to choose a feature.
AutoHotkey
1. What AutoHotkey is
AutoHotkey is a Windows program that performs mouse moves, clicks and typing in a chosen order. LAVL creates a .ahk script for those actions. Install AutoHotkey v2 to run it. This edition generates v2 scripts.
2. Your first practice in Notepad
Open Notepad and create a blank document.
In LAVL’s AutoHotkey tool, set the macro name to Practice.
Use hotkey ^Numpad8. The symbol ^ means Ctrl, so this is Ctrl+numeric keypad 8. Choose an available combination if your keyboard has no numeric keypad.
Add a Type text card and enter Hello, this is a practice message..
Save the AHK file. Check that its filename ends in .ahk.
Double-click the saved file to run it. A running script appears in the Windows notification area.
Click Notepad’s typing area, then press your hotkey. The practice sentence should appear.
When finished, right-click the script icon in the notification area and choose Exit.
3. Use coordinates
X is the horizontal position and Y is the vertical position. The values depend on the selected coordinate mode. Do not mix screen and active-window coordinates.
Download and run the helper. Place the mouse at your target point and press Ctrl+Alt+1 to copy its coordinates.
Paste into the X field of a move or coordinate-click card. Check that X and Y are both filled.
Keep the target window in the same position and size. Test a move card first.
Add a click only after verifying the point. Recheck coordinates after changing screen resolution, scaling or window position.
4. Order and waits
Cards run from top to bottom. Drag them to reorder them and remove unused cards. Increase recognition or completion waits if the program needs more time. 500ms is half a second.
Example sequence
Move to an input field → left-click → type text. Typing before clicking may put the text in the wrong place.
5. Window and image conditions
Window activation searches by part of a window title. Image search looks for a registered picture on the screen. Start with a small button image and a narrow search area.
Set a window-activation card to the title of a practice program.
Add an image card and register a screenshot from the real screen.
Review timeout, skip and stop behavior when the image cannot be found.
Test once with the image visible and once with it absent. Scaling and dark mode may change the picture.
6. Merge several AHK files
Choose v2 project files containing LAVL card metadata. Give them different hotkeys. The merge stops if hotkeys overlap or functions share a name but have different code. Follow the tool’s instructions for standalone helpers; do not mix arbitrary v1 scripts into v2 projects.
