Mail Merging

toughiv · #33 10-13-2014, 04:21 AM

Hi Marco,

Long time!

I was hoping for your wizardry/ sagely advice once more...

I am now trying to use the catalog mail merge > merging the tables> Then sending the tables to multiple recipients...i.e. To & CC.

I have done a little looking around and this is what I have found so far:

Code:

With oItem 
    .Subject = mysubject 
    .body = ActiveDocument.Content 
    Set Datarange = Maillist.Tables(1).Cell(Counter, 1).Range 
    Datarange.End = Datarange.End - 1 
    .To = Datarange 
    For i = 2 To Maillist.Tables(1).Columns.Count 
        Set Datarange = Maillist.Tables(1).Cell(Counter, i).Range 
        Datarange.End = Datarange.End - 1 
        .Attachments.Add Trim(Datarange.Text), olByValue, 1 
    Next i 
    .CC = "Firstemailaddress; secondemailaddress" 
    .BCC = "Firstemailaddress; secondemailaddress" 
    .Send 
End With

Is it possible to insert this in your RunMerge Macro - so that I can have multiple coloumns in my excel spreadsheet, relating to email addresses, so that I can include a line manager etc to the email that is sent?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mail merge in excel to send pdf forms	heyullama	Excel	7	12-01-2013 03:32 PM
Mail Merge Many URLs in one email by common email address	instantaphex	Mail Merge	3	04-29-2013 05:46 PM
Mail Merge to email, changing images on email layout	ginelli	Mail Merge	18	02-23-2013 09:47 AM
Mail Merge with Booklets is Merging all documents into One stapled Booklet	15Degrees	Mail Merge	1	01-31-2013 02:06 AM
Send e-mail message in Finish & Merge	CDTom	Mail Merge	1	08-24-2012 12:52 AM