R
Ruth Isaacs
Hello All
Is it possible to use code (which I would have as the on-click event of a
button) to email a particular spreadsheet that exists on a fileserver: the
path to the spreadsheet would be
Z:\other backups\other spreadsheets (Z is a mapped drive)
and the email address would be pcked up from the field 'email' on te current
form.
I'm sure this must be possible, but te SendObject macro command won't do it
and I don't know the vba syntax.
Hope someone can help.
Many thanks
Leslie Isaacs
Is it possible to use code (which I would have as the on-click event of a
button) to email a particular spreadsheet that exists on a fileserver: the
path to the spreadsheet would be
Z:\other backups\other spreadsheets (Z is a mapped drive)
and the email address would be pcked up from the field 'email' on te current
form.
I'm sure this must be possible, but te SendObject macro command won't do it
and I don't know the vba syntax.
Hope someone can help.
Many thanks
Leslie Isaacs