Hello All,
Using VBA with Outlook 2007, is it possible to open an Excel attachment from an unsent new or reply email message, pass the recipient's email address from the "To:" field to a cell in the workbook that was just opened and then close the email message?
After several months of trying to send cell data from an attached Excel 2007 workbook to the open but unsent Outlook 2007 new or reply message, I realized I may be looking at the task from the wrong direction.
Any help would be sincerely appreciates, thanks!
Using VBA with Outlook 2007, is it possible to open an Excel attachment from an unsent new or reply email message, pass the recipient's email address from the "To:" field to a cell in the workbook that was just opened and then close the email message?
After several months of trying to send cell data from an attached Excel 2007 workbook to the open but unsent Outlook 2007 new or reply message, I realized I may be looking at the task from the wrong direction.
Any help would be sincerely appreciates, thanks!