I just finished a access vba project that puts brings together allot of different recordset data and sends an email.
The way it achieves this is looping through the recordset and aggregating strings.
I only used a certain amount of spaces & vbtabs to more or less mimick tabular data based on the expected width of the data. This method has its flaws.
I have a couple issues, some fields have multiline data (i.e. addresses) and in few words the emails look messed up. In some cases these emails will be processed for faxing and I'm also pretty sure I will have lines that are soo wide they will extend to the next line.
Please provide some kind of sample line of code of how I'd achieve your suggestion since this is my first VBA program. For every little aspect you probably allready are familiar with I have to find out by trial (usually several) and have to plow through the internet for code samples until I get it right.
The way it achieves this is looping through the recordset and aggregating strings.
I only used a certain amount of spaces & vbtabs to more or less mimick tabular data based on the expected width of the data. This method has its flaws.
I have a couple issues, some fields have multiline data (i.e. addresses) and in few words the emails look messed up. In some cases these emails will be processed for faxing and I'm also pretty sure I will have lines that are soo wide they will extend to the next line.
Please provide some kind of sample line of code of how I'd achieve your suggestion since this is my first VBA program. For every little aspect you probably allready are familiar with I have to find out by trial (usually several) and have to plow through the internet for code samples until I get it right.
