The ability to create objects from other Office applications is one of the great things about using VBA. For example, you can write a macro that will create an Outlook message object and attach a shortcut to the currently open workbook. A button on the toolbar will perform this same action, which is fine if that’s all you want to do. But using the sample macro below, you can add other text to the message, pre-address it, or perform other actions. You can also tie the cre.... |