![]() |
|
#2
|
|||
|
|||
|
Without being able to see what the variables are set as i would think that your starting point would be to set a stop at this row and hover your mouse over the variables to see what they are at this point - irow, icolumn & extab
"exTab.Range(Cells(1, 1), Cells(iRow, iColumn)).Select" Its possible that there is nothing in the used range when assigning the variable here or the workbook references isnt open iRow = exTab.Worksheets(1).UsedRange.SpecialCells(xlCellT ypeLastCell).Row iColumn = exTab.Worksheets(1).UsedRange.SpecialCells(xlCellT ypeLastCell).Column If you know to do it you can set watches on these variables as well as the stop which makes it easier to debug. |
| Tags |
| attach table, mail merge code, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mail Merge Attachment and Standard body of the mail | abdulads@yahoo.com | Mail Merge | 1 | 05-17-2018 07:47 PM |
Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs
|
Btop | Word VBA | 26 | 03-07-2018 01:45 PM |
How To Do Mail Merge and add an attachment eg PDF
|
JohnyBoy | Mail Merge | 2 | 08-25-2015 08:53 PM |
| Mail merge with attachment | vijanand1279 | Word | 3 | 11-22-2011 12:52 PM |
email as pdf attachment - subject line and attachment named after mail merge
|
Nexus | Mail Merge | 12 | 04-13-2011 11:34 PM |