Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2023, 04:21 AM
Vinhas Vinhas is offline Mail Merge - Error "array index is out of bounds" Windows 10 Mail Merge - Error "array index is out of bounds" Office 2019
Novice
Mail Merge - Error "array index is out of bounds"
 
Join Date: Nov 2022
Posts: 2
Vinhas is on a distinguished road
Default Mail Merge - Error "array index is out of bounds"

I have a excel sheet with so many colluns.



When I try do MailMerge in a word file with 3 or 4 fields that read the values in excel sheet appears the error "Run Time Error 440" - "array index is out of bounds".

Can anyone help me to understand whats wrong.

Many thanks
Reply With Quote
  #2  
Old 04-12-2023, 05:57 PM
Guessed's Avatar
Guessed Guessed is offline Mail Merge - Error "array index is out of bounds" Windows 10 Mail Merge - Error "array index is out of bounds" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I note this question was also posted to another forum Mail Merge - Error "array index is out of bounds"
You should refer to this thread on that forum so people trying to help you don't waste their time trying to solve a problem already solved elsewhere.

I would assume that your data source is either too large or data within your file exceeds a limit in some way. To work out where the error might be occurring, make a copy of your workbook and delete all the columns and rows that are not useful to the mailmerge and try that as your data source. Does this merge successfully or does the problem persist?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I am getting the "Either there is no default mail client" error when I try to send an email on Excel Wildsniper911 Outlook 0 02-22-2023 03:43 AM
Cannot change axis bounds (bounds reset to "auto" when I try to change them) dvirant Excel 0 02-23-2021 06:50 AM
Catalog Merge in Publisher error: "This data source contains no visible tables" highroadnm Publisher 0 01-20-2018 02:35 PM
Mail Merge - Error "array index is out of bounds" Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Alfred Mail Merge 2 05-23-2017 10:59 PM
Mail Merge - Error "array index is out of bounds" Error Outlook 2003 " Receive much mail the same at the same time" nhat2nhat2 Outlook 1 09-26-2011 11:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft