emailing text 'report' on recordset from Access

A

ali kwok

Hi

Does anyone have a smarter way to do this? I need to notify an email recipient that some records in the database have undergone a process
I've got a code in a vba project to convert a DAO recordset with headings to a fixed width text string with line breaks
The string is assigned to the TextBody property of a CDO.message object. What I can't control is that when the message
arrives by email, the body text is in a proportional font, which of course destroys the column formatting of the string
Ideally, I want to keep the message as body text rather than an attachment
The layout is more cosmetic than functional, but it would be a big improvement

Ideas

Thanks, Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

smarter way to include laid-out text in email body 0
Preventing use of proportional font in CDO.Message.TextBody 0
Sending Outlook email w/ alt sig block 0
Sending an attachment to Outlook Express from ACCESS 1
Send Email using CDO 2
No text in email from only one sender 4
Code to Email from Access 0
Trying to Send Email, Via Outlook, Using VBA 11

Top