Computer Support Forum

Outlook 2007 Date: None

Question: Outlook 2007 Date: None

When I reply to a mail I get the mail stuck in the Outbox with Date: None.
The only way to get arround this is the reply to all and then it gets a date, but if I had another mail with a date waiting in the Outbox, that one gets a Date:None

Can someone help ?
I am under Windows seven

Relevance 100%
Preferred Solution: Outlook 2007 Date: None

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Outlook 2007 Date: None

Set up Outlook so that outgoing mail is sent immediately instead of being sent to the Outbox.

Open Outlook.
Click "Tools >> Options".
Click "Mail Setup" tab
Put a tick in the check-box "Send immediately when connected"

2 more replies
Relevance 65.19%

Hello. If I select Date from the "Arranged By" field in Outlook 2007, it sorts by the date each message was received. I know that I can sort by the sent date by clicking on "Custom", then under Sort selecting Sent. This is a pain to go through all of this, however, since Outlook reverts back to the received date every time I sort by something else or search for an email, etc. I'd like to know if there is a way I can change Outlook so the default date sort is the sent date instead of the received date. I'm fine with editing the registry and what-not if need be.

Thanks in advance,

Answer:Outlook 2007 default sort to sent date

10 more replies
Relevance 65.19%

Hi All,

First post.

i need to see the reply date time stamp for each email in a inbox is it possible to add it has a cutom column or maybe vba etc.

really could do with some help on this asap.



Answer:Reply Date/Time Outlook 2007.

yeah its possible you need to change the email settings and then you can able to get the time and date as well. Outlook PST Repair

3 more replies
Relevance 65.19%

Suddenly, in Sent Items, the date sent for all of my Outlook 2007 messages appears as None. If I create a sub folder and move the messages to it, the date sent appears. In addition, when in the original "Sent" folder, when right clicking, I am no longer given the option of deleting messages in the Sent Items folder. I have seen references to the first problem on the Internet, but so far no one has explained how to solve it. Any and all help will be appreciated.

Answer:Solved: Date sent appears as NONE in Outlook 2007

Just found it! View - Current View - Customize - Fields.

1 more replies
Relevance 62.73%

we use outlook to view messages in the military. these messages are most likely refrenced by their date time group. in the message ( body of the email ) it will state the DTG.. example DTG: 291323Z Apr 10

i would like to make a field in my view so i can have the messages displaed by DTG. is this possible? if so how?


More replies
Relevance 58.22%

Hello - strange problem one of our users is having - when she picks up a draft email (she has previously prepared) then sends it, the email is recieved with the draft date, instead of the sending date. This means that the recipient cant see the new message (they will find it in listed as being recieved on the "draft" date). I have been unable to duplicate this error! Has anyone heard of this happening?
(Outlook 2007/Exchange 2007)
Any help very welcome!

Jon Morris
C&IT Services
Edinburgh Napier University

More replies
Relevance 58.22%

