A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

mailmerge date conversion



 
 
Thread Tools Display Modes
  #1  
Old March 19th 07, 03:08 PM posted to microsoft.public.word.mailmerge.fields
tamee
external usenet poster
 
Posts: 9
Default mailmerge date conversion

I have a mailmerge document with excel source data. I have date fields in
excel, but when I merge it reverts to the original serial number. How do I
convert it back to display the desired date format. Please Help. Thanks
Ads
  #2  
Old March 19th 07, 03:21 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default mailmerge date conversion

In response to your three(?) questions - From the Tools menu in Word, select
Options and then go to the General tab and check the box against the
"Confirm conversions at open" item. Then when you attach the data source to
the mail merge main document, you will be given the option of using the DDE
method of connection which should read the data as you have it formatted in
the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


tamee wrote:
I have a mailmerge document with excel source data. I have date
fields in excel, but when I merge it reverts to the original serial
number. How do I convert it back to display the desired date format.
Please Help. Thanks



  #3  
Old March 19th 07, 03:44 PM posted to microsoft.public.word.mailmerge.fields
tamee
external usenet poster
 
Posts: 9
Default mailmerge date conversion

Thank you so much for that! That's so much easier than toggling the fields
which doesn't work for my dates.

"Graham Mayor" wrote:

In response to your three(?) questions - From the Tools menu in Word, select
Options and then go to the General tab and check the box against the
"Confirm conversions at open" item. Then when you attach the data source to
the mail merge main document, you will be given the option of using the DDE
method of connection which should read the data as you have it formatted in
the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


tamee wrote:
I have a mailmerge document with excel source data. I have date
fields in excel, but when I merge it reverts to the original serial
number. How do I convert it back to display the desired date format.
Please Help. Thanks




  #4  
Old March 19th 07, 04:08 PM posted to microsoft.public.word.mailmerge.fields
tamee
external usenet poster
 
Posts: 9
Default mailmerge date conversion

Hope you could help me again. How Do you align currency figures so that the
values are right justified or all decimal points aligned together?

"Graham Mayor" wrote:

In response to your three(?) questions - From the Tools menu in Word, select
Options and then go to the General tab and check the box against the
"Confirm conversions at open" item. Then when you attach the data source to
the mail merge main document, you will be given the option of using the DDE
method of connection which should read the data as you have it formatted in
the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


tamee wrote:
I have a mailmerge document with excel source data. I have date
fields in excel, but when I merge it reverts to the original serial
number. How do I convert it back to display the desired date format.
Please Help. Thanks




  #5  
Old March 19th 07, 04:53 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default mailmerge date conversion

See the answer to your other post! There is no need to post the same thing
in several places.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


tamee wrote:
Hope you could help me again. How Do you align currency figures so
that the values are right justified or all decimal points aligned
together?

"Graham Mayor" wrote:

In response to your three(?) questions - From the Tools menu in
Word, select Options and then go to the General tab and check the
box against the "Confirm conversions at open" item. Then when you
attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should
read the data as you have it formatted in the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


tamee wrote:
I have a mailmerge document with excel source data. I have date
fields in excel, but when I merge it reverts to the original serial
number. How do I convert it back to display the desired date
format. Please Help. Thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge - File Conversion Problem Phil Galey Microsoft Word Help 1 August 18th 06 06:06 AM
Mailmerge date format Ocean Mailmerge 5 April 9th 06 06:28 PM
date mailmerge problem Bob Bedford Mailmerge 5 March 17th 06 09:57 AM
US / English date format mailmerge Bento72 Mailmerge 1 February 7th 06 02:57 PM
convert date format after mailmerge David.W. Mailmerge 1 May 9th 05 12:25 PM


All times are GMT +1. The time now is 10:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.