Email macro does not work proparly

[miicker]

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

[ItsMe]

When you run the Macro is there a report named "rptInvoice" open?

[miicker]

Yes the report is open when I use the macro (the macro is activated with a buton on that report)

[ItsMe]

Try changing
PDF Format (*.pdf)

to
acFormatPDF

[miicker]

I get the message "invalid value for the Output Format argument"

[June7]

You created db with English version of Excel? Why is Excel involved?

acFormatPDF is VBA constant. Try VBA event procedure instead of macro.

The examples show missing 'v' in rptInvoice:
To: =[Reports]![rptInvoice]![CEmail]

[miicker]

I'm sorry, I ment Access. But I solved the problem, figured out some fieldnames mismatched.

Thanks for the help anyway.