A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word 2007 merge to email limitations?



 
 
Thread Tools Display Modes
  #1  
Old August 14th, 2008, 09:20 PM posted to microsoft.public.word.mailmerge.fields
GlenH
external usenet poster
 
Posts: 1
Default Word 2007 merge to email limitations?

We have a database of around 20,000 employees. Once a month we need to send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month, using
Office 2003, the merge to email took maybe two hours. This month, the merge
fails after 700 or 800 records with a "not enough memory" error from Word.
Looking at task manager, I see that winword.exe is taking up nearly 1.6 gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and should
we look for a mass email solution?

Glen
  #2  
Old August 15th, 2008, 09:53 AM posted to microsoft.public.word.mailmerge.fields
[email protected]
external usenet poster
 
Posts: 10
Default Word 2007 merge to email limitations?

Hi Glen:
I too am very interested in this response. Every mass mail programme
we have looked at involves uploading a file to a web based service,
and none have been easy to simplay replace an existing fdat source, so
you end up with many databases. Hope you get some answers
Cheers
Cathy

On Aug 15, 5:20*am, GlenH wrote:
We have a database of around 20,000 employees. Once a month we need to send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month, using
Office 2003, the merge to email took maybe two hours. This month, the merge
fails after 700 or 800 records with a "not enough memory" error from Word..
Looking at task manager, I see that winword.exe is taking up nearly 1.6 gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and should
we look for a mass email solution?

Glen


  #3  
Old August 21st, 2008, 11:21 PM posted to microsoft.public.word.mailmerge.fields
Ryan
external usenet poster
 
Posts: 551
Default Word 2007 merge to email limitations?

I've myself noticed this issue of longer than usual mail merges. Upon further
inspection, I've noticed that email sent through a mail merge in Word
2007/Outlook 2007 take up almost a megabyte per message, which is ridiculous.
Any suggestions on how to rectify this issue is appreciated.

" wrote:

Hi Glen:
I too am very interested in this response. Every mass mail programme
we have looked at involves uploading a file to a web based service,
and none have been easy to simplay replace an existing fdat source, so
you end up with many databases. Hope you get some answers
Cheers
Cathy

On Aug 15, 5:20 am, GlenH wrote:
We have a database of around 20,000 employees. Once a month we need to send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month, using
Office 2003, the merge to email took maybe two hours. This month, the merge
fails after 700 or 800 records with a "not enough memory" error from Word..
Looking at task manager, I see that winword.exe is taking up nearly 1.6 gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and should
we look for a mass email solution?

Glen



  #4  
Old August 22nd, 2008, 12:24 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Word 2007 merge to email limitations?

Are you merging to HTML format?

