- operated by clicking "import query"
Macro is not automatically sending the email
1. The macro currently automatically unprotects the incoming sheet using the password "trinity". The incoming files may also be protected by two other possible passwords. These passwords are "trinity1" and "trinity2". Is it possible for the macro to attempt all three of these passwords when unlocking the sheet?
2. Is is possible for this email to be sent from email address "firstname.lastname@example.org"
If this account is not available the macro should default to any readily available outlook email address.
I have not been able to test the macro with the new filtering method as I am getting a coding error. When I click the "send update" button I am getting the compile error "variable not found". (see attachment for screenshot)
1. I would like to add two new columns to the right of column W (i.e.. X and Y). They will have the column heading names "supplier credit no." and "supplier comments". These additional columns also need to be sent when the email is sent. Presumably the formulas/coding assigned to the current X and Y columns will need to be adjusted accordingly as they will become Z and AA when the two new columns are added.
Any questions just let me know.