Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-09-2020, 05:07 AM
WaterIT WaterIT is offline Save automatic Mail Merge with excel table as attachment Windows 10 Save automatic Mail Merge with excel table as attachment Office 2019
Novice
Save automatic Mail Merge with excel table as attachment
 
Join Date: Nov 2020
Posts: 2
WaterIT is on a distinguished road
Default

At first, thanks for the suggestion. I solved the Problem, which im working on 2 days now.
I removed the error handler and saw, that the Cells-Method wasn't able to be executed. I had to add the activesheet-object, so it can adress the right sheet, because the code opens a workbook and closees it in each round.

Thank you very much, because in other forums nobody even responsed.
Reply With Quote
 

Tags
attach table, mail merge code, vba

Thread Tools
Display Modes


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:47 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