473,325 Members | 2,342 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Auto add of date to Subject field when sending email

I have a macro that autoruns once weekly and sends an email with an
attached xls file ( a data extract) to some internal customers.

The subject always reads [Mr X Update], for example...is there a way
to add a date into the subject field based on system date like

Subject: [Mr X Update] 06/17/2006
Thanks
Jerry
Jun 22 '06 #1
4 5180
[Mr X Update] & " " & Date()

Jun 22 '06 #2
Nope
Didn't work
All I get is the text as written below
Jerry
On 22 Jun 2006 12:24:34 -0700, "Jeff L" <jl*******@hotmail.com> wrote:
[Mr X Update] & " " & Date()


Jun 22 '06 #3
je*********@pioneer.com wrote:
Nope
Didn't work
All I get is the text as written below
Jerry
On 22 Jun 2006 12:24:34 -0700, "Jeff L" <jl*******@hotmail.com> wrote:
[Mr X Update] & " " & Date()


Do you have the whole thing surrounded by quotes? (shouldn't be)

Post your code.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jun 22 '06 #4
Made a macro

action is SendObject
in dialog box that specifies Subject I have

[pivot test] &" "&Date()

[pivot test] is NOT a database object or field, just the subject I
place in []

So I just tried this

="Pivot Test"&" "&Date()

Now it works perfectly
Thanks All

Jerry
On Thu, 22 Jun 2006 20:37:50 GMT, "Rick Brandt"
<ri*********@hotmail.com> wrote:
je*********@pioneer.com wrote:
Nope
Didn't work
All I get is the text as written below
Jerry
On 22 Jun 2006 12:24:34 -0700, "Jeff L" <jl*******@hotmail.com> wrote:
[Mr X Update] & " " & Date()


Do you have the whole thing surrounded by quotes? (shouldn't be)

Post your code.


Jun 22 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Corepaul | last post by:
I am new to Access 2000. My operating system is Windows 2000. In the early stage of development I noticed something weird. On my form, I have a Command Button named "btnAlbumUp". The first time...
3
by: Woody Splawn | last post by:
I have been experimenting with Auto Slides and TreeViews and find them most usefull in Winforms. I know how to create a Treview and have it, for example, slide out from the left of my Winform but...
6
by: | last post by:
Hi, can someone provide some advise on how to get around with using auto generated proxies? basically I already have the proxy classes, and they are used by other places. I'd like use these...
1
by: Grzegorz ¦lusarek | last post by:
Hi all. I sending email using standard python modules smtplib, email, coding email in utf but subject of message is not coded properly. In subject i use my national characters (polish) and after...
6
by: AA Arens | last post by:
Hi, I have a database with 2 main forms. Contacts and companies. I share the base with two others via LAN. On the companies form I have buttons to navigate throught the records (>400). We are...
17
by: Liam.M | last post by:
Hey guys, Forgive me if my question my be alittle silly, but I would very much appreciate and assistance that could be given! My situation is as follows: I have created a Button, and set...
1
by: kunal0101 | last post by:
Hi, I am a new user to access and am building a database to capture the rotation dates for employees. There is a table called "Rotation schedule" which contains "name", "Duration (in weeks) and...
3
by: TS | last post by:
I am using IE 7. I have a website running on my local machine (localhost) and auto complete doesnt work for any of the textboxes, but going to web sites on the internet does support this so i know...
6
by: Peter | last post by:
I have a APS.NET 3.5 webpage which calls a web service. What I need is to update this page automatically when a value changes in the webservice, does anyone have an example? Thank You ...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.