Mail Merge Date Switch

Im Totally Confused Why When I Do a Mail Merge to a word document,

The Date Field I Have Isnt Quite Working Properly.

As The Mail Merge Sets The Date Formate as USA

I Have To Apple a Switch To the Merge Field

The One I'm Using Is MERGE FIELD Requested Date \@ "dd mm yyyy"

Which Seems to Be Working fine on mailmerge document.

But Im My Other One, The Data Reads 17/00/2007 Where as The Date
Should Read 17/08/2007 It Was Working fine Before the Date was set to
August!

I'vei taken the switch off the date will actually Read 08/17/2007

Any One Had Any Issues With This and Solutions?

0
dan
8/2/2007 4:35:13 PM
access.formscoding 7493 articles. 0 followers. Follow

2 Replies
1851 Views

Similar Articles

[PageSpeed] 7

On Thu, 02 Aug 2007 09:35:13 -0700, "dan.cawthorne@gmail.com"
<dan.cawthorne@gmail.com> wrote:

>But Im My Other One, The Data Reads 17/00/2007 Where as The Date
>Should Read 17/08/2007 It Was Working fine Before the Date was set to
>August!
>
>I'vei taken the switch off the date will actually Read 08/17/2007
>
>Any One Had Any Issues With This and Solutions?

Dan, if you don't mind my asking... Why The Strange Capitalization? It's
really disconcerting to read your posts!

If you're mail-merging you need to be aware that dates are not stored in
Access with any particular format. They're actually stored as a double float
number, a count of days and fractions of a day (times) since midnight,
December 30, 1899. Word will pick up the date from the table in the mail merge
and display it using your computer's Regional settings.

If you want to force a particular format, you can put a calculated field in
the Query you're using for the mail merge:

ExpDate: Format([datefield], "dd/mm/yyyy")

will contain a text string, the date formatted in day-month-year format.

             John W. Vinson [MVP]
0
John
8/2/2007 9:00:17 PM
On 2 Aug, 22:00, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Thu, 02 Aug 2007 09:35:13 -0700, "dan.cawtho...@gmail.com"
>
> <dan.cawtho...@gmail.com> wrote:
> >But Im My Other One, The Data Reads 17/00/2007 Where as The Date
> >Should Read 17/08/2007 It Was Working fine Before the Date was set to
> >August!
>
> >I'vei taken the switch off the date will actually Read 08/17/2007
>
> >Any One Had Any Issues With This and Solutions?
>
> Dan, if you don't mind my asking... Why The Strange Capitalization? It's
> really disconcerting to read your posts!
>
> If you're mail-merging you need to be aware that dates are not stored in
> Access with any particular format. They're actually stored as a double float
> number, a count of days and fractions of a day (times) since midnight,
> December 30, 1899. Word will pick up the date from the table in the mail merge
> and display it using your computer's Regional settings.
>
> If you want to force a particular format, you can put a calculated field in
> the Query you're using for the mail merge:
>
> ExpDate: Format([datefield], "dd/mm/yyyy")
>
> will contain a text string, the date formatted in day-month-year format.
>
>              John W. Vinson [MVP]

Thank you John,

i will give that i try and let you know if i manage to get it to
work,

sorry about the caps its annoying habit, i don't relise i do it.

0
dan
8/2/2007 10:38:38 PM
Reply:

Similar Artilces:

send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with one or two fields changed (for example the name of recipient and the date).How canthis be done?? I would also like to be able to save the e-mail and use it again and again. can anyone help cheers john If you have Word installed and it's the same version as Outlook (both 2003, for example), you can do a mail merge between the two. This would allow you to set up the text the way you want it to, and you can save the document for future use. Look at the following page for further information: http://www.slipstick.com/con...

Date display in Excel
Format column of cells as Date, display as mm/dd/yy. Date entered into cell, shows up correctly in the text entry field at the top of the screen, but the data on the worksheet displays as "33747", or similar number. Only happening on one workbook. Try tools|options|View tab|uncheck Formulas. Clark wrote: > > Format column of cells as Date, display as mm/dd/yy. Date > entered into cell, shows up correctly in the text entry > field at the top of the screen, but the data on the > worksheet displays as "33747", or similar number. Only > happening on one...

Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail. If I close Excel and retry it will open Excel and the spreadsheet. Any ideas? I hate having to close all my open spreadsheets when I want to open a spreadsheet that's been e-mailed to me! One of these usually works with a similar problem starting workbooks by double clicking them in Windows Explorer. Maybe one will work for you and your email problem. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close E...

