Email via Outlook

[BC]

Hello all,
I am trying to send email from access via Outlook.
The routine works great. I would like add attachments. If
I hard code in the attachment path, the attachment works
fine. I would like to interactively add an attachment. I
have added code to do this using the FileDialogue
commands. When I apply the result to the .Add in my code
I get the 'Object doesn'r support this property or
method'.

my code is below:

Set objOutlookAttach = .Attachments.Add("C:\Survey.pdf") -
works fine here
Set objOutlookAttach = .Attachments.Add(ack) - errors here

'Ack' is the string returned from the FileDialogue
routine and that is where the error occurs.

Any help would be appreciated.

BC

 

[Chadlon]

Hi there,

Did you take a look at the returned value ack?
Was it sensible/useful/completely as expected?

How is ack defined? Sounds a bit like a success/fail acknowledgement
variable.
Should you not be looking for / using a path-type variable?
What does the File Dialogue sequence look like?

CD