#1
|
|||
|
|||
Help with switches: Word mail merge with Excel
Help!
I've got fields in Excel that I'm merging (via mail merge) into Word. These fields are formatted properly in Excel. For example, I have an "event date" that holds data formatted to display as "January 31, 2010." When these fields merge into Word, though, the dates change format and show up as, say, "40206." I thought using a switch would fix me up, but I'm not familiar with them and I'm doing something wrong. I Alt-F9'd, and changed { MERGEFIELD Event_Date } to { MERGEFIELD Event_Date \@ "MMMM DDDD YYYY" } { MERGEFIELD Event_Date [\@ "MMMM DDDD YYYY"] } { MERGEFIELD Event_Date \@ MMMM DDDD YYYY } { MERGEFIELD Event_Date [\@ MMMM DDDD YYYY] } { MERGEFIELD Event_Date \# "MMMM DDDD YYYY" } { MERGEFIELD Event_Date [\# "MMMM DDDD YYYY"] } { MERGEFIELD Event_Date \# MMMM DDDD YYYY } { MERGEFIELD Event_Date [\# MMMM DDDD YYYY] } ... nothing is working! Can anyone offer any pointers? Thank you if so! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
help with mail merge in MS Word 2003 | Dgbhunter | Mail Merge | 0 | 10-05-2009 03:16 PM |
Word 2007 Mail Merge | halfempty | Mail Merge | 1 | 03-03-2009 07:45 PM |
mail merge in word help | jngovols | Mail Merge | 0 | 04-07-2008 05:40 AM |
Word / Access - Mail Merge | ibuilders | Mail Merge | 0 | 07-30-2007 06:18 PM |
Word mail merge and formula | mridley | Mail Merge | 0 | 04-30-2006 11:26 AM |