I have Windows XP and am using Office 2007. A week ago my Outlook calendar started showing the wrong date. Today is showing as 11/13/09 and it's 11/19/09. My inbox is grouping my email in "Next week" (It should list it as "today"). All todays outgoing email is dated 11/13/09 on the receiver's end (so my clients don't think they've received it because their email program is filing it under 11/13/09. All incoming email has the right date on it. My sent file has the wrong date. This is bizarre! Please somebody help me.....

More replies
Relevance 57.81%

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?

Answer:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here:

3 more replies
Relevance 57.81%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?

Answer:Excel 2007 - Start Date and End date question

16 more replies
Relevance 52.48%

I recently deleted my colleague's distribution list. Fortunately I have another colleague who has the same distribution list on her PC . It is the same outlook 2007 on both PC . I followed the usual way of exporting and importing the csv file in both window and csv format . But I am still not able to get the distribution list on the deleted desktop ? What is the possible issue here ?


Answer:Importing Distribution list from Outlook 2007 to outlook 2007

The only advise I have is to give you incite into the cvs file.

It is the equivalent of a XML markup, but a file a programmer likes to deal with better. It's laid out in what is known as comma delimited formatting. That means, when the file is being read by a program, it stops at the comma's. Everything before the comma is the current entry. Everything after the comma is the next entry, and before etc. The read stops when no more commas are found, and the last entry is taken.

Comma delimited format should allow for the cross platform exchange. If it doesn't try using the XML format instead.

Hope I helped.

2 more replies
Relevance 52.48%

I have MS Outlook 2007 (part of Office 2007 Enterprise Edition), need Outlook 2007 with Business Contact Manager. Anyone know how to get it? I don't see an add-on upgrade option.

Answer:Have Outlook 2007, Need Outlook 2007 with Business Contact Manager

it's part of 2007 Professional, Small Business, and Ultimate. It's not licensed for use with Enterprise.

1 more replies
Relevance 49.61%

I recently purchased a new computer that has Office 2010 installed. I would like to move the contents of my .pts file from my old computer which has Outlook 2007 to my new computer which has Outlook 2010. Before, when I wanted to transfer my .pts file from one computer to another I would just copy the file to a portable hard drive and then transfer the file to the other computer. However, Outlook 2010 is completely different animal. When I go to C:, Users, App Data, etc., new computer, it is completely different from my other computer that had Vista. My question is, how can I transfer my .pts file and/or my address book, calendar, contacts, etc. for my older Windows Vista computer that had Outlook 2007, to my new computer that has Windows 7 and Outlook 2010 installed? Thanks in advance for any and all suggestions.

Answer:Solved: Moving Outlook Messages and Address Book From Outlook 2007 to Outlook 2010

Hello referee07;

Copy your .pst file from your old computer to the new one or your portable hard drive.

To launch the Outlook 2010 Export/Import wizard, first go to File menu, navigate to Open, and click Import.

In the Import And Export wizard, select Import from another program or file option and hit Next

Under File Type, select Outlook Data File(.pst) and hit Next

Now choose the file to import, select the options, and hit Next

Once done, finally select the folder to import from(if you want to import complete data don’t change any settings) and make sure Include subfolders is checked. You can either import the file to the current folder or choose the folder.

Hope this helps!


3 more replies
Relevance 49.2%

Hello Everyone!

I have a field that has Days (Ex. Monday, Tuesday etc...)

Is there a way to turn this Days into a nearest date coming up. So for example if i have Wednesday on the field as a value and today is tuesday... I want the date for tomorrow displayed.

I have been doing research but I cant find anything. I have found the opposite but it doesnt do me any good. Thank you very much.

Answer:Access 2007 Day To Date Help

16 more replies
Relevance 48.79%

I am attempting to find add-ons for Outlook 2010. This is what I need the add-on to do:
Export an email from Outlook onto our server, and into a job folder.
Save file with date email was received, not exported out of Outlook, and subject line.

Answer:Outlook 2010/export emails from outlook to CSV folder with received date and subject

Why not drag and drop the email to the file system?

3 more replies
Relevance 48.79%

On computer1, I have successfully created a customized form with user-define fields in Outlook 2007 and a merge document in Word 2007 that works (starting the merge from Outlook 2007). I want to copy the custom form with the user-define fields and the merge document to a second computer (computer2).

I saved the custom form with fields from computer1 to a *.fdm file using the Tools, Options, Other, Advanced Options, Custom Forms, Manage forms. On computer2 I used the same process to install the custom form file (*.fdm) into Outlook 2007 and created a new contact folder that uses the form and displays/adds new contact records correctly. I also copied the Word merge document to computer2. Computer1 and computer2 both have Office 2007.

All the problems occur on computer2. First, when I attempted to merge (starting in Outlook 2007), Word gave messages that all my user-defined fields did NOT exist in the database although I could see them in the Contact records. I attempted to create a new document and the user-define fields do NOT show up in the Word merge field list either.

On computer2, I created from scratch a new contacts folder with a new custom form and user-define fields which works when merging. Therefore, the problem seems to be that Word can not see the fields I created from the *.fdm file I installed.

Can anyone please help me with this? Thank you in advance.


More replies
Relevance 48.79%

Have been trying to follow suggestions from similar posts, but nothing working. Have tried to save as .xls and .csv, as well as trying to 'define names' of the various columns, but nothing allows me to import complete contact into Outlook. Please help, very important to get these contacts into Outlook asap. Thank you

Answer:Issues importing large contact list in Excel 2007 to Outlook 2007

Hi hbsurfer

Try going about it backwards.
Create one Contact in Outlook 2007, then Export that one Contact to a .csv file.
Then you will be able to see the format Outlook 2007 is using and reconfigure your headers in the Excel spreadsheet.
When all headers match, you should be able to Import it. Or copy the excel information to the one contact .csv file and Import that.

Let us know if that works for you or not.

1 more replies
Relevance 48.79%

Outlook 2007 mail search is incomplete when Visio 2007 Pro is installed.

Already uninstalled and reinstalled Office 2007 Pro SP2, Project 2007 Standard and Visio 2007 Pro.
Rebuild indexing and again uninstalled Visio 2007 Pro. Mail Search working as long as Visio not installed.

Windows XP SP3
Windows Search 4.0
Internet Explorer 8

Any suggestions as to why.

More replies
Relevance 48.79%

hebrew font is not recognised in Outlook 2007 although it is installled in office 2007 and works well in word 2007 & exel 2007 - the hebrew text always comes up as ?????.?????? when displaying the senders name in an email received - instead of the hebrew text.Can anybody correct this ?

Answer:hebrew font is working in word 2007 but not in outlook 2007

Do you have any COM add ins? Can you copy and paste the Hebrew lettering from word to an email in outlook (may be a quick work around)?Im unsure of the specifics to your problem but I did find this on the internet:in order to display multibyte (ie hebrew) characters correctly,- you must use a Unicode-type PST file- you must run Outlook in Unicode mode- the incoming message must be properly encoded (by the sender) as Hebrew.

3 more replies
Relevance 48.79%

Running Vista Ultimate (32 bit) on HP Media Center Desktop Unit (8100y). Each time system is booted up and Outlook 2007 is accessed for the first time, Microsoft Office 2007 begins to reconfigure itself. Neither canceling of the configuation process nor allowing the process to complete seems to have any apparent effect on subsequent operations.

Performed repair function on the Office application without any discernible effect. Any help in resolving this issue would be truly appreciated!

Answer:Starting Outlook 2007 causes Microsoft Office 2007 to reconfigure itself

8 more replies
Relevance 48.79%


I have upgraded to Office 2007 from Office 2003. When I open an Excel attachment from email in Outlook 2007, the Excel application opens but the document itself does not. The document has a .xlsx extension. I need help resolving this issue please. If anyone knows why this is happening or the fix, I'd appreciate your insight.


More replies
Relevance 48.79%

The following hyperlink in Microsoft Word opens up a contact from Outlook. Is there an easy macro that goes to that contact, and adds to the work document, the words from a certain field in the contact. I have new fields in my contact form, and want the word document to show the words from some of those fields.
Here is the easy hyperlink to a contact in a subfolder of contacts:
Outlook:Contacts/Subfolder Name/~Contact Name Thanks very much.

More replies
Relevance 48.79%


I am creating a spreadsheet for a school that I work in. I am very new to access and really have no clue what I am doing. Right now I am tracking the teachers and their credentials. I have a checkbox where I check whether the teacher has a license or not and then a exp date for when the license expires. Is there anyway to make it that when the expiration date passes the box becomes unchecked and is higlighted or flashes another color? Or if I put in a year a training was taken, 1 year later that check box becomes unchecked and flashes or is highlighted?

Please someone help me! And remember Im a real novice and so need step by step instructions!

Thank you for your help!!


Answer:Access 2007 Expiration date

7 more replies
Relevance 48.79%

why can't it be on dec.

Answer:is 2007 the final date for vista?

I have heard rumors that some businesses are getting vista in late november. From microsoft's website, it appears that they are planning to release it in 2007.

As to why? The reason is probably that debugging the code, replicating the CD's, distributing it etc. cannot be completed before then.

18 more replies
Relevance 48.79%

Hi, im new to excel 2007. I have clues, but no ideas. lol. i hope somebody knows what to do here. I am making a job application search log and in one column i have 'date resume submitted' where all i put is the date of the day i apply somewhere. in the column just next to it i have 'days out' whereas i have a DATEIF code which displays year, month day of how long its been since i faxed/emailed/communicated with the potential employer. currently i have a formula that once i put the date into the j column(date resume submitted), it will automatically start calculating ages. So lets say the next day or even 2 weeks later, i enter this worksheet, it will tell me exactly how many days or months it has been since the date i applied for that company. heres my dilemma. everytime i place a new job into this worksheet, i have to tell the 'days out' DATEIF formula exactly where the date is sitting. its awfully annoying. i cant figure out how to just formulatize the entire column to automatically look for a date just one column over. arghHere is a few of what formula i am currently using and any help would be greatly appreciated! thank you.Jeff=DATEDIF(J6,NOW(),"y")&" Y, "& DATEDIF(J6,NOW(),"ym")&" M, " & DATEDIF(J6,NOW(),"md") & " D"-whereas J6 would be where i put the date and k6 would be where it would display (0Y,0M,5D)(for 5 days since i applied for this job).now what happen... Read more

Answer:ms excel 2007 age calculation with date help

Select the last cell containing the formula (K6 in your example) and drag the bottom right-hand corner of that cell down one (to K7 in your example), then release the mouse.

4 more replies
Relevance 48.79%

Is it possible to enter a date as a relative ref across sheets in Excel 2007?I have a date in A1 in sheet 1. If I want to reference this cell in Sheet 2 and add 7 days, it does not seem to work as I always get just the Sheet 1 ref in all the following sheets.

Answer:excel 2007 increment date

How are you referencing your sheets?On sheet 1 in cell A1: 03/28/11On sheet 2 in cell A1: =Sheet1!A10+7 give the date 04/04/11MIKE

2 more replies
Relevance 48.79%

Excel 2007 - I have a date in a cell like this 20091125. It is text, it's a date but without the dashes or slashes to separate the year, month, day.
How do I convert it to 2009-11-25 date? Is there a function that reads it without the dashes yet recognizes it as a date?

Answer:Excel 2007 Date Function

7 more replies
Relevance 48.79%

When I open a word document that I have on file it automatically updates to the current date. The only auto update box I can find (and it is not ticked) is on insert date and time. Any ideas please

Answer:WORD 2007 date keeps on updating

but in Word 2000 you can insert a "Create date", via a field, which then doesn't update. It sounds as though you may have a field that is just "Date".Note that what I'm suggesting refers to a "Field".Apologies if this doesn't help!Regards,Simsy

3 more replies
Relevance 48.79%

I have a spreadsheet of inventory items and the dates are in various formats Europe , USA , and Eastern.
Example below. What I need to do is select all the dates and covert into one recognizable formula
Month (1) Day (1) Year (****). Let me know how to do this. Thanks!

Answer:Excel 2007 Date Factor

select the cells of interest
right click within that selection
select Format Cells... from the context menu
select Custom from the Category: column
select m/d/yyyy from the Type: column
select OK to close and apply the formatting

1 more replies
Relevance 48.79%


I have a form with a listbox on it which displays all the data in one of my tables. I also have a combo box which displays a list of dates (short date) from the table.

I'm trying to query the table based the combobox to get all the records that came after that date.

However, at the moment, when i enter a date, and the list is requeried, the data is not correct.

For example, there is data for everyday (from 12/10/2010 to 26/10/2010) so if i select 12/10/2010 from the combo box, id expect to see records from 13/10 to 26/10.

what i actually get is some records starting at 24/10.

If i change the query so that it looks for records before the selected date, nothing is returned.
Any suggestions as to whats going on?

Answer:Access 2007 Date Filter

16 more replies
Relevance 48.79%

Hi all, OBP has helped greatly with my access issues but ive stumbled accross another which i just dont understand.

I have a form with several textboxes on and two buttons.

The user enteres search criteria into the boxes and then each button performs a different query.

One of the textboxes is for a date. with one query it works fine, you can enter a date and it brings back the expected results, with the other, i get nothing whatsoever.

In the working query, the date is queried using :
Like "*" & [Forms]![frm_Search_CertificateOfConformity]![Date Scanned] & "*"

In the other query:
Like [Forms]![frm_Search_CertificateOfConformity]![Date Scanned]
I really dont understand why it doesnt work.
Any assisstance will be appreciated.


Answer:Date search in Access 2007

10 more replies
Relevance 48.79%

Hi, how to add a sum for a date lets say 2/3/2012, i want a formula which will autopopulate the date automatically to 2/08/2012 that is 2/03/2012 + 5 months, please help

Answer:Date formula in excel 2007

Search Excel for edate function.

3 more replies
Relevance 48.79%

Does anyone know how to remove the auto-complete of the date when using Word 2007. I've tried with earlier versions of Word but found that all I could do was to turn off auto-complete altogether. It's so irritating when I forget use the space-bar after the date and pressing Enter/Return auto-fills in American style.

Answer:Autocomplete of Date in Word 2007

Click here

5 more replies
Relevance 48.79%

Hi folks.
Got a small problem I'm stuck at.
When I type 2011 Word offers me a date update in the format 2001-01-27. Does anyone know how to change this to a UK setting.
I've tried looking in Word Options without finding anything.

Answer:Date correction in Office 2007

9 more replies
Relevance 48.79%

I am new to using Access 2007. Please help if possible. I have an access 2007 query and I need to sort it by dates. I have 3 field dates... need to sort each field if not null.

I need for it to sort by field1 date first, and it field1 date is null, sort by field2, and if field2 date is null, sort on field3.

I hope I explain it good enough...I am a rookie.

Answer:Access 2007 Query Date

Hi and welcome to the forums

Please only make one thread per issue, as having duplicates will confuse things . I've removed your old thread and moved this one to a section that may get some more answers.

3 more replies
Relevance 48.79%


im a student in intern programe right now. my organization give me a ms access file that contain information of contract workers. they ask me to use access and make a pop up to tell the user 3 months before contract expired. what make im more crazy when she ask me to make due date field become bling bling or shiny to make us easy to check. im not familiar with access and i never use it before. what i was google before and i dont get the answer that i want.

i already post the same question on other web and I hope I got what I want.

please i need help i dont care who you are and i really want to say terima kasih (thankyou)

Answer:Ms Access 2007 Due Date Pop up Tutorial

16 more replies
Relevance 48.38%

I'm helping a friend upgrade her computer and one of the things I did was helped her acquire and install a copy of Personal Office 365, which includes Outlook 2016. She's been doing her email on until now but now wants to use Outlook 2016.

I'm trying to figure out how to make all her various folders and email visible in Outlook 2016 but have no idea how to do it; I have very little experience with either Outlook or

Can someone tell me what I need to do? It would be absolutely fine to point me to a tutorial; I just don't know what search term to use with Google. I have to assume this is a simple, routine thing that millions of people have done. I just don't know where to find instructions.

She's running Windows 10 as her OS.

Answer:Moving date from to the Outlook program in Office 365

Hi. Here's a little info on Outlook files:
Introduction to Outlook Data Files (.pst and .ost) - Outlook

Your pst/ost file needs to be located and copied, (for a backup). You then export it through the O2013 program, and import it to the new outlook 2016.

Edit: no, wait - she was using I have to think about that. I think you can just setup the account in O2016, and everything should sync?

6 more replies
Relevance 48.38%

I'm helping a friend upgrade her computer and one of the things I did was helped her acquire and install a copy of Personal Office 365, which includes Outlook 2016. She's been doing her email on until now but now wants to use Outlook 2016.

I'm trying to figure out how to make all her various folders and email visible in Outlook 2016 but have no idea how to do it; I have very little experience with either Outlook or

Can someone tell me what I need to do? It would be absolutely fine to point me to a tutorial; I just don't know what search term to use with Google. I have to assume this is a simple, routine thing that millions of people have done. I just don't know where to find instructions.

She's running Windows 10 as her OS.

Answer:Moving date from to the Outlook program in Office 365

Hi. Here's a little info on Outlook files:
Introduction to Outlook Data Files (.pst and .ost) - Outlook

Your pst/ost file needs to be located and copied, (for a backup). You then export it through the O2013 program, and import it to the new outlook 2016.

Edit: no, wait - she was using I have to think about that. I think you can just setup the account in O2016, and everything should sync?

0 more replies
Relevance 48.38%

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: AMD A6-7310 APU with AMD Radeon R4 Graphics, AMD64 Family 22 Model 48 Stepping 1
Processor Count: 4
RAM: 7113 Mb
Graphics Card: AMD Radeon(TM) R4 Graphics, 1024 Mb
Hard Drives: C: 814 GB (753 GB Free); D: 17 GB (2 GB Free); E: 97 GB (73 GB Free);
Motherboard: HP, 81F5
Antivirus: Windows Defender, Disabled

I have a form that gathers the required information from within the database

I then use this code to send the email

Private Sub Command20_Click()
'sending email
Dim mess_body As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)

Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.BodyFormat = olFormatHTML
.To = Me.Email_Address
.Subject = Me.Mess_Subject
.HTMLBody = Me.messtxt
If Left(Me.Mail_Attachment_Path, 1) <> "<" Then
.Attachments.Add (Me.Mail_Attachment_Path)
End If
'.DeleteAfterSubmit = True 'This would let Outlook send th note without storing it in your sent bin
End With
'MsgBox MailOutLook.Body
Exit Sub
MsgBox "An error was encountered." & vbCrLf & "The error message is: " & Err.Description
Resume Error_out
End Sub

