<div>
try using the Nz() function when passing information<br />
<br />
nz([phone],&quot;&quot;)
</div>


try using the Nz() function when passing information

nz([phone],"")

<div>
<pre><code id="code-20-42026206-1">Invalid use of NULL</code></pre>
One way , although not tried from my side.<br />
If fields come from tables, try to make it pull from a query on those tables. Make the query fields as Nz(field).<br />
Select Nz(fld1) as fld1, Nz(fld2) As fld2, ....<br />
<br />
This way you preserve most of coding, including field names.
</div>


Invalid use of NULL

One way , although not tried from my side.
If fields come from tables, try to make it pull from a query on those tables. Make the query fields as Nz(field).
Select Nz(fld1) as fld1, Nz(fld2) As fld2, ....

This way you preserve most of coding, including field names.

<div>
<div class="content wysiwyg-content">
I have a macro set up to send out an email from Access. There are several variables within the email however not all of the variables will always have data populated. For example- a phone number with an extension. &nbsp;Not all phone numbers will have an extension as they may be a direct line. &nbsp;<br />
<br />
How can I bypass this error and have the e-mail simply leave that section blank if there is no data to populate?
</div>
</div>


I have a macro set up to send out an email from Access. There are several variables within the email however not all of the variables will always have data populated. For example- a phone number with an extension.  Not all phone numbers will have an extension as they may be a direct line.  

How can I bypass this error and have the e-mail simply leave that section blank if there is no data to populate?

Can I override the Runtime Error '94- Invalid use of NULL when sending emails from Access?

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.