Field in Subject Line Mail Merge Using Word 2010

[rexhvn]

Hi All,

I am hoping for some assistance please. I am wanting to add a data source from my excel spreadsheet into my subject line however I do not have the add on tool for Mail Merge.

Is there any other way I can do it such as VBA code? If so, help would be greatly appreciated.

Thanks,

 

[Macropod]

You need to do the basic mailmerge set-up before the macro can be used. See: https://support.office.com/en-us/ar...messages-0f123521-20ce-4aa8-8b62-ac211dedefa4.

As for the CC, mailmerges can't do those; you'd need an entirely different approach. See, for example, the 'Answer' post at: https://answers.microsoft.com/en-us...-copy-cc/8fa2684e-7a39-4bc9-a696-28d0d053ec10

 

[wordeo]

I'm trying to customize my subject line based on a cell in my excel document. For example is there is a "Yes" in cell k2, I'd like the subject line to say "hello"

else if the cell J2 says yes then subject line should be "Bye"

I'd also like the cells compared to be the corresponding cells of each row

any suggestion?
I basically still using the code from earlier

 

[Macropod]

You can only have one field (column) in Excel for the Subject line. Each row in that column can be different. I have no idea what you mean by:

I'd also like the cells compared to be the corresponding cells of each row

 

[arehman626]

This perfectly worked where I had a worksheet with the data along with a column with the heading as "Email" as well as another column called "Subject" and I had a concatenate formula in the "Subject" like +CONCATENATE("Re: Your order ",A2, " Placed on ",B2). Then I used the MS Word menu item "MAILINGS" - > "Select Recipients" -> "Use an existing List" then select the Excel document containing the above information and using "Insert Merge Field" from (Write and Insert menu bar) to further customise the message body. I then opened the DEVELOPER tab and went to Macros and clicked on Create and under the Normal project, under Modules, under NewMacros, I selected and removed everything and pasted the below code
Sub Merge_To_Emails()
Application.ScreenUpdating = False
Dim i As Long
With ActiveDocument
For i = 1 To .MailMerge.DataSource.RecordCount
With .MailMerge
.Destination = wdSendToEmail
.SuppressBlankLines = True
With .DataSource
.FirstRecord = i
.LastRecord = i
.ActiveRecord = i
End With
.MailAddressFieldName = "Email"
.MailSubject = .DataSource.DataFields("Subject")
.MailFormat = wdMailFormatHTML
.Execute Pause:=False
End With
Next i
End With
Application.ScreenUpdating = True
End Sub




then to run the macro, I had to go to DEVELOPER and select Macros and select the Merge_To_Emails from the drop down list and off you go.

 

[Macropod]

This perfectly worked where I had a worksheet with the data along with ... I then opened the DEVELOPER tab and went to Macros and clicked on Create and under the Normal project, under Modules, under NewMacros, I selected and removed everything and pasted the below code

As was previously advised - and which you seem to have disregarded, a mailmerge cannot do CCs.

PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.

 

[sur]

Can we add the CC filed in the above macro

 

[Macropod]

No, because all that macro does is automate a mailmerge. And, as I already said:

a mailmerge cannot do CCs.