Issues programatically adding an attachment to an email in thunderbird.

[CMOT Dibbler]

Hi,

I've seen a similar issue on here, but it doesnt quite fix my issue. https://www.excelforum.com/excel-pro...using-vba.html

I'm finding the current folder by using the workbook path, then using that folder to attach the file, but it's choping the string short.


This is a merging of code from multiple sources & a wip so please dont shoot me for it being a bit messy

If the folder doesnt have " - " in the folder name the code runs fine... but as soon as it hits that it trims the string.

so the example attachment name is X:\- Job Number\9999 - bens new company - home - Aluminium\Quotation\9999 Steel BOM.xlsm

The error is it cant find attachment X:\- Job Number\9999

I cant double speech mark the address as I dont have it written out in the code, I only have it saved as a variable.

Anyone got any suggestions?

Please Login or Register  to view this content.

[Artik]

I'm not sure because I never had Thunderbird, but try to replace the macro end in this way:

Please Login or Register  to view this content.

Artik

[CMOT Dibbler]

Perfect solution, thankyou.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.