I just figured it out but you led me down the right path pbaldy. Instead of;
Dim strTo as String
strTo = Me.TextboxName
olItem.To = strTo
I changed it slightly to;
Dim strTo As String
strTo = [Forms]![frm_Stockouts - Research]![Buyer Email]
olItem.To = strTo
Thank you for...
Mark, I am only getting one email with the placement of the .display.
pbaldy, I tried the code you listed but it is telling me that I'm using an invalid use of ME.
Hello,
I am new to Access World but would greatly appreciate some help with an issue I am having.
I am also by no means an expert with VBA coding but am definitely learning a lot.
I am trying to automate an email that has a table in the body based on a query. The query is filtered by the...