When you send an email with the request for a read receipt, that is all it is, a request.
The email recipient and their email client application are in total control of whether to send a read receipt back to the sender.
It does not matter if you are using VBA, .NET, or any other programming...
I would create a function to send the email. Use parameters to pass all the requires info.
Here is the code
Access/VBA Tutorials - Outlook Send E-mail Without Security Warning (everythingaccess.com)
It is very easy to add the code to send the PDF as an email attachment after the PDF is saved. I use the exact same code to send emails. I just left out that part to allow you to use whatever method you want to use to send the emails.
I generally send directly via a SMTP server because it is...
You should never (the rare time never should be used) want to link Word mail merge to an Access database, epically if you have it opened. You are only asking for trouble.
From: Page Title (kallal.ca)
The Super Easy Mail Merge by Albert Kallal does exactly what you described as your needs...
Have you tried storing the rst!CustomerID in a TempVar?
TempVars are great for passing criteria to a query.
Do
TempVars.Add "CustomerID, rst!CustomerID
' open report here
rst.MoveNext
Loop Until rst.EOF
Else
MsgBox "None"...
Sounds like the textbox control is not wide enough to display all the data as a barcode. . Try making the control's width larger.
Can Grow will make the control taller, forcing the text to wrap to a second line. This will not work for the 3of9 (39) barcode because it must be on a single line.
Microsoft Office is all about letting the end-user use the data however they need it.
The great thing about building applications with Access is that it works so well with Excel. This allows users to pull the data to get exetly what they need.
Do you know if the users will actually try to...