the sendobject syntax

[Jean-Paul]

Hi,
The last item in the Sendobject command is "TemplateFile"
I don't understand that very well but does this has something to do with
the filename of the send report?
Because this is my problem.
All my send reports have the same name. This is very confusing for the
people getting and finally saving this file?
Is there a way to make the name of the send file more informative?

Thanks
JP

 

[tina]

you'd have to change the name of the report object, in order for it show a
different name in the email. that's do-able in code, i believe - but you
might find it much simpler to just set the Subject argument of the
SendObject action at runtime, so that the email's Subject line is "more
informative". suggest you read up on the SendObject Action topic in Help, so
you'll understand how all the arguments work.

hth

 

[Jean-Paul De Winter]

I have no problem to set the subject argument of the sendObject but that
does not change the filename of the send file itself...
It's THAT what I need
So, any help is welcome
Thanks

 

[tina]

well, i've never done it, so i can't tell you offhand. but i think i can
point you in the right direction: take a look at the Reports Collection
topic in VBA Help, and note that you have to get to *all* reports
differently from all *open* reports. i think you'll want to change the name
of the report object before opening it.

hth

 

[Jean-Paul]

I can not solve this annoying problem:
When I open the properties of the report and leave the Caption blank.
The file finally send gets the name of the report as it is saved in
"reports"
When I enter something like "Test" in "caption" the filename is "test.snp"
I also added:

Private Sub Report_Activate()
Me.Caption = "Algemeen overzicht week " &
[Forms]![bedrijven]![weeknummer]µ
End Sub

But, even with this code, I can not get the file name to be more
informative.

It would be great if you, or somebody else could help.
Thanks in advance

JP

 

[tina]

yes, i understand what goal you're trying to reach, and i've given what help
i can. if you weren't successful in figuring out how to change the name of a
report object, after researching the VBA Help file, then you might want to
start a new thread. suggest you include information on what you found in
Help, and where you got stuck, so whoever helps you can take it from there.
also, you might get better results if you post to newsgroup
microsoft.public.access.modulesdaovba instead of to this newsgroup. good
luck with it.

hth

I can not solve this annoying problem:
When I open the properties of the report and leave the Caption blank.
The file finally send gets the name of the report as it is saved in
"reports"
When I enter something like "Test" in "caption" the filename is "test.snp"
I also added:

Private Sub Report_Activate()
Me.Caption = "Algemeen overzicht week " &
[Forms]![bedrijven]![weeknummer]µ
End Sub

But, even with this code, I can not get the file name to be more
informative.

It would be great if you, or somebody else could help.
Thanks in advance

JP

well, i've never done it, so i can't tell you offhand. but i think i can
point you in the right direction: take a look at the Reports Collection
topic in VBA Help, and note that you have to get to *all* reports
differently from all *open* reports. i think you'll want to change the name
of the report object before opening it.

hth


show
a