Everything wor... Read more

More replies
Relevance 48.38%

I am running windows 7 on a new computer. Outlook 2007 is freezing many times after it is opened. I click on an e mail and it just freezes.
Word has done it also but not as bad.

More replies
Relevance 48.38%

Ok so this probs isn't the ideal forum for Outlook and Exchange queries, but I know theres many skilled technical people on here, so posting on the off chance.

Anyway I run Outlook 2007 at work and I recently migrated from Exchange 2003 to Exchange 2007.
I like to secure my email communication as much as possible and thus like to make use of the free Digital Signature obtainable from Comodo.

Now my problem is when I send an email signed with my digital signature, a winmail.dat file is attached to the message. I have a few recipients that have their mail servers configured to block *.dat file attachments.

Reading resources on the web it seems the winmail.dat file is attached to RTF encoded messages.
However the winmail.dat file is attached even when sending the message in plain text when also signing the message with my digital signature.
I know I can just decide not to sign the message to problem recipients, but I never had this issue with Exchange 2003 so don't see why I should have to use this workaround.

Wake up Microsoft, not everyone in the world is running Exchange server and Outlook clients!!!

Hopefully some email expert will come across this, if not thanks for looking.


Answer:Outlook 2007, Exchange 2007, S/MIME and Winmail.dat

