mymsg

Hi I am using this code(below) to send a current unsaved workbook to a mail recipient when a button is clicked. I want to be able to add a cc/bcc email address, how do I do it? There are plenty of solution that send the saved form from a drive but I don't want users to be able to save the...

Hi I have VB that updated cells with username when the user updates a row. However it seems that it is updatng each row with the user Example: user.one will upated a row and cell is updated with that username, user.two then updates the second row, but this time it will update first and second...

Hi I have a spreadsheet for recording issues, when complete we update cell in column "M", VB will then set each cell for the row to locked. this then prevents the row from being edited, the rest remain editable. however i am now finding that cells that start off with Locked un-ticked are now...

Hi all, I am using the below code with one issue... "J" will turn to sent when "I" has reached its value and the email does send but its sending all the previous emails as well. I only need it to send as each individual cell changes and not everything that's previously changed. Any help would be...

Hi thread, Try to set up VBA to help me automate my remittance advice sending.. I want to loop through the rows in the table. But I am so new to the VBA, I need some help. Here is the code for my VBA. Sub Mail() Dim OutlookApp As Object Dim Mess As Object, Recip Dim Body As...

Hi All, I have the below code which is failing and I can't for the life of me figure out why. Googling of the error messages produces vague solutions to the error, however I don't see how they're applicable to my code. The code is placed on 'Sheet1' and references a Macro placed in a Module...