HI guys - got a 2 part question.
Part A:
I've got a form letter (word doc) which I am using to merge an Access db with.
October 15, 2005
Mr. Joe Smith
ABC Hospital, Inc.
123 Easy Lane
Anytown, MI 48231
On page 2 & 3, I had inserted two bookmarks. At bookmark #1, is the current date at top of letter plus 14 days; at bookmark #2, is the current date plus 35 days.
Now i've got a small tiny problem because the letters are not always going out that same day. Sometimes I have to wait upon information from other people before mailing them out. The VBA code I had is no longer meeting my needs because I was using an an AUTO insert field at the top of the letter and based on that date, the VBA was calculating dates for bookmark #1 and #2 accordingly.
Now being the smart people you guys (& gals) are, I know you're sitting there wondering well why don't you just merge the documents again on the day the letters finally get mailed? The answer is that after I merge all the records, I customize each letter deleting certain paragraphs and adding certain sentences. I don't want to have to do that for each batch of 20-30 letters. It would be better for me to save the merged doc. say for ex: "Merged Documents Batch Run_A.doc" and then edit the dates accordingly.
How do you tell VBA to:
At bookmark #1: Insert whatever date that I type at the top of the letter.
At bookmark #2: plus 14 days
At bookmark #3: plus 35 days
Part B:
The merged doc. might have anywhere from 5 to 20 addressee's. So for example, the first merged record might be Mr. Joe Smith at ABC Hospital. I want VBA to create a subfolder under "C:\Letters Sent\" as "ABC Hospital" and then save his letter there. How can you get VBA to save each portion of the merged document and save it separately rather than the entire document?