Re: List of Addresses into AB
Hello Joseph, Tuesday, April 20, 2004, 6:56:53 PM, you wrote: JN This question was answered some time ago, but I can find the answer JN neither in my own databases nor in the archives. JN How can one move a list of e-mail addresses into the AB? I have JN several last names in one column of 1-2-3 spreadsheet, first names in JN another column, and e-mail addresses in another column. I'd like to JN make them all individual entries in one contact group. Look up under the subject line Excel T'was me that started it -- Best regards, Neilmailto:[EMAIL PROTECTED] Current version is 2.10.01 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[2]: Modify received date? (or created date)
Saturday, March 20, 2004, 2:43:57 AM, you wrote: C Neil x @ 19-Mar-2004 2:25:37 PM X-Time: Mon, 11 Feb 2002 19:57:50 GMT Date: Mon, 11 Feb 2002 19:57:50 GMT C SNIP (by the way this is a received email and my system clock is correct - locked to an internet atomic clock using Tardis) C I assume that this message an old message... C This Tardis has nothing to do with a blue Police box, right? If not C (or if this message is a recent message), you have more problems than C you thinks. Watch out for The Master! Well no it isn't a Blue Police Box but I think the author might be a fan! http://www.kaska.demon.co.uk/ I see the Tardis quite often but that's another story (yes I do mean the real one! ) Sorry to disappoint you all but it's only a TV Prop. Now back on topic... It is the created date that I am wishing to change. Which is what I thought I had done above. Update - I have finally solved it. The created date was ALSO embedded in the HTML further down the message and it was that which TB seemed to be reading so whilst the headers were correct the HTML wasn't. -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[2]: Modify received date? (or created date)
Thursday, March 18, 2004, 9:08:27 PM, you wrote: JA On Thursday, March 18, 2004, Neil wrote... Sorry I don't understand what you are getting at? The Created date shows as 10 January 2010, 04:41:00 (Mon Feb 11 19:10:43 2002) JA The format is wrong, he is pointing it out. In the email that was JA sent, it is in the format: snip JA According to the RFCs, the date format on the mail you showed, is JA incorrect. If you want to get a little more technical, read the RFC JA 2822, section 3.3. This breaks down to what I pointed out above, JA showing that the format of the Date: header in the email you are JA having issues in is wrong. Ok thanks I understand now. Well I have tried exporting it to a Unix mailbox and correcting the date and importing it again but it still shows 2010. I believe the correct settings are:- -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[2]: Modify received date? (or created date)
Thursday, March 18, 2004, 9:08:27 PM, you wrote: JA On Thursday, March 18, 2004, Neil wrote... Sorry I don't understand what you are getting at? The Created date shows as 10 January 2010, 04:41:00 (Mon Feb 11 19:10:43 2002) JA The format is wrong, he is pointing it out. In the email that was JA sent, it is in the format: snip JA According to the RFCs, the date format on the mail you showed, is JA incorrect. If you want to get a little more technical, read the RFC JA 2822, section 3.3. This breaks down to what I pointed out above, JA showing that the format of the Date: header in the email you are JA having issues in is wrong. Oops that last went sent itself in the middle of me typing how weird... anyway the full email Ok thanks I understand now. Well I have tried exporting it to a Unix mailbox and correcting the date and importing it again but it still shows 2010. I believe the correct settings are:- X-Priority: 3 Importance: normal X-Time: Mon, 11 Feb 2002 19:57:50 GMT Date: Mon, 11 Feb 2002 19:57:50 GMT MIME-Version: 1.0 X-User-Agent: notify ($Revision: 1.41 $) X-Domain: gb Content-Transfer-Encoding: 7bit X-Accept-Language: en-us, en Which if I import as a Unix mailbox still shows as 2010 but if I double click on the file (01.msg) it opens in TB AND with the correct date. I'm totally confused now! (by the way this is a received email and my system clock is correct - locked to an internet atomic clock using Tardis) -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[2]: Modify received date? (or created date)
That's the odd thing. It isn't in the headers. I exported the email to a Unix mailbox file and opened it in Notepad. Headers below. Yet in my Inbox in the Created column (and on the Created line in the email) I get Created: 10 January 2010, 04:41:00 (Mon Feb 11 19:10:43 2002) And the sort by created date works on the 2010 date! Now I can see the 19:10:43 timestamp in the headers but not the 2010 one. Where has that one come from? (Note this was a received email rather than one sent by me) Neil Return-Path: [EMAIL PROTECTED] Received: from mk-rewrite-1.mail.uk.tiscali.co (212.74.114.131) by mk-cpfrontend.uk.tiscali.com (6.7.014) id 3E2FE531004EC062 for [EMAIL PROTECTED]; Tue, 11 Feb 2003 19:10:48 + Received: from [193.113.160.12] (helo=tigger-650.london.ongenie.net) by mk-rewrite-1.mail.uk.tiscali.co with esmtp (Exim 3.33 #1) id 18ifbd-000A6l-00 for [EMAIL PROTECTED] ; Tue, 11 Feb 2003 18:58:10 + Received: from o2.co.uk (193.113.160.27) by tigger-650.london.ongenie.net (6.5.029) id 3E352F440004294D; Tue, 11 Feb 2003 19:08:12 + Message-ID: [EMAIL PROTECTED] (added by [EMAIL PROTECTED]) X-Priority: 3 Importance: normal X-Time: Mon Feb 11 19:10:43 2002 Date: Mon Feb 11 19:10:43 2002 MIME-Version: 1.0 X-User-Agent: notify ($Revision: 1.41 $) X-Domain: gb Content-Transfer-Encoding: 7bit X-Accept-Language: en-us, en To: [EMAIL PROTECTED] Content-type: text/html From: O2 [EMAIL PROTECTED] Subject: Welcome to O2 Thursday, March 18, 2004, 10:23:42 AM, you wrote: RA Yes, it is in the Unix mailbox format. This is the start of your email RA exported to Unix mailbox format. The From line at the top shows the time I RA received it, the Date: header shows the time you created it RA ,- [ ] RA | From [email address deleted] Thu Mar 18 21:03:02 2004 RA | Return-Path: [EMAIL PROTECTED] RA | Delivered-To: [email address deleted] RA | Received: from mail-in.netspace.net.au RA (mail-in3.netspace.net.au [203.10.110.75]) RA | by mx4.netspace.net.au (Postfix) with ESMTP id 9C4083A546 RA | for [email address deleted]; Thu, 18 Mar 2004 18:41:13 +1100 (EST) RA | Received: from mail-in.netspace.net.au (localhost [127.0.0.1]) RA | by localhost.netspace.net.au (Postfix) with ESMTP id 02B6259FD1B RA | for [email address deleted]; Thu, 18 Mar 2004 18:41:26 +1100 (EST) RA | Received: from server01.clinservices.de RA (server01.clinservices.de [62.80.28.25]) RA | by mail-in.netspace.net.au (Postfix) with ESMTP id 7676D59FB97 RA | for [email address deleted]; Thu, 18 Mar 2004 18:41:25 +1100 (EST) RA | Received: from draenor.its-toasted.org RA (draenor.its-toasted.org [62.80.28.8]) RA | by server01.clinservices.de (Postfix) with ESMTP RA | id 7CCA0274293; Thu, 18 Mar 2004 08:40:41 +0100 (CET) RA | Received: from 81-86-253-222.dsl.pipex.com ([81.86.253.222] RA | helo=brackenbury.org) RA | by draenor.its-toasted.org with esmtp (Exim 4.30) id 1B3s7f-00059i-1b RA | for [email address deleted]; Thu, 18 Mar 2004 08:39:23 +0100 RA | Received: from cr [127.0.0.1] by brackenbury.org RA | (ArGoSoft Mail Server Pro for WinNT/2000/XP, Version 1.8 (1.8.4.7)); RA | Thu, 18 Mar 2004 07:39:21 + RA | Date: Thu, 18 Mar 2004 07:39:19 + RA | From: Neil [email address deleted] RA | RA ...snip... RA | RA `- -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[2]: Modify received date? (or created date)
Thursday, March 18, 2004, 5:38:36 PM, you wrote: PO Hello Neil, PO on Thu, 18 Mar 2004 16:23:07 + (2004-03-18 17:23:07 in .nl) in the PO message with reference PO mid:[EMAIL PROTECTED] you [] wrote (at PO least in part): N Yet in my Inbox in the Created column (and on the Created line in the N email) I get Created: 10 January 2010, 04:41:00 (Mon Feb 11 19:10:43 N 2002) PO snip N Received: from mk-rewrite-1.mail.uk.tiscali.co (212.74.114.131) N by mk-cpfrontend.uk.tiscali.com (6.7.014) N id 3E2FE531004EC062 for [EMAIL PROTECTED]; Tue, 11 Feb 2003 19:10:48 + PO snip N Date: Mon Feb 11 19:10:43 2002 PO If I'm not mistaking, the Date: field should be in the format like: PO Tue, 11 Feb 2003 19:10:48 + Sorry I don't understand what you are getting at? The Created date shows as 10 January 2010, 04:41:00 (Mon Feb 11 19:10:43 2002) Which is the format you said. -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[2]: Modify received date? (or created date)
Wednesday, March 17, 2004, 10:43:56 PM, you wrote: RA On Thu 18 March 2004, 5:36:34 +1000, [EMAIL PROTECTED] wrote: Can I manually modify the date shown in the Received column of TB messages in the main message list view? RA Yes, but not within TB!. You need to export the message(s) in Unix Mailbox RA format, then you can edit the Unix Mailbox file and import the messages. RA The received date is on the first line of each message in the mailbox Is it also possible to modify the 'Created Date' as I sort by created date and have one which the sender sent as 2010! Have tried exporting to Unix format but can't find the number 2010 in it using a text search. Any ideas how to edit that? -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Blind Copy Header
Hello folks I received an email from a friend yesterday who uses a different client to us but was impressed by the header that the client had put into MY copy of the email. Because I was BCCed (Blind Copy) into the email his email client had inserted the following. IMPORTANT! This message has been blind-carbon-copied to you. Do not reply-to-all or forward it without the author's permission. Is it possible to get TB to do this as well on a Blind Copy (It really makes you sit up and take notice that you have been blind copied in! -- Neil Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Autoresponder
Hello Michael, Saturday, March 6, 2004, 3:43:03 PM, you wrote: MD Hi Folks! MD How do I set up an autoresponder to automatically reply to incoming MD messages? Set up an incoming mail filter for the emails you wish to autorespond to and then on the 'Actions' tab tick the 'Set Auto-Reply' box and then up pops a window to compose your message. Neil TB v2.04.4 Current version is 2.04.7 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[3]: Mass mail using data from Excel
Thanks for the replies. Think I might have confused the issue by saying database. What I actually meant was that I have a spreadsheet of info - held in Excel. (I don't have any experience of Access - last database I used was RBase! circa 1990) Now the bit I was using was as Greg described:- 3 import CSV into TB AB group Note: The import was no hassle when you include field names in the first row that are the same as the field names in TB's import function. IOW just hit OK. 4 Run QT in TB from AB group to create email in Outbox (2) email with all info in text email and NO attachment Note: In #2 I used the AB as a database to hold info for the fields used in my QT. (I note the useful tip about including field names in the CSV) Basically creating a template in TB and substituting variable names for the person specific email (therefore not a Bcc) so for example the spreadsheet would read:- Name, email, quantity, item, balance John Smith, [EMAIL PROTECTED], 5, widgets, £4.50 Paul Smith, [EMAIL PROTECTED], 3, plugs, £2.30 Then create a template so that the emails would read:- Email to %email% Dear %Name%, Your order for %quantity% %Item% has been despatched and the balance of your order is %balance% Note: I am using %xxx% to represent the value from the spreadsheet. So apart from import CSV into TB AB group then Run QT in TB from AB group to create email in Outbox there is no other way?? Neil Wednesday, February 18, 2004, 11:25:43 PM, you wrote: T Hi Greg, T ...snipped This may be over my head, but how did you send an email without importing anything into TB? Would you be able to provide more information here either on or off list? T Use DoCmd.SendObject. Google will get you lots of info on it. I'll be T happy to send you my code off list if you'd like it, although I don't T know how much sense it will make. :) It's a routine I did for sending T a daily e-mail to different people, all of whom wanted different T reports in different formats as attachments. T snipped procedure steps T I skipped all your steps. The code did everything. I used the code T with TB! 1.63r. It was never tested with TB! 2+, although I have no T reason to think it wouldn't work. The code was assigned to a button T on the startup form. The database operator pressed the form and that T was it. T Feel free to contact me off list if you need more info. -- Best regards, Neilmailto:[EMAIL PROTECTED] Current version is 2.02.3 CE | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
Mass mail using data from Excel
Hi folks New to this list so be gentle please... I maintain a database of names, email addresses and order type and quantity. Now what I want to do is email everyone in the database at certain times confirming what their order is, quantity and balance due. All the data is held in an Excel spreadsheet. Now, is there any way to extract the data and insert into a mass mail out other than importing the data from a CSV into the address book as a group? a) CSV import seems unreliable. Last time I tried it it missed the first and last record b) It's a pain to do that task every time I want to do a mass email c) The fixed format (tab delimited) also gave me problems with addresses with commas in e.g. 56, The High Street, Anytown, Anywhere Any ideas/macro example welcome! -- TIA Neil Current version is 2.02.3 CE | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