I have exactly same problem with Outlook 2007 without any Exchange server. Is there any solution for this?


3 more replies
Relevance 48.38%

Hi all. I have being going round in circles rying to make a mass mailing ( via email). I have a excell data sheet with company names, person names and email adresses
and I want to send out with personally adressed to emails to approx 500 people. I have been tetsing it all week and so far i can not get 1 single adressee on an email

The opnly thing which helps is copying and pasting the adresses in the BCC field which i dom not like. Any suggestions?

Answer:Making a mailing with Outlook 2007 from Excell 2007

Hello Fozzie,

I have some code which will do this with a little bit of tweaking. Can you give an idea on the layout of the information you have so I can write some code for you? Assuming you still have the issue of course.

Also there is one thing I can think of which could be an issue, when you use code to send email via Outlook there's security features which flag up the fact that Excel is trying to use Outlook to send an email and you have to click "Yes" before it sends it. This might flag up for each email the VBA tries to send when it's looping through the 500 names which may defeat the object for you.

4 more replies
Relevance 48.38%

Outlook 2007 is intermittent when viewing an individual email (I'm running Windows 7) .... Seems like the body of the email is always viewable in the preview screen... BUT when I click to open the email, sometimes the body is there but most of the time it's completely blank (ie not even any red "x")... If I close Outlook completely, then re-open; it works for a few emails then completely blank (except for to "from", "to", "subject")...

With the "blank" email open, if I then click on "other actions" then "view in browser", I can see the body in the Internet (defaulting to "Opera") Browser....
I have gone into the "Trust Center", "Automatic Download" and "clicked "off" the "Don't download pictures automatically in HTML e-mail messages")...

Any ideas???

Answer:Solved: Outlook 2007 (professional plus 2007 with Windows 7)

I kept working Outlook... got a few more descriptive errors.... found this link which solved my problem...

1 more replies
Relevance 48.38%

When I try to open an Excel document attached to a email Excel opens but the document doesn't appear until I click on the minimize button. Has anyone seen this before?

I'm Using Excel 2007 and Outlook 2007.

Answer:Opening 2007 Excel documents in Outlook 2007

12 more replies
Relevance 48.38%

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Ultimate , 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU T5750 @ 2.00GHz, x64 Family 6 Model 15 Stepping 13
Processor Count: 2
RAM: 3070 Mb
Graphics Card: ATI Mobility Radeon HD 3400 Series, 256 Mb
Hard Drives: C: Total - 113859 MB, Free - 60738 MB; D: Total - 110275 MB, Free - 61717 MB;
Motherboard: Acer, Inc., Chapala , Not Applicable, LXAQB0X612826017F32500
Antivirus: AVG Internet Security, Updated and Enabled

For no apparent reason my version of MS Outlook has suddenly gone belly-up. All other apps. in Office work fine.
When I now try to open Outlook I receive the following "Cannot open your default email folders. The file C:\User\Maurice\AppData\Local\Microsoft\Outlook\Outlook.pst is not a personal folders file"

I have tried uninstalling and re-installing Office from the original disks a number of times, I have successfully installed this on another Win7 desktop computer partition and it works fine. I have attempted to follow the MS repair online notification for .pst but it doesn't seem to work (or maybe it is me that isn't working). Most frustrating. Any word by word suggestions greatly appreciated.

More replies
Relevance 48.38%

Can anyone please help. I'm trying to look at Outlook 2007 Calendar Appointments in Access 2007.

I've seen many postings discussing adding appointments from from Access into Outlook, but I want to look the other way.

The code I've started with is

Dim olapp As Object
Dim olappt As Object
Set olapp = CreateObject("Outlook.Application")

...but that's as far I can get. I'm lost after that.

My game plan is to link our Exchange Calendars used on ipad2's to our Access database, to store Sales Rep visits against customers visited, straight from the ipad into the database.

Anyone know how? I'd be very grateful.

Answer:View Outlook 2007 Appointments in Access 2007

Exchange server is a database that can be queried by other databases. Look up Exchange OLE DB

1 more replies
Relevance 47.97%

hi everyone, i found this site it has a countdown to the release date of office 2007. I was wondering if any knows if this site has the actual date???

k. walker

Answer:microsoft office 2007 release date


1 more replies
Relevance 47.97%

Is it possible to have the month say April in cell A1 then in A2 have Sat 1st then auto fill down column A with day date so in A3 would be Sun 2nd ect.

More replies
Relevance 47.97%

My database contains date fields that indicate when a particular action needs to be executed (e.g. send a follow up letter to the sales call).
Can Access 2007 be configured to alert me when that date arrives?
Thank you.

Answer:Solved: Access 2007. Can it alert me when a date is due?

16 more replies
Relevance 47.97%

1 December 2010-12-01 - that is, when I press enter, it auto sets the date

Anyone knows how to fix it

Answer:Word 2007 Date format issues

Not sure what you're saying when you press date and time on the insert menu it doesn't insert the format you choose?

alt, shift, d will give you the 11/30/2010 format

9 more replies
Relevance 47.97%

In Excel 2007, Is there a way show a date stamp of when data was entered into a cell? So when you hold the cursor over the cell it shows you the date the data was entered?

Answer:Solved: Excel 2007 date stamp

7 more replies
Relevance 47.97%

