Office Software Thread, Email query result from Access in Technical; Ah, yes I messed up it should be:
stSubject = "EMAIL SUBJECT on " & Day(Now()) & "/" & ...
7th January 2010, 01:22 AM #16
Ah, yes I messed up it should be:
if that gives an error try just Now rather than Now() in the brackets. The other method should go though and is probably a bit cleaner
stSubject = "EMAIL SUBJECT on " & Day(Now()) & "/" & Month(Now()) & "/" & Year(Now())
Thanks to SYNACK from:
RabbieBurns (7th January 2010)
IDG Tech News
7th January 2010, 01:26 AM #17
works a treat..
stSubject = "EMAIL SUBJECT on " & Format(Date, "dd/mm/yyyy")
By randle in forum Office Software
Last Post: 9th November 2009, 01:17 PM
By garethedmondson in forum Office Software
Last Post: 29th January 2009, 09:14 PM
By RabbieBurns in forum Scripts
Last Post: 24th June 2008, 11:09 AM
By Zebadee in forum Windows
Last Post: 15th April 2008, 02:28 PM
By Norphy in forum How do you do....it?
Last Post: 10th November 2006, 12:24 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)