Microsoft Office Forums Help with switches: Word mail merge with Excel

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2009, 05:09 PM
ks_ ks_ is offline Help with switches: Word mail merge with Excel Windows 7 Help with switches: Word mail merge with Excel Office 2007
Novice
Help with switches: Word mail merge with Excel
 
Join Date: Dec 2009
Posts: 1
ks_ is on a distinguished road
Default 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!
Reply With Quote
Reply

Thread Tools
Display Modes


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
Help with switches: Word mail merge with Excel 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


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


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