#1   Report Post  
Lexisch
 
Posts: n/a
Default Mail Merge Hell

I've been doing mail merge for over 25 years. I understand using Excel as a
secondary file.

We've had nothing but problems since upgrading to 2003. The sql feature, of
word changing the formatting of how time and dates from excel to the merged
file. I type the data in one way, and Word changes it.

I had a time field where I had a start - end time in one cell, and Word
decided to change the formatting...so I did a switch, which of course, made
the 2nd time not show up.

Is there a way to get out of this? More than half my company is ready to go
back to 2002. Mail merge is the life's blood of the place.
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

I am not aware of any differences between XP (2002) and 2003. There were
however major differences between 2000 and XP

You may be able to overcome your problems by selection Options from the
Tools menu and then on the General tab, checking the box against the
"Confirm conversions at open" item. When you do that, when you attach the
data source, you will be given a number of options for the method by which
the connection should be made. Try the DDE option.

Also see the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindy...r/MergFram.htm

and "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

though from the sound of it, you may be familiar with the latter topic.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Lexisch" wrote in message
...
I've been doing mail merge for over 25 years. I understand using Excel as
a
secondary file.

We've had nothing but problems since upgrading to 2003. The sql feature,
of
word changing the formatting of how time and dates from excel to the
merged
file. I type the data in one way, and Word changes it.

I had a time field where I had a start - end time in one cell, and Word
decided to change the formatting...so I did a switch, which of course,
made
the 2nd time not show up.

Is there a way to get out of this? More than half my company is ready to
go
back to 2002. Mail merge is the life's blood of the place.



  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help you
get back to methods with which you are familiar.

--

Graham Mayor - Word MVP

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




Lexisch wrote:
I've been doing mail merge for over 25 years. I understand using
Excel as a secondary file.

We've had nothing but problems since upgrading to 2003. The sql
feature, of word changing the formatting of how time and dates from
excel to the merged file. I type the data in one way, and Word
changes it.

I had a time field where I had a start - end time in one cell, and
Word decided to change the formatting...so I did a switch, which of
course, made the 2nd time not show up.

Is there a way to get out of this? More than half my company is
ready to go back to 2002. Mail merge is the life's blood of the
place.



  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

Back to Word for DOS 1.0 maybe; Back to 2002?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Graham Mayor" wrote in message
...
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help you
get back to methods with which you are familiar.

--

Graham Mayor - Word MVP

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




Lexisch wrote:
I've been doing mail merge for over 25 years. I understand using
Excel as a secondary file.

We've had nothing but problems since upgrading to 2003. The sql
feature, of word changing the formatting of how time and dates from
excel to the merged file. I type the data in one way, and Word
changes it.

I had a time field where I had a start - end time in one cell, and
Word decided to change the formatting...so I did a switch, which of
course, made the 2nd time not show up.

Is there a way to get out of this? More than half my company is
ready to go back to 2002. Mail merge is the life's blood of the
place.





  #5   Report Post  
Lexisch
 
Posts: n/a
Default

Doug

I did make the switch from 2k to 2003, but the new company that I went to
work for, half the people were using 2002, but I think it was more in
departments that used excel.

The confirm on opening seems to work for the majority of what we want with
the DDE.

The one thing that I'm noticing when I choose DDE, is that it won't ask me
which spreadsheet I want to use for the secondary file.

I'm glad to have guys like you available for answers.

Lexi

"Doug Robbins" wrote:

I am not aware of any differences between XP (2002) and 2003. There were
however major differences between 2000 and XP

You may be able to overcome your problems by selection Options from the
Tools menu and then on the General tab, checking the box against the
"Confirm conversions at open" item. When you do that, when you attach the
data source, you will be given a number of options for the method by which
the connection should be made. Try the DDE option.

Also see the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindy...r/MergFram.htm

and "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

though from the sound of it, you may be familiar with the latter topic.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Lexisch" wrote in message
...
I've been doing mail merge for over 25 years. I understand using Excel as
a
secondary file.

We've had nothing but problems since upgrading to 2003. The sql feature,
of
word changing the formatting of how time and dates from excel to the
merged
file. I type the data in one way, and Word changes it.

I had a time field where I had a start - end time in one cell, and Word
decided to change the formatting...so I did a switch, which of course,
made
the 2nd time not show up.

Is there a way to get out of this? More than half my company is ready to
go
back to 2002. Mail merge is the life's blood of the place.






  #6   Report Post  
Lexisch
 
Posts: n/a
Default

Graham

Thanks. The links you gave me, I think, will help to make the staff happier.

Lexi

"Graham Mayor" wrote:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help you
get back to methods with which you are familiar.

--

Graham Mayor - Word MVP

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




Lexisch wrote:
I've been doing mail merge for over 25 years. I understand using
Excel as a secondary file.

We've had nothing but problems since upgrading to 2003. The sql
feature, of word changing the formatting of how time and dates from
excel to the merged file. I type the data in one way, and Word
changes it.

I had a time field where I had a start - end time in one cell, and
Word decided to change the formatting...so I did a switch, which of
course, made the 2nd time not show up.

Is there a way to get out of this? More than half my company is
ready to go back to 2002. Mail merge is the life's blood of the
place.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 05:11 AM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 07:24 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 02:31 PM


All times are GMT +1. The time now is 11:12 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"