If so, the issue of Word hanging etc. has come up more than once and has
been reported. What will happen as a result I do not know. Your description
is slightly different (crash rather than hang), so may not be the same
problem - since you are an Enterprise user it may well have more effect if
you can report this directly to the appropriate Microsoft support channel in
your country/region. (Here, we're just volunteers)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"GlenH" wrote in message
...
We have a database of around 20,000 employees. Once a month we need to
send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month,
using
Office 2003, the merge to email took maybe two hours. This month, the
merge
fails after 700 or 800 records with a "not enough memory" error from Word.
Looking at task manager, I see that winword.exe is taking up nearly 1.6
gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe
help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and
should
we look for a mass email solution?

Glen


  #5  
Old August 26th, 2008, 08:29 PM posted to microsoft.public.word.mailmerge.fields
Aaron, CISSP
external usenet poster
 
Posts: 2
Default Word 2007 merge to email limitations?

I've experienced this problem at my organization as well. When running the
mail merge to email process, the workstation first consumes all physical
memory then consumes all of the page file before stopping.

Increasing the page file size actually produced worse results. We're going
to add more physical memory to the machine.

We've opened a case with Microsoft. Their initial suggestion was to verify
that the user had permissions to write to
C:\Users\username\AppData\Local\Microsoft\Windows\ Temporary Internet Files or
the parallel location on XP. Our users are not admins on their workstations,
so I'm going to test this hypothesis.

"Ryan" wrote:

I've myself noticed this issue of longer than usual mail merges. Upon further
inspection, I've noticed that email sent through a mail merge in Word
2007/Outlook 2007 take up almost a megabyte per message, which is ridiculous.
Any suggestions on how to rectify this issue is appreciated.

" wrote:

Hi Glen:
I too am very interested in this response. Every mass mail programme
we have looked at involves uploading a file to a web based service,
and none have been easy to simplay replace an existing fdat source, so
you end up with many databases. Hope you get some answers
Cheers
Cathy

On Aug 15, 5:20 am, GlenH wrote:
We have a database of around 20,000 employees. Once a month we need to send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month, using
Office 2003, the merge to email took maybe two hours. This month, the merge
fails after 700 or 800 records with a "not enough memory" error from Word..
Looking at task manager, I see that winword.exe is taking up nearly 1.6 gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and should
we look for a mass email solution?

Glen



  #6  
Old September 20th, 2008, 03:37 AM posted to microsoft.public.word.mailmerge.fields
Glen Harness
external usenet poster
 
Posts: 2
Default Word 2007 merge to email limitations?

I'm not high enough in the food chain at my organization to place the call
to MS support...

I'm wondering if instsalling Office 2007 Service Pack 1 would make a
difference? We've reverted to doing the email merge on a laptop with Office
2003 for now, but next week we have to do another 20000 mailing to folks
with a personalized flu shot consent form. We may have to look at some mass
email software...

Thanks.

Glen

"Peter Jamieson" wrote in message
...
Are you merging to HTML format?

If so, the issue of Word hanging etc. has come up more than once and has
been reported. What will happen as a result I do not know. Your
description is slightly different (crash rather than hang), so may not be
the same problem - since you are an Enterprise user it may well have more
effect if you can report this directly to the appropriate Microsoft
support channel in your country/region. (Here, we're just volunteers)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"GlenH" wrote in message
...
We have a database of around 20,000 employees. Once a month we need to
send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month,
using
Office 2003, the merge to email took maybe two hours. This month, the
merge
fails after 700 or 800 records with a "not enough memory" error from
Word.
Looking at task manager, I see that winword.exe is taking up nearly 1.6
gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is
there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe
help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and
should
we look for a mass email solution?

Glen




  #7  
Old September 20th, 2008, 10:24 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Word 2007 merge to email limitations?

There have been other suggestions about this issue of late, including...
a. the one in this conversation:


We've opened a case with Microsoft. Their initial suggestion was to verify
that the user had permissions to write to
C:\Users\username\AppData\Local\Microsoft\Windows\ Temporary Internet Files
or
the parallel location on XP. Our users are not admins on their
workstations,
so I'm going to test this hypothesis.


b. one in the docmanagement newsgroup:


As a work around I installed MAPILABS Mail Merge tool kit. ***I did not use
Mail Merge Tool kit, I just installed it! The merge ran as it should 486
email in 4 min. NO HANG!!!!!!

Would love to know what changes the tool kit makes to office 2K7????


Since I haven't been able to replicate the problem here, I have no way of
checking either of these suggestions.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Glen Harness" wrote in message
...
I'm not high enough in the food chain at my organization to place the call
to MS support...

I'm wondering if instsalling Office 2007 Service Pack 1 would make a
difference? We've reverted to doing the email merge on a laptop with
Office 2003 for now, but next week we have to do another 20000 mailing to
folks with a personalized flu shot consent form. We may have to look at
some mass email software...

Thanks.

Glen

"Peter Jamieson" wrote in message
...
Are you merging to HTML format?

If so, the issue of Word hanging etc. has come up more than once and has
been reported. What will happen as a result I do not know. Your
description is slightly different (crash rather than hang), so may not be
the same problem - since you are an Enterprise user it may well have more
effect if you can report this directly to the appropriate Microsoft
support channel in your country/region. (Here, we're just volunteers)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"GlenH" wrote in message
...
We have a database of around 20,000 employees. Once a month we need to
send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month,
using
Office 2003, the merge to email took maybe two hours. This month, the
merge
fails after 700 or 800 records with a "not enough memory" error from
Word.
Looking at task manager, I see that winword.exe is taking up nearly 1.6
gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is
there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe
help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and
should
we look for a mass email solution?

Glen





  #8  
Old September 21st, 2008, 04:35 AM posted to microsoft.public.word.mailmerge.fields
Glen Harness
external usenet poster
 
Posts: 2
Default Word 2007 merge to email limitations?

Thanks. I'm pretty sure the user is an admin on his workstation, but I'll
double check. That mail merge tool kit might be worth trying anyway, so I'll
check that out as well.

Glen

"Peter Jamieson" wrote in message
...
There have been other suggestions about this issue of late, including...
a. the one in this conversation:


We've opened a case with Microsoft. Their initial suggestion was to
verify
that the user had permissions to write to
C:\Users\username\AppData\Local\Microsoft\Windows\ Temporary Internet Files
or
the parallel location on XP. Our users are not admins on their
workstations,
so I'm going to test this hypothesis.


b. one in the docmanagement newsgroup:


As a work around I installed MAPILABS Mail Merge tool kit. ***I did not
use
Mail Merge Tool kit, I just installed it! The merge ran as it should 486
email in 4 min. NO HANG!!!!!!

Would love to know what changes the tool kit makes to office 2K7????


Since I haven't been able to replicate the problem here, I have no way of
checking either of these suggestions.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Glen Harness" wrote in message
...
I'm not high enough in the food chain at my organization to place the
call to MS support...

I'm wondering if instsalling Office 2007 Service Pack 1 would make a
difference? We've reverted to doing the email merge on a laptop with
Office 2003 for now, but next week we have to do another 20000 mailing to
folks with a personalized flu shot consent form. We may have to look at
some mass email software...

Thanks.

Glen

"Peter Jamieson" wrote in message
...
Are you merging to HTML format?

If so, the issue of Word hanging etc. has come up more than once and has
been reported. What will happen as a result I do not know. Your
description is slightly different (crash rather than hang), so may not
be the same problem - since you are an Enterprise user it may well have
more effect if you can report this directly to the appropriate Microsoft
support channel in your country/region. (Here, we're just volunteers)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"GlenH" wrote in message
...
We have a database of around 20,000 employees. Once a month we need to
send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month,
using
Office 2003, the merge to email took maybe two hours. This month, the
merge
fails after 700 or 800 records with a "not enough memory" error from
Word.
Looking at task manager, I see that winword.exe is taking up nearly 1.6
gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is
there
some kind of memory leak going on here? Whatever the case, we can't
keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe
help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and
should
we look for a mass email solution?

Glen






  #9  
Old September 22nd, 2008, 02:02 PM posted to microsoft.public.word.mailmerge.fields
Aaron Munoz
external usenet poster
 
Posts: 1
Default Word 2007 merge to email limitations?

I spoke with a PSS engineer regarding my case last week and he indicated
Microsoft is working on a hotfix to correct this issue. He estimated a
release date sometime in October.

He indicated that this issue has been reported several times, so I imagine
there's a fairly large demand for a solution.
--
Aaron Munoz, CISSP


"Aaron, CISSP" wrote:

I've experienced this problem at my organization as well. When running the
mail merge to email process, the workstation first consumes all physical
memory then consumes all of the page file before stopping.

Increasing the page file size actually produced worse results. We're going
to add more physical memory to the machine.

We've opened a case with Microsoft. Their initial suggestion was to verify
that the user had permissions to write to
C:\Users\username\AppData\Local\Microsoft\Windows\ Temporary Internet Files or
the parallel location on XP. Our users are not admins on their workstations,
so I'm going to test this hypothesis.

"Ryan" wrote:

I've myself noticed this issue of longer than usual mail merges. Upon further
inspection, I've noticed that email sent through a mail merge in Word
2007/Outlook 2007 take up almost a megabyte per message, which is ridiculous.
Any suggestions on how to rectify this issue is appreciated.

" wrote:

Hi Glen:
I too am very interested in this response. Every mass mail programme
we have looked at involves uploading a file to a web based service,
and none have been easy to simplay replace an existing fdat source, so
you end up with many databases. Hope you get some answers
Cheers
Cathy

On Aug 15, 5:20 am, GlenH wrote:
We have a database of around 20,000 employees. Once a month we need to send
each employee an email with the status of an incentive program they're
eligible for. We just upgraded to Office 2007 Enterprise. Last month, using
Office 2003, the merge to email took maybe two hours. This month, the merge
fails after 700 or 800 records with a "not enough memory" error from Word..
Looking at task manager, I see that winword.exe is taking up nearly 1.6 gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or is there
some kind of memory leak going on here? Whatever the case, we can't keep
breaking up the merge (which is an Excel spreadsheet) into 700 record
batches. Service Pack 1 is not installed. Would installing that maybe help?

Or is a 20,000 row merge to email just too much for Word/Outlook, and should
we look for a mass email solution?

Glen


  #10  
Old September 22nd, 2008, 02:19 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Word 2007 merge to email limitations?

Good to hear - thanks very much for the update.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Aaron Munoz" wrote in message
...
I spoke with a PSS engineer regarding my case last week and he indicated
Microsoft is working on a hotfix to correct this issue. He estimated a
release date sometime in October.

He indicated that this issue has been reported several times, so I imagine
there's a fairly large demand for a solution.
--
Aaron Munoz, CISSP


"Aaron, CISSP" wrote:

I've experienced this problem at my organization as well. When running
the
mail merge to email process, the workstation first consumes all physical
memory then consumes all of the page file before stopping.

Increasing the page file size actually produced worse results. We're
going
to add more physical memory to the machine.

We've opened a case with Microsoft. Their initial suggestion was to
verify
that the user had permissions to write to
C:\Users\username\AppData\Local\Microsoft\Windows\ Temporary Internet
Files or
the parallel location on XP. Our users are not admins on their
workstations,
so I'm going to test this hypothesis.

"Ryan" wrote:

I've myself noticed this issue of longer than usual mail merges. Upon
further
inspection, I've noticed that email sent through a mail merge in Word
2007/Outlook 2007 take up almost a megabyte per message, which is
ridiculous.
Any suggestions on how to rectify this issue is appreciated.

" wrote:

Hi Glen:
I too am very interested in this response. Every mass mail programme
we have looked at involves uploading a file to a web based service,
and none have been easy to simplay replace an existing fdat source,
so
you end up with many databases. Hope you get some answers
Cheers
Cathy

On Aug 15, 5:20 am, GlenH wrote:
We have a database of around 20,000 employees. Once a month we need
to send
each employee an email with the status of an incentive program
they're
eligible for. We just upgraded to Office 2007 Enterprise. Last
month, using
Office 2003, the merge to email took maybe two hours. This month,
the merge
fails after 700 or 800 records with a "not enough memory" error
from Word..
Looking at task manager, I see that winword.exe is taking up nearly
1.6 gig
of the 2.0 gig of ram. Is this just a limitation of Word 2007, or
is there
some kind of memory leak going on here? Whatever the case, we can't
keep
breaking up the merge (which is an Excel spreadsheet) into 700
record
batches. Service Pack 1 is not installed. Would installing that
maybe help?

Or is a 20,000 row merge to email just too much for Word/Outlook,
and should
we look for a mass email solution?

Glen



 




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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.