Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-25-2011, 07:08 AM
dkub dkub is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2011
Posts: 6
dkub is on a distinguished road
Default Mailmerge


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

Last edited by macropod; 07-26-2011 at 07:05 PM. Reason: Added a meaningful title
Reply With Quote
  #2  
Old 07-25-2011, 10:38 AM
dkub dkub is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2011
Posts: 6
dkub is on a distinguished road
Default Excel Source Datasheet used in MS Word e-Mail Merge

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.
Reply With Quote
  #3  
Old 07-29-2011, 07:34 AM
dkub dkub is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2011
Posts: 6
dkub is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 11-25-2011, 09:16 AM
wowow wowow is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
wowow is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 11-30-2011, 04:44 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,353
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by dkub View Post
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.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 11-30-2011, 05:53 AM
wowow wowow is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
wowow is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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,
Reply With Quote
  #7  
Old 11-30-2011, 02:12 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,353
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Did you try using commas (as suggested in my post), instead of semi-colons?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #8  
Old 11-30-2011, 06:58 PM
wowow wowow is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
wowow is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
  #9  
Old 11-30-2011, 08:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,353
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi wowow,

Is there a reason you can't send a separate mailmerge email to each recipient?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #10  
Old 11-30-2011, 09:30 PM
wowow wowow is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
wowow is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote
  #11  
Old 11-30-2011, 11:32 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,353
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #12  
Old 12-01-2011, 01:48 AM
wowow wowow is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
wowow is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote
  #13  
Old 12-01-2011, 01:53 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,353
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #14  
Old 12-01-2011, 07:22 AM
wowow wowow is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
wowow is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
  #15  
Old 12-01-2011, 01:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,353
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes



All times are GMT -7. The time now is 02:36 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft