Mailmerge

dkub · #1 07-25-2011, 07:08 AM

Within word - using excel as a data source and selecting e-mail merge... is it not possible to "send to" multiple recipients address found on the datasheet????

dkub · #2 07-25-2011, 10:38 AM

Hoping I would have had some comment on my post - if it was possible to have two recipients selected from the source datasheet for the e-mail merge - or add a CC line to the outgoing e-mail. Just need a little guidance.

dkub · #3 07-29-2011, 07:34 AM

Thank You - I am now tring VBA code but - MS OutLook 2003 keeps asking me to grant permission when I send my VBA generated e-mail out of Excel. How I turn that OFF then back ON after my Macro has run?

wowow · #4 11-25-2011, 09:16 AM

Hi dkub

Do you complete your project and could you share the final result with me?

I am facing the same issue: I want to send one specific merged mail to more than two recipients or add CC to mail merge, but word does not allow to do so.

Look forwrad to hearing from you soon.

Tks

macropod · #5 11-30-2011, 04:44 AM

Quote:

Originally Posted by dkub

Hoping I would have had some comment on my post - if it was possible to have two recipients selected from the source datasheet for the e-mail merge - or add a CC line to the outgoing e-mail. Just need a little guidance.

Hi dkub,

Are the recipient email addresses all listed in the same field in the Excel data source? If not, concatenating the various fields in Excel, with comma-space separators would seem to be the simplest way of sending the same data to multiple recipients. You can probably do this with a formula.

wowow · #6 11-30-2011, 05:53 AM

Quote:

Originally Posted by macropod

Hi dkub,

Are the recipient email addresses all listed in the same field in the Excel data source? If not, concatenating the various fields in Excel, with comma-space separators would seem to be the simplest way of sending the same data to multiple recipients. You can probably do this with a formula.

Hi macropod,

I did as you guided. I put emails separated by semicolon ( ; ) in one column, like john@gmail.com; nathalie@yahoo.com. But Outlook did not recognize and regard it as error.

I am using Win 7, Word 2007 and Outlook 2007 too.

Do you have any idea?

Thanks,

macropod · #7 11-30-2011, 02:12 PM

Did you try using commas (as suggested in my post), instead of semi-colons?

wowow · #8 11-30-2011, 06:58 PM

Quote:

Originally Posted by macropod

Did you try using commas (as suggested in my post), instead of semi-colons?

Yes I did. I tried using both commas and semi-colons, but Outlook noticed the same message saying that it does not recognize the email address.

Do you have any other way?

Thanks.

macropod · #9 11-30-2011, 08:58 PM

Hi wowow,

Is there a reason you can't send a separate mailmerge email to each recipient?

wowow · #10 11-30-2011, 09:30 PM

Quote:

Originally Posted by macropod

Hi wowow,

Is there a reason you can't send a separate mailmerge email to each recipient?

What I am facing now is I have a list of companies that I will send specific offers of our services to company by company. That means each company will receive one offer that contains the services are relevant to its needs. However, each company have 2 - 3 recipients, let's say contact person, his/her managers or boss. I am trying to use Mail Merge in Word to send those offers, but I want to make Mail Merge to send one offer to 2 - 3 recipients: contact person, his/her managers or boss.

Could you please help me doing so?

Thanks

macropod · #11 11-30-2011, 11:32 PM

Hi wowow,

If you create distribution lists in Outlook, you can use them for the mailmerge.

If that's not practicable, it seems you'll need vba to do this, as Outlook etc don't accept multiple email address input via mailmerge. See: http://www.wordbanter.com/showthread.php?t=58331

wowow · #12 12-01-2011, 01:48 AM

Quote:

Originally Posted by macropod

Hi wowow,

If you create distribution lists in Outlook, you can use them for the mailmerge.

If that's not practicable, it seems you'll need vba to do this, as Outlook etc don't accept multiple email address input via mailmerge. See: http://www.wordbanter.com/showthread.php?t=58331

Thank Macropod.

I searched on the web and I know there is a VBA code to send mail merge with attachments, but I don't know VBA so I could not revise that code to send mail merge include CC and BCC.

Could you help me to do that?

Thanks

macropod · #13 12-01-2011, 01:53 AM

Hi wowow,

The link I posted has all you need - a link to the basic macro, plus the code (and instructions) to modify it for adding the CC stuff.

wowow · #14 12-01-2011, 07:22 AM

Quote:

Originally Posted by macropod

Hi wowow,

The link I posted has all you need - a link to the basic macro, plus the code (and instructions) to modify it for adding the CC stuff.

Thank macropod.

I just repalce a part of the code of mail merge with attachment by the code that uses to allows CC and BCC in mail merge as the follows:

I replaced

Code:

    With oItem
        .Subject = mysubject
        .Body = Source.Sections(j).Range.Text
        Set Datarange = Maillist.Tables(1).Cell(j, 1).Range
        Datarange.End = Datarange.End - 1
        .To = Datarange
        For i = 2 To Maillist.Tables(1).Columns.Count
            Set Datarange = Maillist.Tables(1).Cell(j, i).Range
            Datarange.End = Datarange.End - 1
            .Attachments.Add Trim(Datarange.Text), olByValue, 1
        Next i
        .Send
    End With

by

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 right?

Now I wonder how to use with the new code. Should I use VBA editor to embed the code in the letter that is to generate and send multiple mails or I make a separate marcro to run when I open the letter to merge emails?

Thanks.

macropod · #15 12-01-2011, 01:46 PM

Hi wowow,

You need to follow the instruction at the bottom of the page at: http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

See also: http://www.gmayor.com/installing_macro.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode