Peter T wrote:
> On 16/01/2022 07:26, Robert Baer wrote:
>
>>   I fixed that email assignment, and moved the procedure code to the
>> module section.
>>    Results:
>> 1) I cannot find that code is cannot make any changes to it
>
> I don't know what that's supposed to mean.
* What I said. Moved the procedure/function code to the module section,
so it is no longer in the sheet section.
The result is that I can no longer find or see that code.

>
>> 2) Running the code yields "Sub or Function not defined"
>
> I can only reiterate the code in your OP is fundamentally fine. It's
> impossible for us to know why it isn't working now so if you want to
> upload a new workbook with what you've changed ...
* Look now.

>
>>    I have access to Outlook 365 and presumably Excel 365 courtesy of
>> Office 365...
>>    Outlook has VBA code?
>
> AFAIK all 365 subscriptions include desktop Outlook and if so would
> include its VBA and exposed 'object model'.
>
* I looked and found I now only have Outlook 365 with NO mail merge type
function; therefore the only thing I can do is a one at a time mailing;
a gruesome one-at-a-time operation.

>>    What do I look for (and where)?
> In Excel's VBE, Tools / References, scroll down and tick 'Microsoft
> Outlook ##.0 Object Library'. All Outlook's VBA methods will then be
> available for you in Excel. But there's more to it and there's learning
> curve which you really need to research for yourself.
* Does not exist.

>
> FWIW your current code should work with whatever your default email app
> is, not necessarily Outlook.
* All I can say, is nope; I am dead in the water.

>
> Peter T

Thanks.