Hi,

I need to send an email with an attachemnt. I'm trying the following:

Dim strTo, strCC, strBCC, strSubject, strBody, strAttachment
strTo = "me@myaccount.com"
strCC = ""
strBCC = ""
strSubject = "test email"
strBody = "Hello World"
strAttachment = "C:\Temp\temp.txt"
Application.BasicFunctions.QueMessage strTo, strCC, strBCC, strSubject, strBody, strAttachment

It's opening the outlook client with the correct values except that it's not attaching the attachment. Am I missing something?

Thanks.

Presumably, c:\temp\temp.txt file exists (and isn't in use) ?

Humour me: Try this:

strAttachment = "C:\Temp\temp.txt;C:\Temp\temp.txt"

Does that work?

Looks like the function doesn´t like the name of the file. As soon I changed it to temp2.txt, it worked.