Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-15-2011, 03:49 PM
Foxfire Foxfire is offline Using the Delay fields Windows 7 32bit Using the Delay fields Office 2010 32bit
Novice
Using the Delay fields
 
Join Date: Jul 2011
Posts: 3
Foxfire is on a distinguished road
Default

Thanks for the replies by the way, I really appreciate the help.

I have an SQL database I'm pulling the date fields from and here is what happens. Unfortunately I can't modify the date in the database at all, so I have to do it all on the letter.

Paid_to_date = 16/08/2011.

Invoice from <delay by 1 day> to <delay by 1 month>

The above merge fields pull through the following information.

Invoice from 17/08/2011 to 16/09/2011.

However without changing anything, if I create the letter from a file with a paid to date anywhere in February, it does the following:

Paid_to_date = 14/02/2011

Invoice from 12/02/2011 to 14/03/2011.

If I set the delay to 3, instead of 1. February then works fine. Maybe I typed something wrong. When I've a chance I'll double check it. But if the above field is correct, my letter should be correct.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
delay sending email and follow up on all emails lefteris Outlook 1 05-17-2011 05:11 PM
Using the Delay fields Delay delivery Registrar Outlook 1 07-01-2010 10:17 AM
Using the Delay fields Delay/Pause animated photo prior to next clipart BettyC PowerPoint 2 04-19-2010 02:12 PM
Email send delay--where? markg2 Outlook 8 02-14-2010 03:40 PM
How to delay sending an invitation... imported_misterbobthetomato Outlook 0 07-20-2006 07:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft