VBA code to CC multiple people in mail merge by word

		Microsoft Office Forums > Microsoft Word > Mail Merge
VBA code to CC multiple people in mail merge by word

FAQ

Thread Tools

Display Modes

04-27-2020, 02:16 PM

macropod

Windows 7 64bit VBA code to CC multiple people in mail merge by word

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

To omit attachments, you could simply delete:

Code:

    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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Mail Merge Envelope Addresses with Multiple Conditions	Pedro007	Mail Merge	2	11-19-2019 07:25 AM
Mail Merge Student Transcript - Multiple Years from multiple sheets	aizah2018	Mail Merge	1	11-11-2018 01:27 AM
Mail Merge Code Issue	Andrewwill	Mail Merge	6	01-06-2018 10:25 PM
Mail Merge to multiple employees in multiple locations as PDF by location	GFiz	Mail Merge	1	05-13-2017 08:01 PM
Mail Merge Multiple Rows -word(from Spain)	luisaranda	Mail Merge	6	03-06-2016 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 PM.