Mailmerge to Email with a mailmerge attachment

macropod · #1 02-05-2013, 08:25 PM

I'd suggest checking the validity of what's in your sName & docName variables. You may have content that is not valid for a filename. I doubt the added page is an issue.

Baldeagle · #2 02-06-2013, 05:58 AM

Thanks for your comments. I have had another look at what is happening in relation to the certificate that I am trying to split. Attached is an abridged version of the file that is created after merging the data (I have eliminated most personal information and have just included 2 records) - this is called 'CHY2 Merged.doc'. After I run the Macro 'SplitMergeForm' I get the error message 'Run time error '4198''. But the result is a document which I have called 'CHY2 - Result of Macro.doc' which has just the first page of the first certificate. When I look at 'CHY2 Cert Merged.doc' it now has the first page of the first certificate missing! I have attached this file and have called it 'CHY2 Merged (After Macro).doc'

Does this make any sense to you?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailmerge to email as attachments	j_Southern	Mail Merge	12	03-03-2021 07:57 AM
Mailmerge to email	awstyle	Mail Merge	1	05-31-2012 08:13 AM
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	13	05-29-2012 02:04 PM
Email from MailMerge	Baldeagle	Mail Merge	4	04-06-2012 05:46 AM
How do you add text to email mailmerge?	DerekScambler	Mail Merge	10	04-19-2011 05:30 AM