Search results

PeterF: Thanks. That's just what I needed! Leathem

My Access project includes producing a comma-delimited (CSV) file for later presentation to an email program (LISTSERV Maestro). I'd like to be able to incorporate unicode control characters (e.g., CR/LF, etc) into the file to format the email. How do I do this? Here's the line that produces a...

First, my apologies for the accdb file - I was in a rush and misread your last reply. I'm attaching the relationships as a pdf along with two Excel files: "enrollments" is the raw data from the registration process and "studentEnrollment" is a processed table that I was using to produce the emails.

Ok, here's the one of the source tables and the query that needs to be modified. As you can see when you run it it produces as many rows for each student (Test0, Test1, etc) as there are courses that student has selected. As I say, I need only one row for each student followed by a series of...

Actually originally I had designed the system with a VBA procedure to send the emails, a system which works ok with Outlook, but the institution I'm working with now won't use Outlook and prefers something called Maestro for bulk emailing, and Maestro wants a csv file much like mail merge in...

I have a query that produces a table of courses for which a student is registered, but in order to export it for email merge as a csv file it needs to be in a different order. Now each course for which a student is registered gets a different row, using the following SQL: SELECT...

It's a report. Perhaps it would help if I include the full code: Private Sub Command20_Click() ' Error handler On Error GoTo 0 ' Create a SELECT command Dim StudentQuery StudentQuery = "SELECT [StudentDataQuery].StudentName, [StudentDataQuery].[E-MAIL] FROM [StudentDataQuery]"...

I'm working on it... But I think I see a complication. If I correctly understand your original code you create an email (with an optional attachment) and then send that email to all recipients in a list. My situation is a bit different. The attachment letter for each recipient is different, so...

Hi Joe, First, thanks for the quick reply and the code. I've already incorporated the tracking code - a great idea I hadn't thought of but will find very useful. Forgive a novice VBL user, but I'm trying to reconcile your code with mine. As I understand it you create an Outlook object...

I am using Access to send emails, but the computer I am using has more than one email client (specifically Firefox and Microsoft Outlook). Normally Firefox is my default client, but I would like to have Access use Outlook because the third-party application ClickYes works only with it. My...

Aargh! I found it shortly after posting this thread. In Thunderbird under /tools/account settings/account actions there is an option for choosing the default account. Sorry for pestering the forums, but maybe this will help someone else! Leathem

I am sending emails (with pdf attachments) from my Access 2010 database using Mozilla Thunderbird. However I have several accounts in Thunderbird. Is there a way to have Access choose the account to use for sending? I've searched Thunderbird to see if there is a way to choose the default account...

Oops. My mistake. I got rid of the spurious F12 by just deleting the rightmost column in the Excel spreadsheet (even though to the naked eye it was blank). Sorry.

I've been away for a while, but have returned, and I tried the update query that bijuvijayaraj suggested, but got an error message that the field could not be updated. I guess this is not unexpected, since it's an autonumber field. I suppose that as long as Access doesn't run out of numbers I'll...

Thanks for the info. I think this will do the trick!

I apologize for not being clearer. The key is indeed used, as a foreign key in other tables, so I'd like to keep it. I don't, however, care if the numbering is the same as it is in the spreadsheet. bijuvijayaraj's idea of using an update query to reset the numbers sounds appealing, but I'm not...

I need to update a table that exists in Access with new data. The easiest way for me to do it is to run a deletion query that removes all the data from the existing table and then to repopulate the table from an Excel table. This works fine except for one thing: the table in Access has a...

Thanks, Bob. It worked fine!

I am trying to use an update query to update several fields in a table. The following code works fine for one field: UPDATE [Trip Registration] SET [Trip Registration].[Trip1 Confirm] = "C" WHERE (([Trip Registration].[Trip1 Coord])=True); but the problem is that I'd also like the same...

Bob and Uncle Gizmo, Many thanks to both of you for the quick response and accurate diagnosis. Following your advice I inserted "ORDER BY StudentName" in the string, and now it works fine. And Bob, thanks for the FYI on the file structure in tables. I wasn't aware of the lack of order in...