Hi,I am trying to make a list(Column)with the date/day for a month(s).
e.g in A1 I have the month say March in A2 I want 1st Wed. Is it possible to then drag down to fill the rest of the month with date day?. Help please

Answer:Insert Date and Day and Month Excel 2007

In second cell type 1/3/17, in next cell below Right click on bottom left of cell, drag down to cell 33 let go and choose fill series

3 more replies
Relevance 47.97%

I am using Word 2007. Each time I open a .doc or .docx file, the date modified changes, as displayed in Windows Explorer. This happens when I just choose file open, and then exit, without ever doing anything with the file.

Previous versions of Word would appear to do the same thing. However, when the file was closed, the date modified in windows explorer to revert back to the previous date. Word 2007 causes the current date accessed to become the date modified.

This makes it very confusing, as it looks as though I am making changes to the file, when I am not.

Help appreciated...marty

More replies
Relevance 47.97%

I have imported data from Peachtree into Excel. My date formats look like 1/1/2010, 2/3/2010 and 3/22/1010. I need to group the data by month. However, when I use the =month() function Excel returns 1/1/1900, 1/2/1900 and 1/3/1900, respectively. I've tried copying the dates and pasting them back as values, but I get the same outcome. What should I do?

Answer:Struggling with Date Formats in Excel 2007

MONTH() will return 1/1/1900, 1/2/1900, etc. if the cell that the MONTH() function is in is formatted as a Date.Excel stores dates and times internally as numbers, with the Integer portion being the date and the decimal portion being the time (stored as the decimal portion of 24hrs).Since the Excel calendar starts on 1/1/1900, if the MONTH() function returns 1 and you format that cell as a date, it will return the date for Day 1 or 1/1/1900.Try this: Enter a 2 in any cell and format as a date. You should get 1/2/1900 since that is the date for Day 2. Thus if any function returns a numerical value and you format it as a Date or Date & Time, Excel will return the equivalent Date/Time for that number.Change the formatting of the cell in which you are using the MONTH() function and you should no longer get 1/1/1900, etc.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 47.97%


I believe this is a really easy thing to do but i can not get it to work,

I have a table that contains a name and the dates that they are on holiday. i am wanting to have a query that will show me everyone who is on holiday in February.

I thought this was simple but i have not been able to get it to work, i think i am missing something really really simple.

I have attached a copy of the table, the table is part of a college project and all data is fictional.

The attachment is zipped so it could be attached


Answer:Solved: Access 2007: date Query

James, to find all dates for February can be done in 2 ways, you can use from the 1st (startdate) to the 29th or 28th (eneddate) and then type in the Query Criteria Row
between 01/02/2008 and 29/02/2008
or you could use the Date part or date Format to extract February form you date and then compare it to February, but that only works if you have one years worth of data.
I can't help with your zipped file as I do bnot have Access 2007.

2 more replies
Relevance 47.97%

I know nothing really about visual basic! I have created a document in Word that list several different tasks that need to have due dates beside them. Here is a rough example (not my actual doc):

1. Deposit for project due ______. (this is also the project start date)
2. Paper is due ________.
3. Photos due _________.
4. Article is due _______.
5. Final prduct received ______.
I created a simple macro that takes the current date then adds a certain amout of days for the due date. But what I really need is to create a macro with a specific date then calculate the due dates based on the specific start date. So if I am filling my form in a couple weeks early I can put my desired start date then fill in due dates from there.


Answer:Word 2007 Calculate Date Macro

Why not do this in a spreadsheet?

1 more replies
Relevance 47.97%

I'm trying to write a function to return the last saved date from a given workbook. I understand the basic function to return this information from the active workbook, example below.

Function LASTSAVED()
LASTSAVED = ThisWorkbook. _
BuiltinDocumentProperties("Last Save Time")
End Function

What I want to do is to be able to return the last saved time for a given workbook within a different workbook.

Example I'm using VLOOKUP to pull in various order information and would like to show when the source from the table array was last saved.

Thank you in advance for your help.


More replies
Relevance 47.97%

Trying to finish my group project in my senior AIS class. I need to design a query that pulls the date value from an employee list if the current date is 6 months from the date when employment began.

This is the only part of the query that I cannot seem to get to work and is holding up the update function of the query to increase the employee's pay rate.

I followed what was in the help function of Access and thought I had corrected it look back over 6 months but it didn't work at all. Myself and the rest of my group would appreciate the help.

The spider web as we have nick named it.

Disclaimer: The above is a fictional company created for the project including fictional data for testing purposes. Just saw the disclaimer at the header of the business app forum and wanted to get that in there.

Answer:Access 2007 and date query functions

16 more replies
Relevance 47.97%

How do you insert a date field in Word 2007?

Answer:How do you insert a date field in Word 2007?

In Office 2010 at least, it should be under the "Home" or "Insert " tab. Then there should be a sub-category like "Date" or "Time".By the way. In the future, you'll get better office results here: and Answer. The way of learning.Dell Dimension 8300Intel Pentium 4 HT @ 3.20 GHz4 GB RAMNvidia Geforce FX5200

2 more replies
Relevance 47.97%

Hi, I am hoping for some to help with a spreadsheet I am creating for work. I have a drop down box set up in G2 when "Yes" is selected from this it stamps the date in the cell next to it (H2) this signals when a task was completed. The code I have currently got in H2 is
=IF(G2="yes", TEXT((DateStamp),"dd/mm/yy" ),"")
"DateStamp" is defined as
=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")
This is found in the name manager (ctrl+F3)

The problem I am having is that the day updates each day. So for example if I completed a task and marked it "Yes" today (01/02/11), and re-opened the task tomorrow (02/02/11) it would read as the 2nd Feb rather than the 1st. How do I get it to remember the day that the task was completed rather than today?

Thanks in advance for any help with this.

Answer:Excel 2007: Recording a date automatically

7 more replies
Relevance 47.97%

I have a macro that I want the user to input a date such as 12/08/08 and then conditional format column O for any cells containing date greater than the user's input date. The only thing it highlights is the header. I am not sure how to get the formula= MyDate to function correctly. Any help would be appreciated.

Sub TestUserInput()
' Macro1 Macro
Dim MyDate As Date
MyDate = Application.InputBox("Enter a Date")
' MyDate = DateValue(MyDate)
MsgBox "The name you entered was " & MyDate

Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreaterEqual _
, Formula1:="& MyDate"
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False
End Sub

Answer:Solved: Excel 2007 Date Variable

7 more replies
Relevance 47.97%

every time i switch laptop on the date n time is sept 2007 at 00.00 how can i set it to stay correct without having to reset it manually?

Answer:laptop date always sept 2007 til i change it

This is something that might work for you: HELP in posting on plus free progs and instructions Cheers

2 more replies
Relevance 47.97%

