LIFamilies.com - Long Island, NY


RSS
Articles Business Directory Blog Real Estate Community Forum Shop My Family Contests

Log In Chat Index Search Rules Lingo Create Account

Quick navigation:   

Word: Mailmerge question

Posted By Message

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Word: Mailmerge question

I'm attempting to mailmerge a list with dates. Database is in Excel. Mailmerging using Word. The dates are formated as "December 10, 2006" in Excel. When I mailmerge the list, it comes up as 12/10/06. I'm assuming I need to make the change in the field code but am not sure what that change would be.

Any ideas?

Posted 12/7/06 12:12 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Emily
Kasey & Me! Lurves it!

Member since 7/06

8703 total posts

Name:
STBHC

Re: Word: Mailmerge question

en englais sil vous plait! Chat Icon

Are the dates formatted in Excel to appear as "Month Day Year" or did you type it out? IF you just typed it out then Word won't know that's what you want. Chat Icon You will need to highlight the date comment and format the date prior to the merge.

Posted 12/7/06 12:14 PM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Word: Mailmerge question

Posted by EmilyAKAMrsK

en englais sil vous plait! Chat Icon

Are the dates formatted in Excel to appear as "Month Day Year" or did you type it out? IF you just typed it out then Word won't know that's what you want. Chat Icon You will need to highlight the date comment and format the date prior to the merge.



It's formatted already as MDY, but it's coming up as mm/dd/yy in word.

Posted 12/7/06 12:17 PM
 

Emily
Kasey & Me! Lurves it!

Member since 7/06

8703 total posts

Name:
STBHC

Re: Word: Mailmerge question

Posted by nrthshgrl

Posted by EmilyAKAMrsK

en englais sil vous plait! Chat Icon

Are the dates formatted in Excel to appear as "Month Day Year" or did you type it out? IF you just typed it out then Word won't know that's what you want. Chat Icon You will need to highlight the date comment and format the date prior to the merge.



It's formatted already as MDY, but it's coming up as mm/dd/yy in word.



Okay here is the 4-1-1:

1) Smack the computer
2) Beyotch at the computer
3) Fix it by hand in word Chat Icon

Posted 12/7/06 12:18 PM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Word: Mailmerge question

Posted by EmilyAKAMrsK

Posted by nrthshgrl

Posted by EmilyAKAMrsK

en englais sil vous plait! Chat Icon

Are the dates formatted in Excel to appear as "Month Day Year" or did you type it out? IF you just typed it out then Word won't know that's what you want. Chat Icon You will need to highlight the date comment and format the date prior to the merge.



It's formatted already as MDY, but it's coming up as mm/dd/yy in word.



Okay here is the 4-1-1:

1) Smack the computer
2) Beyotch at the computer
3) Fix it by hand in word Chat Icon



Just got it! Never mind. If anyone else is having the issue, let me know.

Posted 12/7/06 12:45 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
MS Word users: question? Diva 10/30/06 5 Families Helping Families ™
First question....now 2nd question... dree 10/27/06 10 Parenting
Paint Question (2nd question in org. post) MrsSchwags 10/5/06 12 Home
I have a question and Forgive me post( another question on bottom) luvsbob4603 6/16/06 14 Families Helping Families ™
Another question before I become a mom- Hospital question Shelly 4/10/06 11 Parenting
This isnt a TTC question - more so a BCP question Gdesq 5/25/05 9 TTC
 
Quick navigation:   
Currently 695524 users on the LIFamilies.com Chat
New Businesses
1 More Rep
Carleton Hall of East Islip
J&A Building Services
LaraMae Health Coaching
Sonic Wellness
Julbaby Photography LLC
Ideal Uniforms
Teresa Geraghty Photography
Camelot Dream Homes
Long Island Wedding Boutique
MB Febus- Rodan & Fields
Camp Harbor
Market America-Shop.com
ACM Basement Waterproofing
Travel Tom

      Follow LIWeddings on Facebook

      Follow LIFamilies on Twitter
Long Island Bridal Shows