Search results for query: *

I have a column of data in Column A and I want to delete the entire row and move the rows up if the text in the cell contains a certain string. How do I get VBA to prompt me for the text and then when entered will proceed to delete the relevant rows?

A third party application produces batches of emails for me and puts them in the Drafts folder for me to send. Thanks to the ingenuity of fellow Tek-Tips users, I have developed macros which, when I have selected one or more messages, can add specific cc/bcc addresses to them and or send them as...

I have a column of names which sometimes contain just first and surnames, and sometimes one or more middle names, each separated by a space. I want to split this into just two columns, one containing First and Middle (if present) Names, and the other the surname. For example Jean Luc Picard ->...

I generate multiple emails from various applications, typically invoices, statements, payslips etc. It pops them into a drafts folder within Outlook365, and I have a VBA macro which sends all the drafts I have selected. However, since moving to the 365 platform, I find that many emails do not...

Is it possible to have a single button on an Excel worksheet for sorting a range alternatively by two different columns, say Reference and Name? Ideally, I would like the button to read "Sort by Reference", then when clicked, a macro would sort the data by reference number, and then change the...

Is it possible to have a an Outlook VBA macro which will export the header information from emails the user has selected? Any code / advice would be much appreciated. Thanks