I have a user who is trying to update an Excel spreadsheet somebody sent them. In one cell, there is a reference to the date located in another cell. However, the way it is formatted, the date in the cell displays as just a number instead of the date ("September 22, 2010" displays in the 2nd cell as "40443".

In the second cell, there is some text along with the formula referencing the original cell containing the date. In the formula bar, it looks like this: ...Los Angeles, California 90013, on "&AP29&"

Yet in the spreadsheet, it displays like this: ...Los Angeles, California 90013, on 40443

In the original/refenced cell (AP29), the text entered into the cell is 9/22/2010, and is formatted to display as September 22, 2010.

Any idea how to correct the formula to display the date correctly?

Thanks a bunch.

Answer:Solved: Date format - Excel 2007

Hi Traci.

It's because the underlying value of the date is a number, which is how Excel interprets it no matter how it's formatted. To change it to display the date, you have to tell it it's a date within the formula. Try this:

...Los Angeles, California 90013, on "&TEXT(AP29,"m/dd/yy")&"

Without seeing the whole formula in the second cell I'm not quite sure about the positioning of the ampersands and quotes, but play around with it a little. Let me know if it doesn't work.

3 more replies
Relevance 47.97%

I am using the DateAdd feature in Access 2007 and need it to allow edits when needed. I've changed the "locked" to No but that didn't work. Any suggestions?

Answer:Access 2007 Changing auto date

6 more replies
Relevance 47.97%

How do I create a template which inserts the date automatically in a Word 2007 document, please. I thought that I had followed the directions, but the template which I have created does not change to 'today's date'.Thanks for any help.

Answer:Inserting date automatically in Word 2007

Provided the date is inserted as a field (under then insert menu) this should work fine provided the field is not locked.You may have to set the tickbox to update field under print options.You can use print preview to check that this is happening.

3 more replies
Relevance 47.97%

My DAQ system outputs the time and date for each data point collected in the first column along with the various signals in other columns, and I have at least 4k data points in each column. Time and data is given as shown below.11:54:23:11 - 23 MAY 1011:54:38:11 - 23 MAY 10I am trying to extract the time diference between the two data points by subracting the info in two cells, and obviously Excel does not recognize the info in the cell because of the presence of ":11" after hh:mm:ss info.How would I delete ":11" from the column and convert the given info to a Excel readable time/date format so that info in two cells could be subtracted to get the time difference.Thanks

Answer:Time and Date Format in Excel 2007

Are the Time & Date together in one cell?If the times are in there own cells, then Custom Format as:[h]:mm:ss.00This will allow you to keep the full time.MIKE

7 more replies
Relevance 47.56%

I am using MS Word 2007 - I use on a daily basis the track changes function - however, I am not (as used to be the case with MS Word 2003) able to see the Date/Time Stamp and the Reviewer's name when I drag my cursor onto the relevant "tracked" change (i.e. the insertion or the deletion). I have tried to contact Microsoft, but they want to charge me a fee equal to the purchase price of the Office Suite just to answer a simple question in respect of their own product. Can anyone please help me?

More replies
Relevance 47.56%

I have an Excel table that has records containing up to 32 different dates (D thru AI). I need to have a field populated to show the next upcoming date and a method to show the column title it was pulled from.

The only method I know is to create three fields;
(1) one for the Next Upcoming Date,
(2) another field next to it to populate with the Next Upcoming Date's Column Title, and
(3) a helper field to store information to help with the calculation to obtain the upcoming date's column title.

It would be better if the upcoming date and the date's column title were combined into one field.

The calculation I used (but haven't completed yet) is extremely long and I feel there must be a better way to achieve this but I'm not very experienced with Excel.

Next Upcoming Date calculation: =SMALL(IF(($D2:$AI2>TODAY()),$D2:$AI2),1)

Helper Column calculation: =MATCH(AJ2,D2:AI2,0)

Next Upcoming Date's Column Title calculation: =IF(AK2=1,D1,IF(AK2=2,E1,IF(AK2=3,F1,IF(AK2=4,G1,IF(AK2=5,H1,IF(AK2=6,I1,IF(AK2=7,J1,IF(AK2=8,K1))))))))
NOTE: This is the one I haven't finished because I will have to add an IF clause to it for each date. UGH!

Can anyone help me achieve this using a simpler method?

More replies
Relevance 47.56%

The company I work for has asked me to work with the DB (as you may well guess in this economy I now have to learn how to work with Access DB. This DB was created by someone who had a book “Access 2000 for dummies” in 2002, I have since then converted the 2000 DB to 2007 accdb format. That being said, in a form that is used to track records-TS# is the primary key, they want a YES/NO or actual name- Completed *check box for yes and blank for no*. I created the check box as you may know that was easy enough. The problem comes in when I go to the next record the box remains in whatever state it was on the previous record and does not show up anywhere else. I am sure this is likely because there are steps that I am omitting or not aware of. Any help offered would be amazing as I continue to work on this train wreck.


Answer:Solved: Access 2007 YES/NO field with time/date

Mike, the Check Box field has to be in the Table that the Form uses as it's Record Source. The Check box has to be "Bound" to that table's field, i.e. it's "Contorl Source" of the check box in design view must be the table field.

2 more replies
Relevance 47.56%

I have Office 2007 running on a Windows 7 64 bit Toshiba laptop. I am trying to separate the data and time in an Excel file in one column and put the date in one column and the time in another. I need a "how to" procedure to do that.

Answer:Separating date and time in Excel Office 2007

Excel has formatting for Date and Time.
For column A use a Date format, and for column B use a Time format.
To copy the value from column A to column B a function in column B like this should work
= IF(A1="","",A1)

5 more replies
Relevance 47.56%

I have pasted data in to Excel that is in two columns
Col A contains a list of dates, dd/mm/yy; col B times hh/mm/yy. How do I set about calculating and displaying the period in dd/hh/mm/ss that elapsed between col A row B with col B row B, and col A row C with col B row C ?

Answer:Excel 2007: a question about date and time manipulation

Post a picture of a sample worksheet containing sample data so I can fully understand what you need to do.

I will replicate the picture you post and can probably figure it out.

As I understand it, column A contains only something like 13/6/2007 (June 13, 2007). Column B contains hours I guess, but I need a sample to actually look at and ponder.

You want to calculate the total time elapsed between some time on June 13, 2007 in column A and some later time as shown in column B??

Column A contains no reference to hours? Hours are found only in column B?

More info please.

4 more replies
Relevance 47.56%

Greetings -


Target Complete Money
1 1/1/09 1/7/09 50.00
2 1/5/09 1/12/09 100.00
3 1/7/09 1/14/09 50.00
4 1/17/09 1/17/09 25.00
5 2/2/09 1/26/09 25.00
6 2/5/09 150.00
7 2/6/09 150.00
8 2/5/09 75.00

Currently i have the following formula to calulate how much money that I might make.

This works fine as I have no blank cells in column A

If I try to apply this formula to column B I get an incorrect number as I have blank cells in there with no values.

Is there a way to continue to use this formula but have it check for blank cells and if it finds any, don't add those values??

Answer:Excel 2007: Date/Sum Macro/Blank Cell

Welcome to the board.

How about the attached? Contains 1 "master" dynamic named range & 2 others based on the "master". Use E2 to define the month you're after.

3 more replies
Relevance 47.56%

Hi all.

I hope somone can help this is starting to annoy me.

I am building a database for the charity i work for to track our collection boxes that are out and about.
I am trying to put a button in so it will pull out all boxes that have been out for greater than 30 days. To do this i am using the field "Date Out" in the query and the criteria is:


This works but pulls our 200,000 results when there are only 1400 records in the table.

any ideas?

Answer:Solved: Access 2007 Date Query Problem.

7 more replies
Relevance 47.56%

Hi Everyone,
I am trying to create a query that selects all records with a future date. The table that I am trying to select the records from is named "Events" and the field containing the date is "Date"
I am using Access 2007 and the date field is formated as 'Date/Time' data. I tried multiples ways, and even tried the 1000 year add date function pasted in below. Does anyone have any insights--I'm sure its something that is quite simple.


SELECT Events.Date, Events.Event
FROM Events
WHERE (((Events.Date)=DateAdd("yyyy",1000,Now())));

Answer:Solved: Access 2007 Future Date Query

6 more replies
Relevance 47.56%

Is there a way to save a custom date format in Excel besides saving it in a spreadsheet and using that spreadsheet as a template?


Answer:Saving a Custom Date Format in Excel 2007

Click on the blue "?" (help) button in Excel and type "custom date" as a search term.

From the results, choose "Create A Custom Number Format". Scroll down and you'll see the options for creating custom date formats.

Hope this helps.

3 more replies
Relevance 47.56%

Hey, cant remove norton antivirus 2007 keeps coming up with an error message.

Answer:Norton antivirus 2007 - cannot uninstall out of date version

8 more replies
Relevance 47.56%

I want to know if there's a MACRO that I can use to calculate number of days excluding wkend. For ex: Today- due date = ___ days (not includng wkend)

Answer:Access 2007, Date Difference (excluding wkend)

Not sure if this is what you looking for

1 more replies
Relevance 47.56%

First, I'd like to say thank you for providing this great service.
I have a HP Probook, running XP. I have a project spreadsheet, gantt style, to track ongoing projects. I am tracking the start date, the due date and the completed date. I have a conditional format set to highlight a range of dates, yellow, on a calendar from start date to due date. The formula is: =AND(I$5>=$D6,I$5<=$E6). I would like to have the yellow blocks change to green when the project is completed. The date completed would be in cell F6. I would also like to have the same range turn red if the project runs pass the due date. The due date is cell E6. I5 is the first cell in the calendar row that runs across the spreadsheet. Any suggestions would be appreciated.

Thanks again

Answer:Excel 2007 Conditional Formating Date Range

9 more replies
Relevance 47.15%

The problem is 3 copies of each email coming into my inbox.

Problem started after I checked "Leave a copy of messages on the server" when I enabled a Blackberry for email using my email home account. If I uncheck it, one email arrives but then I don't get the email on the Blackberry.

I have worked through all the sources tech support people and the conclusion from all now is that it is an "Outlook" issue.

The mitigating issue that visually ties it back to Outlook is that my Task view also shows 3 copies of each task - and if I delete one, all 3 are deleted. When I view the "Personal Folders - Outlook Today" screen when it opens on startup, there is only one copy of each task. I click onto my inbox and the screen comes up with 3 copies of each task in the sidebar.

The mutiple emails are creating big issues as many are parts of a thread and senders do not change the Header so I have to check them all .............

Is there an Outlook wizard abel to provide a fix for this?

Answer:Outlook 2007 - Small Business 2007

Unless I'm missing the point here, th eanswer seems to be to revert tthat settings change you made to leave copies on the server. You only fail to see mail on the Blackberry because you've already received them on a PC or other device so why would you wish to see it again anyway?

Any mail you haven't received will show up on the first device that connects so when you're on the hoof with your Blackberry, make sure Outlook isn't open on your home PC and you will receive your mail on the mobile device.

Anoither method might be to set up another e-mail account, put it on the Blackberry only and have all your e-mails forwarded to that account. Then you have duplicates on both devices.


3 more replies
Relevance 47.15%

1) do I save excel as CSV (MS-DOS) or simply CSV (which i presume is "windows" version2) when following steps to import file into outlook, I select the file from which I want to import in "browse" and click next. most videos show the option to map custom fields, but that does not show for me....when I click next i simply get an error. I have read mention of exchange I need to have that running. Trying to save my wife a ton of work in consolidating a museum membership database from excel to outlook for email distribution of newsletters. Any tips would be appreciated

Answer:how to import csv from excel 2007 to outlook 2007

Where did you get the .csv file from in the first place? - the 'import' function in Outlook will only work if it was created on a similar email program - Outlook, Outlook Express etc. and no, you don't need exchange server to complete the task."I've always been mad, I know I've been mad, like the most of us..." Pink Floyd

3 more replies
Relevance 47.15%

I have had a few users complain about this, so maybe some one has some info.

If we have a press release in a Word document format, and we copy & paste the text into an Outlook e-mail, the formatting, in terms of size and font changes to Outlook's default. We've tried setting Outlook to RTF format, and then back to HTML format, to no avail. Is there a step or a trick I am missing, so we can copy from Word into Outlook, and maintain font and text size settings?

Answer:Word 2007 to Outlook 2007 Formatting

The default settings should maintain source formatting.

When I tried copying from Word 2007 to outlook 2007 the formatting stayed the same, but outlook doesn't have page breaks some of the text is layed out differently.

1 more replies
Relevance 47.15%

Out of the blue I can no longer see the preview of my INBOX email messages.

When I click on each message, the TO/FROM/SUBJECT headers change in the preview box but the message body still refers to the very first message I received.

I have turned the reading pane off, changed it to bottom, right and back to bottom but nothing works.

I ran the Office 2007 install CD and used the REPAIR option but still no joy.

Have Googled the earth for an answer but seems to only be me who has the issue.

Forgot to mention that even when there is a message body showing, there appears to be a lot of flickering on what contents are shown that makes me think the compatibility view has an issue maybe as I mentioned above!

Also checked my security settings and they appear (?) OK, any help appreciated!


More replies
Relevance 47.15%

I have a database of names, addresses, telephones numbers in excel 20007 Would someone please tell me how to export the list to Outlook 2007?


Answer:Solved: Excel 2007 to Outlook 2007

16 more replies
Relevance 47.15%

I used to add some of my important emails from Outlook 2007 to OneNote 2007.

Is there a way in Outlook to see which of the messages are added [exported] to OneNote 2007?

Answer:Outlook 2007 emails to OneNote 2007

If you use the Journal you should be able to see which ones are and aren't. Aside from that, unless you either flag it or mark it to a certain category, I don't believe so.

1 more replies
Relevance 47.15%

I have a Dell Laptop running Windows XP, Office 2007, and the Email Server is Exchange 2007. When setting up Outlook for the first time Originally it would pull the incorrect email address and settings (uninstalling Bonjour fixed that) now the correct email address is being pulled but it never seems to sync. When I hit Send/Receive the Sending finishes almost instantly but receiving never finishes. Logging in as anyone on this laptop produces the same result so it's not just my login.

Side Note*(Maybe important or not) Randomly a popup will say it's trying to sync with a different server that Exchange is not on. But I haven't seen that since I deleted the Archive.pst.

This is the only computer out of 72 with this problem on our network.

Answer:Outlook 2007 & Exchange 2007 Problem!

Try deleting the mail profile and instead of Outlook finding your settings automatically configure them manually.

1 more replies
Relevance 47.15%

I have Microsoft Outlook 2007 that I have purchased as a standalone program. Is there a way to get Excell 2007 as an add on for free if I produce the product key from Outlook 2007?

Answer:How do I get Microsoft Excel 2007 as an add on to Outlook 2007


However, there are free versions of Excel (later versions), such as the web version and the UWP version.

11 more replies
Relevance 47.15%

I am trying to write a function that will determine the first day of our fiscal year for whatever date is inputed into it.

Our fiscal year always ends on the friday closest to 1/31.

I'm having trouble figuring out how to deal with january dates.

Any help would be greatly appreciated.

Function FiscalYearStart(dteDate As Date)
Dim dteNextFriday As Date
Dim dteLastFriday As Date
Dim x As Integer
Dim dteJanThirtyFirst As Date

'set as january thirty first of calendar year
dteJanThirtyFirst = "1/31/" & Format(dteDate, "yyyy")

'if 1/31 is a friday
If Weekday(dteJanThirtyFirst) = 6 Then

'use 1/31 and exit function
FiscalYearStart = dteJanThirtyFirst
Exit Function

Else: End If

'set as friday after january thirty first
dteNextFriday = DateAdd("d", 8 - Weekday(dteJanThirtyFirst, vbFriday), dteJanThirtyFirst)

'determine day of week for january thirty first
x = Weekday(dteJanThirtyFirst)

'if weekday is saturday
If x = 7 Then

'subtract 1
dteLastFriday = DateAdd("d", -1, dteJanThirtyFirst)


'subtract 1 and the number of the weekday
dteLastFriday = DateAdd("d", -1 - x, dteJanThirtyFirst)

End If

'if last friday is less than next friday
If DateDiff("d", dteJanThirtyFirst, dteNextFriday) > DateDiff("d", dteLastFriday, dteJanThirtyFirst) Then

'use last friday and add 1 day to get start of fiscal year
FiscalYearStart = DateAdd("d&quo... Read more

Answer:Solved: Access 2007 VBA Fiscal Year Start Date

16 more replies
Relevance 47.15%


Can someone show me how to covert a date e.g. dd/mm/yyyy so that it reads as mm/yyyy only and so that a pivot table doesn't recognise the orignal long date of dd/mm/yyyy.

Tried using custom to mm/yyyy but pivot table still reads the date as dd/mm/yyyy.


NCFC (Newbie)

Answer:Excel 2007 - Change date format for pivot tables

hi NCFC,

Don't know about Excel 2007, but in 2003:

Right Click the Pivot Table,
Field Settings,
Select the field name that holds the dates,
Choose your format.


2 more replies
Relevance 47.15%

Access 2007 Update Query For Updating A Date Field

Hi I have been asked to write a query for an Access 2007 db

I need to update a date field in a table based on another date field in the same table

1st date field is the person's start date (StartDate)
2nd date field is the person's project date (ProjectDate)
Without going into too much detail, the Project Start date always begins on the 1st of the month

If the person's StartDate is between the 1st - 14th the project start date is counted as on the first day of the StartDate month/year

If the person's StartDate is between the 15th - end of month the project start date is counted on the 1st day of the NEXT month

StartDate = 7/1/2011
ProjectDate = 7/1/2011

StartDate = 7/14/2011
ProjectDate = 7/1/2011

StartDate = 7/15/2011
ProjectDate = 8/1/2011

StartDate = 7/30/2011
ProjectDate = 8/1/2011

I would like to update the ProjectDate in an update query

Any suggestions? Thanks

Answer:Access 2007 Update Query For Updating A Date Field

Create a Column heading like this
numdays: format([StartDate], "dd")
numdays: datepart("dd", [StartDate])
this will give you the day of the month on it's own
add a second Column
NewProjdate: IIf([numdays]>14,Format([StartDate],"mm")+1 & "/01/" & Format([StartDate],"yyyy"),Format([StartDate],"mm") & "/01/" & Format([StartDate],"yyyy"))

This will give you the date to use in the update query.

3 more replies
Relevance 47.15%

I have an access report that I would like users to be able to enter a start and end date. The report will be filtered to display data that falls between the two dates.

I have already created a form with date fields. I'm having a hard time figuring out how to use the form to filter the report. I also would like the report to display all data if teh user decides not to enter any dates.

How can this be done?

Any help will be greatly appreciated.

Answer:Solved: Access 2007/Filter Report By Date Range

There are many ways to do it, but I would set the filter in the OpenReport method when the report is launched, and provide logic to either set the start and end dates to extreme values (like 1/1/1904 thru 1/1/2999), which programming purists would tell you to never do, or not set the filter at all if the user doesn't enter a date.

In the code for the button that launches the report:

dtStart = Nz(Me.StartDate,#1/1/1904#)
dtEnd = Nz(Me.EndDate,#1/1/2999#)
DoCmd.OpenReport "Report1", acViewReport, "", "[MyDate]>=#" & dtStart & "# And [MyDate]<= #" _
& dtEnd & "#", acNormal

--- OR ---

If Isnull(Me.StartDate) or Isnull(Me.EndDate) then
DoCmd.OpenReport "Report1", acViewReport, "", , acNormal
DoCmd.OpenReport "Report1", acViewReport, "", "[MyDate]>=#" & Me.StartDate & "# And [MyDate]<= #" & Me.EndDate & "#", acNormal
End If

The tricky part is getting tripped up by not including the #, designating a date literal.


2 more replies
Relevance 47.15%

I've searched the forum and can't find the help I need...perhaps I'm not using the right keywords.

Anyway, I want to automatically have a time stamp entered in a field named "CancelDate" if a yes/no field named "Cancel?" is checked. On the form I use an action button for that field.

I'm new with VBA, but after some research I entered this code in the AfterUpdate line in Properties:

Private Sub CancelDate_AfterUpdate()
If Me.txtCancel?.value = 1 Then Me.txtCancelDate = Now()
End If
End Sub

...and it doesn't work. It seems to hang up because of the question mark. I get a Compile Error: Expected:Then or GoTo.

Can anyone help me?

Answer:Solved: Access 2007 Record Date When Field Updated

10 more replies
Relevance 46.74%

I need help trying to come up with a formula to calculate the sum of values (row 3), for the previous Friday to Yesterday's date i.e. Wed would sum Friday to Tuesday; Thursday would sum Friday to Wed...and Monday would sum Friday to Sunday.

My example is not posting correctly...but essentially Row 1 has Day headers (Monday, Tuesday, etc.); Row 2 has the actual date that corresponds with day header (3/7/2011, 3/8/2011, etc.); Row 3 has the values that I am wanting to sum according to criteria mentioned above. So for TODAY, 3/9/2011, I would like to sum the values of Friday, 3/4/2011, through Yesterday, Tuesday, 3/8/2011...and so on...
Greatly appreciated!

Answer:MS Excel 2007: Formula needed for sum of values from Friday to current date

9 more replies