 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2004Merge to Calendar??
Hi~ I'm not sure if it's possible, but it never hurts to ask. What I am trying to do is take a calendar item (Including program name/location/staff name)from an Excel spreadsheet, and merge it into a calendar format (preferably a month view) in Word. I've worked with several types of merges before, but I don't know that Word can merge to a calendar format. I am using Windows XP professional. (Outlook is not an option). Any suggestions?? Start with a table that represents the calendar in Word and insert Mergefields in the arrangement that you want and copy and paste into each cell with a << Next Record>> field before the first mergefield in all cells except the first.  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Hi~ > [quoted text clipped - 9 lines] > > Any suggestions?? Hi Doug, Thanks for the reply. I'm still a little confused on how to get only a certain date to appear on the corresponding date on the calendar. Example: A program begins on 9/1/04, and another begins on 9/15/04. How do I get them to show on the corresponding dates only, and not on any others? My idea was to use an "if then else" field, customized to each cell/day of the calendar. E.G. "If" begin date equals 9/1/04, "Then" insert(Program name), "else" type nothing. The roadblock that I am hitting is that it will only let me put in text in the "then" field. I would like to reference other merge fields from my data source, instead of typing text. Thanks for your help/suggestions!! Cara >-----Original Message----- >Start with a table that represents the calendar in Word and insert [quoted text clipped - 17 lines] > >. Do you have a record (row in your Excel file) for each day in the month? What I suggested would require that you do. Then with a label type mailmerge, the data for 9/1/04 (assuming it's the first record) would go into the first cell in the first row, that for 9/2/04 will go into the second cell in the first row, etc. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Hi Doug, > [quoted text clipped - 54 lines] >> >>. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.