Actions Tab - 5 Minute Quick Start

Actions Tab - 5 Minute Quick Start

🚀 Get Up and Running with Actions in 5 Minutes!

Three hands-on tutorials to learn Actions Tab fast. Pick your goal:

---

Quick Start 1: Create Your First Mail Merge

Goal: Generate 5 personalized letters in 2 minutes

What You'll Learn:

---

Step 1: Prepare Sample Data (30 seconds)

Copy this data and save as test-customers.csv:

``csv

FirstName,LastName,City

John,Smith,New York

Jane,Doe,Los Angeles

Bob,Johnson,Chicago

Alice,Williams,Houston

Charlie,Brown,Phoenix

`

How to save:

---

Step 2: Upload Data (20 seconds)

Data uploaded!

---

Step 3: Create Template (30 seconds)

In your Word document, type this letter:

`

Dear <> <>,

Thank you for contacting us from <>.

We appreciate your business!

Sincerely,

The Data Publisher Team

`

Important: Type the
<> exactly as shown!

Template ready!

---

Step 4: Run the Merge (40 seconds)

  • Click Actions tab
  • Click Merge sub-tab
  • In "Data File:" dropdown → Select test-customers.csv
  • In "Data Flow:" dropdown → Select One Per Page
  • Click the big "Run Action" button
  • Watch the progress indicator
  • Wait ~10 seconds

Merge complete!

---

Step 5: See Your Results (10 seconds)

You should now see a 5-page document:

Page 1:

`

Dear John Smith,

Thank you for contacting us from New York.

We appreciate your business!

Sincerely,

The Data Publisher Team

`

Page 2:

`

Dear Jane Doe,

Thank you for contacting us from Los Angeles.

...

`

...and so on for all 5 customers!

---

🎉 Congratulations!

You just created your first mail merge!

What you learned:

✅ Upload CSV data

✅ Use <>

✅ Run a merge with One Per Page

✅ Generate multiple personalized documents

Next steps:
  • Try with your own CSV file
  • Add more fields to template
  • Try different data flow options

---

Quick Start 2: Send Your First Email Campaign

Goal: Send 5 tracked emails in 3 minutes

What You'll Learn:
  • How to connect Microsoft account
  • Create email template
  • Use Email Campaign Wizard
  • View analytics

---

Step 1: Connect Microsoft Account (45 seconds)

  • Click Actions tab
  • Click Email Config sub-tab
  • Click "Connect Microsoft Account" button
  • Sign in popup opens
- Use your work email (Microsoft 365)

- Or personal (Outlook.com)

  • Grant permissions (click Allow/Accept)
  • Popup closes automatically
  • Back in add-in, click "Refresh Status"
  • Should show "
    ✅ Connected" with your email

Account connected!

---

Step 2: Prepare Email Data (30 seconds)

Create test-emails.csv:

`csv

FirstName,Email,Product

John,your.email+john@gmail.com,Widget Pro

Jane,your.email+jane@gmail.com,Gadget Plus

Bob,your.email+bob@gmail.com,Doohickey Max

Alice,your.email+alice@gmail.com,Gizmo Ultra

Charlie,your.email+charlie@gmail.com,Widget Pro

`

Important: Replace
your.email with YOUR actual email address!

Why +name? Gmail treats these as separate recipients but delivers to your inbox. Perfect for testing!

Save the file:

---

Step 3: Upload Email Data (20 seconds)

Data ready!

---

Step 4: Create Email Template (30 seconds)

Clear your Word document and type:

`

Hello <>,

Thank you for your interest in the <>!

We'd love to tell you more about it.

Click here to learn more: https://example.com/products

Best regards,

The Team

