Calendar Mail Merge??

Good Afternoon,

I have a fairly simple spreadsheet with less than 10 columns. Each
item (row) contains 3 dates, Open Date , Close Date and Live Event.

Is it possible to use this spreadsheet as the date for a mail merge
using Microsoft Word's Calendar Wizard? (Yes, I know this is an Excel
site).

Getting the mail merge to work is simple enough but I want to be able
to show what is going on that every day that month. Meaning, there
could be 3 different dates on 6/22/04. I want to produce the Item Name
and Respective date (Open, Close or Live) for all 3 events.

Maybe I should consider Access?

Thanks,


---
Message posted from http://www.ExcelForum.com/

Hi. If I were you, I'd consider another method. First, Word's mail merge
doesn't work that way, so it would require code. Second, I haven't seen a
calendar wizard recently that allows text to be typed into it.
-*--*--*--*--*--*--*--*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: www.VBAExpress.com
-*--*--*--*--*--*--*--*-
"JMax " wrote in message
...
Good Afternoon,

I have a fairly simple spreadsheet with less than 10 columns. Each
item (row) contains 3 dates, Open Date , Close Date and Live Event.

Is it possible to use this spreadsheet as the date for a mail merge
using Microsoft Word's Calendar Wizard? (Yes, I know this is an Excel
site).

Getting the mail merge to work is simple enough but I want to be able
to show what is going on that every day that month. Meaning, there
could be 3 different dates on 6/22/04. I want to produce the Item Name
and Respective date (Open, Close or Live) for all 3 events.

Maybe I should consider Access?

Thanks,


---
Message posted from http://www.ExcelForum.com/