Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-09-2020, 04:58 AM
Purfleet Purfleet is offline Save automatic Mail Merge with excel table as attachment Windows 10 Save automatic Mail Merge with excel table as attachment Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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.
Reply With Quote
 

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
Save automatic Mail Merge with excel table as attachment Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs Btop Word VBA 26 03-07-2018 01:45 PM
Save automatic Mail Merge with excel table as attachment 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
Save automatic Mail Merge with excel table as attachment email as pdf attachment - subject line and attachment named after mail merge Nexus Mail Merge 12 04-13-2011 11:34 PM

Other Forums: Access Forums

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


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