Mysterious e-mails
i keep getting e-mails that look and appear that they have come from people either in my phone book or in some cases from people that have ligitimately e-mailed me or that I have e-mailed. In fact the e-mail has come from somewhere else even though the sender appears to be ligitimate. Most of these e-mails are dated 3 or four weeks old and show that they have been read in my inbox. I've asked a few people if they have forwarded the mail to me but they havn't. Most e-mails are selling Viagra or some other product. ??? any clue ??? Thanks in advance You're being spammed. First...

Mail will not Send/Receive automatically
I have outlook set up to send/receive every minute but it suddenly stopped doing so. Anyone have ideas why? Robin Several. For starters, a one minute polling interval is just nuts. It is difficult to determine why automatic polling is failing when you do not post your mail account type, connection type and polling settings. If automatic polling once worked and now fails, you also need to examine what changes were made to your setup before automatic polling stopped working. In general, here are the reasons automatic polling might fail in Outlook: 1. You have created an unrealistic po...

C# Adding Days to a Date
Hello, I have 2 objects: objContract.activeon and objContract.expireson. I am trying to add 364 days to objContract.activeon and assign it to the value of objContractexpireson. ---------------------------------------------------------- // Contract Start Date DateTime dt = DateTime.Now; objContract.activeon = new CrmDateTime(); int iFound = 0; string sTemp = ""; if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays Date { objContract.activeon = objInvoice.CFDinvoicedate; } else // ...

Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to separate the text into 2 cells - one with the date and the other with the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks for your help Sameer --- Message posted from http://www.ExcelForum.com/ For the date use =INT(A1) replace A1 with the first cell of your range for time =MOD(A1,1) you probably have to reformat the first to mm/dd/yy (or whatever the setting is) and hh:mm Note that you can do this by just using format but if you want to compare to other cells with just pure d...

Outlook Mail via a PROXY SERVER?
If I am using a shared Internet service on a second computer using a PROXY server on the host (first) computer. I can access the net using the PROXY settings on the Internet explorer. However, how do I download mail with OUTLOOK 2000? The proxy server is CCPROXY from YoungZSoft (this runs on XP) and it has the MAIL Settings enabled but the difficulty is what to do on the Second computer? Thanks, -- John jrg_REM_SPAM@bigpond.net.au That would be determined by the proxy manufacturer - check with their support. JM7 wrote: > If I am using a shared Internet service on a second computer ...

Mail enabled public folders / spam
Hello, For each of my users inbox I have exchange mark mail with the SCL and move anything over my threshold into their junk mail folder. This works pretty well and eliminates nearly all of the spam we get. I have not thus far managed to work out how to get this working for mail enabled public folders. How can I set this up (perhaps nominating anotehr folder as the 'junk mail' folder) or something similar? TIA, Nick ...

Using Company Wide Mail Templates.
Hi, I do not know if i am at the right spot here, or if it is evne possible, but i got the following question. My boss would like me to make sure that every outgoing mail has the same looks. It starts by adding a signature that is the same for everyone, except with ofcourse personalized information. This was easily done by giving everyone a signature. The next question is however, to put the head of our website, also above our mail. This means that every user that sends a mail, the mail will have a nice header, underneath that header, the mail is typed, and then its ended with the si...

How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the current form field. This bit of code is attached to the GotFocus event of all fields and the Enter event of all subforms: gxCurrentField = Me.ActiveControl.Name However it doesn't work properly when changing records in a subform. My parent form contains two subforms in a many-to-many relationship. The above variable usually ends up containing the name of the first field in the second subform when switching records in the first subform. How to correctly code this? Or is there some native variable I'm not aware of? I...

WLM Beta Junk Mail Filter
The junk mail filters has stopped filtering mail. The address shows in the list of blocked addresses but the mail is not filtered. The filter worked fine in WLM but I don't think it has worked since I loaded the Beta. Where exactly are you looking when you say the address is the same as the one in your Blocked Senders? The From line may not show the true entry, look at the entry in the From field you see after pressing Ctrl+F3 on that message. Gary VanderMolen, Microsoft MVP (Mail) "DickW2" wrote in message news:O7$LTHNMLHA.4084@TK2MSFTNGP05.phx.gbl... T...

date function #3
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C73005.0FA093A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get = 5. Is there a way to return May instead? either through a command or = formatting? I can reference cell A2 with the 5 with a if(cell =3D 5, = "May", ) in cell A3, but the date in cell A1 varies from Jan to Dec and = the 12 embedded if's in cell A3 are too long (that is the error I get = when trying to do so), plus i...

Mail Merge to business cards
I am working on a huge project for work, creating Employee Photo ID cards. I have created a database for all the information including a hyperlink column for the photos. and am using business cards to print them on. I have two frustrating problems... 1. The pictures aren't loading into the cards. 2. I continue to get the error message "Publisher cannont merge with this number of pages" even though I have followed the instructions for the workaround. Any suggestions? Thanks Rita ...

