Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[NEW FEAT] Skip merge process for lines with empty recipient #391

Open
ttsukagoshi opened this issue Mar 26, 2024 · 0 comments
Open

[NEW FEAT] Skip merge process for lines with empty recipient #391

ttsukagoshi opened this issue Mar 26, 2024 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@ttsukagoshi
Copy link
Owner

Is your feature request related to a problem? Please describe.

There are cases when the user would like to use a spreadsheet with empty lines, with just the line number entered. When the Gmail draft is created for an empty line, Apps Script returns an error message:

Exception: 無効なメール: NA
     at mailMerge (group-merge:1135:28)
     at createDraftEmails (group-merge:877:5)
     at __GS_INTERNAL_top_function_call__.gs:1:8

Describe the solution you'd like

Add process to skip lines with an empty recipient cell.

Describe alternatives you've considered

The Spreadsheet.getDataRange() gets the range of cells with data, equivalent to the Ctrl + A shortcut key, so this should not be a problem unless the user has extra rows with limited field(s) filled in, e.g. row number, or if there are empty rows in the middle of the table.
The current workaround would be to edit the spreadsheet so that no empty lines exist in the spreadsheet.

Additional context

NA

@ttsukagoshi ttsukagoshi added the enhancement New feature or request label Mar 26, 2024
@ttsukagoshi ttsukagoshi self-assigned this Mar 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant