search

iappyx / Instrumenta

Free and open source consulting-style Powerpoint toolbar
MIT License
251 stars 20 forks source link

Mail merge: Run-time error '13' Type Mismatch #36

Closed mcgradem99 closed 3 months ago

mcgradem99 commented 1 year ago

Describe the bug When running mail merge (Manually replace merge all merge fields on all slides'), merge begins but then error box appears with message "Run-time error '13' Type Mismatch"

To Reproduce Steps to reproduce the behavior:

  1. Go to Advanced
  2. Click on Insert Empty Merge Field (or Insert Merge Fields from Excel)
  3. Manually replace all merge fields on all slides
  4. See error

Screenshots image

Desktop (please complete the following information): Edition Windows 10 Enterprise Version 21H2 Installed on ‎22/‎03/‎2022 OS build 19044.2965 Experience Windows Feature Experience Pack 1000.19041.1000.0

PowerPoint Version 2202 (Build 14931.21000 Click-to-Run)

iappyx commented 1 year ago

Can you provide an anonymized example of the excel that you use?

mcgradem99 commented 1 year ago

I stand corrected - it actually works fine if you use an Excel. It's the 'Manually replace merge all merge fields on all slides' option which produces the error (see images for example). Thank you :)

image image

iappyx commented 3 months ago

Fixed in the latest beta.