Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Word 2003 Mail Merge Problem


  • Please log in to reply

#1
andyp161

andyp161

    New Member

  • Member
  • Pip
  • 2 posts
When I mail merge from excel to word, the date format I want to merge from Excel, 'dd mmmm', is automatically converted by Word to 'mm/dd/yyyy'. Is there any way that I can either a) merge as 'dd mmmm' or convert back to 'dd mmmm' in Word.

Many thanks

Andy
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
"Typically the way to get the data in the nearest format to the one used to
display the data in Excel is to check Word Tools||Options|General|Confirm
conversions at open, go through the connection process again, then choose
DDE when it is offered. But this requires Excel to be present on the system
doing the merge and a copy of Excel is started which can sometimes create
problems.


i found this at another site...i'm still looking for something bettery..but this might make sense to you
  • 0

#3
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
this one is better http://homepage.swis...er/MergFram.htm

just look for the "Date format reversed" or something like that
  • 0

#4
Nat-UK

Nat-UK

    New Member

  • Member
  • Pip
  • 2 posts
I had that the other day, way I got round it was to re format the call as text only.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP