+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
Office Software Thread, Email query result from Access in Technical; Ah, yes I messed up it should be: Code: stSubject = "EMAIL SUBJECT on " & Day(Now()) & "/" & ...
  1. #16

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,707
    Thank Post
    829
    Thanked 2,571 Times in 2,188 Posts
    Blog Entries
    9
    Rep Power
    731
    Ah, yes I messed up it should be:

    Code:
    stSubject = "EMAIL SUBJECT on " & Day(Now()) & "/" & Month(Now()) & "/" & Year(Now())
    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

  2. Thanks to SYNACK from:

    RabbieBurns (7th January 2010)

  3. #17

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    yea, the
    Code:
    stSubject = "EMAIL SUBJECT on " &  Format(Date, "dd/mm/yyyy")
    works a treat..

    many thanks

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [MS Office - 2007] MS Access query help
    By randle in forum Office Software
    Replies: 7
    Last Post: 9th November 2009, 01:17 PM
  2. Access - Date Query
    By garethedmondson in forum Office Software
    Replies: 12
    Last Post: 29th January 2009, 09:14 PM
  3. Vbscript to export query results from MS Access
    By RabbieBurns in forum Scripts
    Replies: 2
    Last Post: 24th June 2008, 11:09 AM
  4. EMBC and Email Query
    By Zebadee in forum Windows
    Replies: 5
    Last Post: 15th April 2008, 02:28 PM
  5. External student email access
    By Norphy in forum How do you do....it?
    Replies: 30
    Last Post: 10th November 2006, 12:24 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •