I have a report created from a quer

[GillinghamFC]

I have a report created from a query. Some clients want .rtf others may want .xls. I pass a variable "FileFormat" as a string from a table. The problem is the value is read as "acFormatRTF" not acFormatRTF. I have tryed Eval(FileFormat) but it still doesn't work.

Anyone have any ideas?

FileFormat is variable passed from a database table.

DoCmd.SendObject acSendReport, "DailyDealsAll", FileFormat, _
strToWhom, , , "Test Data", _
"", intSeeOutlook

 

[HowieG]

Try setting the value of FileFormat to one of:
"Microsoft Excel (*.xls)"
or
"Rich Text Format (*.rtf)"

The acFormatRTF and acFormatXLS are just constants with the values of the text strings shown above.

Type:

? acFormatRTF

in the immediate window to see what I mean.

 

[GillinghamFC]

works brilliantly!