Email from Excel just won't send the attachment

[CorinneGermany]

-I have a workbook from which I create a PDF based on a range of cells. This all works fine. I do this separately from producing the Email so it can be checked before its Emailed.
-I then create an Email from the same workbook to send with the PDF attached. The body of the Email is created from a another range of cells from the workbook. Again, no problems with doing that.
-The problems came when I send. The Email sends fine and the body of the Email is fine but just NO attachment.

I have tried triple checked the file path of the attachment (even moving it to a simpler path to test) and change it to attacch a simple word document . I have also used two different Email providers 1&1 and Gmail but with the same problem. That attachment just does not want to leave me.

Update: Just noticed that I now have a message appear by the mouse pointer whenever I hover over a link of any kind. The message is : error while processing request - wrong response. I can only guess it has something to do with doing the test Emails but no idea what it means or how to get rid of it (except turn of the PC I am guessing as I have closed the excel workbook). Have I something still running?

Any suggestions?

Please Login or Register  to view this content.

[CorinneGermany]

SOLVED: The correct coding for attaching a document using Gmail is: AddAttachment, and NOT Attachments.Add