vba - MS Access VBA AppActivate“发送传真”和 SendKeys

Question

我正在向多功能传真机/打印机发送一系列访问报告。每个报告都是自定义的，需要转到特定的电话号码。我想自动化，但它一直卡在脚本应该输入数字并继续的地方。

DoCmd.PrintOut 'This works fine to print to the Fax

---

AppActivate "Send fax" 'This works as the window focus changes from MS Access to the Send fax dialog box

---

SendKeys "%f" & rst![Fax] 'This does not work and when I move the mouse around, I get a pointer when on the Send fax dialog box but a busy spinning circle when I move the mouse away from the dialog box.  It seems the process is hung up at AppActivate and not letting this part work.

---

SendKeys "%d99" 'This part would thus not work also

---

SendKeys "{Enter} 'This part would thus not work also

标签： vbams-accessms-access-2013sendkeysfax