`

Email template ready!

---

Step 5: Launch Email Wizard (45 seconds)

Step 0 - Configuration:

---

Step 6: Generate & Send (60 seconds)

Step 1 - Generate Email Bodies:

Step 2 - Attachments:

Step 3 - Send Campaign: - Recipients: 5

- Subject: "Hello <>!"

- Tracking enabled

  • Click "Close"
  • Emails sent!

    ---

    Step 7: Check Your Inbox (30 seconds)

    Open your email inbox - you should see 5 emails:

    Open one email - it should say:

    `

    Hello John,

    Thank you for your interest in the Widget Pro!

    ...

    `

    Campaign successful!

    ---

    Step 8: View Analytics (20 seconds)

    `

    📧 Emails Sent: 5

    Campaign: Test Campaign

    Sent: (just now)

    Recipients: 5

    Opened: 0 (0%) ← Will update when you open emails!

    Clicked: 0 (0%)

    Replied: 0 (0%)

    `

    Refresh after opening emails:

    Analytics working!

    ---

    🎉 Congratulations!

    You just sent your first tracked email campaign!

    What you learned:

    ✅ Connect Microsoft account

    ✅ Create email templates

    ✅ Use Email Campaign Wizard

    ✅ Send tracked emails

    ✅ View analytics

    Next steps:

    ---

    Quick Start 3: Build Your First Complex Placeholder

    Goal: Create a formatted price placeholder visually in 2 minutes

    What You'll Learn:

    ---

    Step 1: Prepare Product Data (30 seconds)

    Create test-products.csv:

    `csv

    ProductName,Price,InStock

    Widget Pro,29.99,Yes

    Gadget Plus,49.99,No

    Doohickey Max,19.99,Yes

    Gizmo Ultra,39.99,Yes

    Thingamajig,24.99,No

    `

    Upload:

    Data uploaded!

    ---

    Step 2: Open Builder (10 seconds)

    ---

    Step 3: Start with Basic Field (20 seconds)

    Preview shows:
    <>

    Base field selected!

    ---

    Step 4: Add Currency Formatting (20 seconds)

    Preview updates to:
    {{FormatCurrency|<>}}

    Currency formatting added!

    ---

    Step 5: Add Default Value (20 seconds)

    Preview updates to:
    {{Default|{{FormatCurrency|<>}}|$0.00}}

    This means: "Show price as currency, or $0.00 if empty"

    Default value added!

    ---

    Step 6: Make It Bold (20 seconds)

    • Function Category: Select Visual Styling
    • Click the "Bold" card

    Preview updates to:
    {{Bold|{{Default|{{FormatCurrency|<>}}|$0.00}}}}

    This wraps everything in Bold styling!

    Bold styling added!

    ---

    Step 7: Insert Into Document (10 seconds)

    • Click in your Word document where you want the placeholder
    • Back in Builder, click "Insert into Document" button
    • The full placeholder code appears at your cursor!

    `

    {{Bold|{{Default|{{FormatCurrency|<>}}|$0.00}}}}

    `

    Placeholder inserted!

    ---

    Step 8: Test It with Merge (40 seconds)

    Let's see it in action:

    • In Word, type a simple template:
    `

    Product: <>

    Price: {{Bold|{{Default|{{FormatCurrency|<>}}|$0.00}}}}

    In Stock: <>

    `

    • Actions tab → Merge sub-tab
    • Data File: test-products.csv
    • Data Flow: One Per Page
    • Click "Run Action"
    • Wait ~5 seconds

    Result - Page 1:

    `

    Product: Widget Pro

    Price: $29.99 (in bold!)

    In Stock: Yes

    `

    If a product had no price, it would show:

    `

    Price: $0.00 (in bold!)

    `

    Complex placeholder working!

    ---

    🎉 Congratulations!

    You just built a complex placeholder without typing complicated syntax!

    What you learned:

    ✅ Use Builder Post-Processing tab

    ✅ Add data formatting functions

    ✅ Add conditional logic

    ✅ Add visual styling

    ✅ Chain multiple functions

    ✅ Test with real merge

    What you created:

    A placeholder that:

    • Formats numbers as currency ($29.99)
    • Shows default if empty ($0.00)
    • Makes it bold
    • All in one!

    ---

    Next Steps

    You've Completed All 3 Quick Starts! 🎉

    You now know:

    ✅ Mail merge basics

    ✅ Email campaigns

    ✅ Builder tool

    Continue Learning:

    Go Deeper:

    Try Advanced Features:
    • Conditionals: Show different content based on data values
    • Loops: Create invoices with line items
    • Email Tracking: Analyze open and click rates
    • Office 365 Integration: Send campaigns via Microsoft Graph

    Real-World Projects:
    • Personalized customer letters
    • Product catalogs
    • Email newsletters
    • Invoices and receipts
    • Real estate listings
    • Event invitations

    ---

    Quick Troubleshooting

    | Problem | Solution |

    |---------|----------|

    | Placeholders not replacing | Check <>` exactly matches CSV column |

    | No data files in dropdown | Upload CSV in Data → Files tab first |

    | Email wizard disabled | Connect Microsoft account in Email Config tab |

    | Merge takes forever | Start with small data file (5-10 rows) for testing |

    | Builder insert button disabled | Select data file + field first |

    ---

    💡 Pro Tips for Beginners

    • Always test with 5 rows first before using full dataset
    • Save your templates (Data → Files → Word Templates)
    • Use Builder instead of typing syntax manually - it's easier!
    • Check Email Config connection before sending campaigns
    • Monitor progress bars - they show time remaining
    • Keep Quick Ref handy - print ACTIONS_TAB_QUICK_REF.md

    ---

    🚀 You're now ready to automate your document workflows! Go forth and create amazing things!

    Remember: Actions Tab = Doing things with your data. You've mastered the basics - now explore the advanced features! 💪