I have a problem with Mailmerge
54 views
Skip to first unread message
Imagine Philharmonic Orchestra
Aug 10, 2023, 4:52:31 AM8/10/23
to Google Apps Script Community
Dear GG,
I have done the instructions to do mailmerge but I always see the problem: "the starting row of the range is too small".
Please support me
cwl...@gmail.com
Aug 10, 2023, 8:05:27 AM8/10/23
to Google Apps Script Community
Can you show your code please? Without seeing it, chatGPT provides the following (the last sentence is ironic :) ):
==========================================
The error message "the starting row of the range is too small" in the context of a Google Apps Script mail merge script likely indicates an issue with the way the script is attempting to access a range of cells in a spreadsheet.
Here's what this error message typically means:
1. **Range Issue**: The error suggests that the script is trying to define a range of cells (possibly for data manipulation or retrieval) with a starting row index that is smaller than the acceptable range of row indices for the spreadsheet.
2. **Invalid Starting Row**: Each spreadsheet in Google Sheets has rows numbered from 1 upwards. If the script is attempting to start from a row index lower than 1 or from a row that doesn't exist in the spreadsheet, this error could be triggered.
3. **Script Logic**: The error might be occurring due to a logical error in the script itself. The script could be trying to calculate or determine a starting row in a way that results in a value less than 1.
To address this issue, you'll need to carefully review the part of your script that defines the range of cells or the starting row for your mail merge process. Double-check the logic you're using to calculate the starting row index and ensure that it always results in a valid row index (greater than or equal to 1 and within the available row range in your spreadsheet).
If you're having trouble identifying the specific part of your script that's causing the error, you might consider sharing a relevant portion of your script code so that I can assist you in pinpointing the issue more accurately.
==========================================
The error message "the starting row of the range is too small" in the context of a Google Apps Script mail merge script likely indicates an issue with the way the script is attempting to access a range of cells in a spreadsheet.
Here's what this error message typically means:
1. **Range Issue**: The error suggests that the script is trying to define a range of cells (possibly for data manipulation or retrieval) with a starting row index that is smaller than the acceptable range of row indices for the spreadsheet.
2. **Invalid Starting Row**: Each spreadsheet in Google Sheets has rows numbered from 1 upwards. If the script is attempting to start from a row index lower than 1 or from a row that doesn't exist in the spreadsheet, this error could be triggered.
3. **Script Logic**: The error might be occurring due to a logical error in the script itself. The script could be trying to calculate or determine a starting row in a way that results in a value less than 1.
To address this issue, you'll need to carefully review the part of your script that defines the range of cells or the starting row for your mail merge process. Double-check the logic you're using to calculate the starting row index and ensure that it always results in a valid row index (greater than or equal to 1 and within the available row range in your spreadsheet).
If you're having trouble identifying the specific part of your script that's causing the error, you might consider sharing a relevant portion of your script code so that I can assist you in pinpointing the issue more accurately.
cwl...@gmail.com
Aug 10, 2023, 8:11:54 AM8/10/23
to Google Apps Script Community
P.S., I just checked you out on Youtube, wonderful!! I'm now subscribed. :)
Imagine Philharmonic Orchestra
Aug 10, 2023, 8:14:12 AM8/10/23
to google-apps-sc...@googlegroups.com
Omg haha thank you. I found solutions for my problem.
--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/eLvTrOGH4BY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/63498039-d2ab-4280-9f35-58d40c055ec4n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages