Hello everyone, I had a DB with an email macro which worked.
I used the following Macro:
EMailDataBaseObject
Object Type: Report
Object Name: rptInvoice
Output Format: PDF Format (*.pdf)
To: =[Reports]![rptInoice]![CEmail]
Subject: ="Invoice: " & [Reports]![rptInvoice]![InvNr] & " " & [Reports]![rptInvoice]![Date]
Edit Message: Yes
This database was created with a Dutch version of Access, I've created another DB, with an English version of Excel, everything is working except for the macro to send an email.
When I use the following macro:
EMailDataBaseObject
Object Type: Report
Object Name: rptInvoice
Output Format: PDF Format (*.pdf)
To:
Subject:
Edit Message: Yes
It works, But I have to fill in the email address, the subject and everything in myself, and I don't want that.
but when I use:
EMailDataBaseObject
Object Type: Report
Object Name: rptInvoice
Output Format: PDF Format (*.pdf)
To: =[Reports]![rptInoice]![CEmail]
Subject:
Edit Message: Yes
I recieve the following error message:
When I run this macro:
EMailDataBaseObject
Object Type: Report
Object Name: rptInvoice
Output Format: PDF Format (*.pdf)
To:
Subject: ="Invoice: " & [Reports]![rptInvoice]![InvNr] & " " & [Reports]![rptInvoice]![Date]
Edit Message: Yes
I get the following error:
Maybe it's because I use a Dutch way of typing it, I have no idea. Can anyone help me please?
Kind regards,
Miicker