mikes6058
asked on
macro error??
Hi all
Attached is a macro enabled document containing a number of rows containing information. The macro had been designed so that when the "press to send terms to suppliers" button is clicked that particular row of information plus the column headings will be collated together onto a separate spreadsheet and will then be emailed as an attachment to the relevant email address located in column "T". However when I click the button nothing is sending.
Can anyone fix?
Copy-of-DIRECT-Central-Terms-encrypted.x
Attached is a macro enabled document containing a number of rows containing information. The macro had been designed so that when the "press to send terms to suppliers" button is clicked that particular row of information plus the column headings will be collated together onto a separate spreadsheet and will then be emailed as an attachment to the relevant email address located in column "T". However when I click the button nothing is sending.
Can anyone fix?
Copy-of-DIRECT-Central-Terms-encrypted.x
It sends email when I try it. Change .Send to .Display if you want to test it.
can you check the macro security on your Microsoft Outlook?
i suspect it is the macro security in your outlook.
i suspect it is the macro security in your outlook.
ASKER
I have enabled all macros on both excel and outlook trust centres but it still wont send the emails....
when I click the button on the sheet nothing seems to initiate. Before hand it was working fine. I can't think why the emails wont send?
Rob
when I click the button on the sheet nothing seems to initiate. Before hand it was working fine. I can't think why the emails wont send?
Rob
ASKER
I am looking to adjust the coding so it will do what's outlined in the question in the link below.
Perhaps you may prefer to focus on this question as it should address both issues.
https://www.experts-exchange.com/questions/28652759/change-to-macro-coding-to-send-multiple-lines.html
Perhaps you may prefer to focus on this question as it should address both issues.
https://www.experts-exchange.com/questions/28652759/change-to-macro-coding-to-send-multiple-lines.html
Did you try changing .Send to .Display and then run it?
ASKER
which bit of the code would I have to change to do this?
You could also put a breakpoint at the Set new_wb = Workbooks.Add line by clicking in the left-hand margin of that line and when and if the code gets there, press F8 repeatedly to step through the code line by line to see what's happening. You may find my article on debugging useful.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've changed the line as shown but still get the same result where nothing appears to happen and no emails are sent.
What happened when you tried my suggestion in post ID 40721152?