How do you add text to email mailmerge?

macropod · #6 04-15-2011, 06:31 AM

Quote:

Originally Posted by DerekScambler

Thanks for getting back to me again. I've had a look at the link and as I've never used macros before, it all looks a bit complicated to me.

It is till you get used to it.

Quote:

I'm not sure if that is going to do the job for me either.

We would be sending out 4-500 personalised invoices and it looks like I would need to have each invoice saved seperately so that I could attach it to the email. I see that it would pull the email address' from the data file but I presume I would then need to list all of the saved invoices in the data file next to the corresponding email address so that it could pull the info for the attachment from there?

I think that's correct, but there are other macros about the web for splitting mailmerge documents into individual files, so that part can be done quite speedily too. See, for example:
http://www.gmayor.com/individual_merge_letters.htm

With a little bit of extra coding, you could have one process execute and, when it's complete, automatically start the next one. That part would require only four lines of code.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting a Hyperlink and Rich Text in Groupwise Email	cksm4	Word VBA	0	03-07-2011 06:33 PM
Objective: Automatically export email text,attachment text to DB friendly format	SilentLee	Outlook	0	11-14-2010 02:45 PM
Plain Text Email Reply in HTML format	shamiar	Outlook	1	07-29-2010 07:49 AM
Email to text file	MervNorton	Outlook	0	03-15-2010 11:01 AM
Email (as Attachment) replaced by Mail Recipient (as Text)	dcman7	Mail Merge	0	08-18-2009 08:08 AM