Mail merge from excel
I am trying to merge a list of names from excel into publisher. When using the mail merge wizard it wont let me load the names all it says is f1 and f2. what am I doing wrong? any help is greatly appreciated. ...

Auto Delete the e-mail
Hi all We are using Microsoft Exchange 2003 and Outlook 2003. One mail box calls "Sales", i configured the achieve function for this mail box, this function will automatically delete mail if the mail is order than 7 days. But this function is not running if the outlook closed, is it possible this function running on server only, no need to open Microsoft Outlook for running the achieve function in client PC ? Philip In news:uApBq0j8FHA.2800@TK2MSFTNGP10.phx.gbl, Philip Tsang <philip@sib-infotech.com> typed: > Hi all > > We are using Microsoft Exchange 2003...

how to know how many e-mail each user receives per day?
We are running Exchange 2003 on Windows 2003. I would like to know how to get an average of how many e-mails each users send and receives per day. ...

how do I change date format in the header in Excel XP ?
I need to chage my date format, in the header to Day; Month DD, YYYY ie. Saturday; May 23, 2005. Woudl you please help me out ? Thank you. Regards, Hesam Shakourian Check this out. http://support.microsoft.com/?kbid=213742 but change the format to "dddd, MMMM dd, yyyy" "Hesam" <Hesam@discussions.microsoft.com> wrote in message news:93495F75-4196-4208-9C0D-E800BCAE3A89@microsoft.com... > I need to chage my date format, in the header to Day; Month DD, YYYY > ie. Saturday; May 23, 2005. > > Woudl you please help me out ? > > Thank you. > &g...

Mail Merge Not Responding
I am having trouble print merging a large file in publisher. Every time I start the merge it hangs and I get a "publisher not responding" error. I was able to do the merge in Pub 2003 before I installed SP3. I had the same problem with SP2 but I was able to reinstall publisher and it worked fine. Since I installed SP3 its not working at all and I can't remove SP3. BTW I have the same issue in Pub 2007. Thanks Is this the complete error? You receive a Publisher cannot continue error message when you try to print a mail merge in Publisher 2003 http://support.microsoft....

cannot send e-mail #3
I am getting the following message: message from Outlook 2000, you may receive the following error message: 0X800CCC78 error: The message could not be sent because the server rejected the sender's e-mail address It gradually has disabled all of my 3 accounts on Outlook. I can send, but not receive. I think there is some software corruption or a virus. Deleting and re-creating the account does not work Mario D'Avirro <mariod@mdainsurance.com> wrote: > I am getting the following message: > > message from Outlook 2000, you may receive the following > error mes...

"Merging" Documents
I have two documents with identical tables on them. On the first is filled with info on every cell except one. The second every thing is blank except the same cell from the first. WIthout having to resort to cut and paste, is there a way to combine the two where the info from the second document automatically fills in the blank cell from the first? You could theoretically bookmark the desired text in the second document and use an IncludeText field in the first. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "...

Option trades with past expiry dates not showing up in Portfolio M
Hello: Money 2006 Portfolio Manager does not show closed option trades that have expiry dates in the past, even when the "show closed positions" is checked. The transactions are still there in the investment accounts, just not visible in portfolio manager. I just called microsoft support and have notified them of the issue and hope that this issue is fixed as an update. If not, it pretty much makes the portfolio manager (and Microsoft Money 2006) useless for option trading investors. "MumbaiBabu" <MumbaiBabu@discussions.microsoft.com> wrote in message news:1...

How do you sort a date range by month?
We are trying to find out how many birthdays fall with in a given month using excel. You could use a helper column, with something like = A2. Format this (Format - Cells - Number - Custom: mmm. Now you can use Data - Subtotals, "At each change in: Month" and "Use function: Count." -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "Brewisc13" <Brewisc13@discussions.microsoft.com> wrote in message news:44E02AAC-8216-43F5-846F-E981E978E44B@microsoft.com... > We are trying to find out how many birthdays fall with in...

Send To: Mail Recipient.
Hi, I have a couple of Terminal servers running Windows 2003 & Citrix Metaframe XP. When logged in as the admin, Send To: Mail Recipient works perfectly. When logged in as a user, it pops up the profile selection dialog & then nothing. Has anyone seen anything similar? It's outlook 2000 by the way. Stu ...

vb date and ssn textbox formats
Ok, so maybe I am crazy...but I have checked "Visual Basic 6 how t program", and "Visual basic 5 teach yourself in 24 hrs" for and exampl or how to format a text box on a user form to accept and display date and Social Security Numbers in the specified format. Thanks Al -- Message posted from http://www.ExcelForum.com Date TextBox1.Text = Format(Date,"dd mmm yyyy") SSNs TextBox1.Text = Format(mySSN, "000-00-0000") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mai...