Insert Look up column from calendar data for Mail Merge

Copper Contributor

Hello Everyone,

 

Thank you for any an all help. I'm not sure if this is possible, but I figured I'd ask.

 

I have an event calendar in Classic SharePoint and I need to put some information from the entries (rows) into another list, called "Mail Merge", using the Look Up column. The Mail merge list data will go into a mail merge in Word. The Events are organized by "City" Atlanta, Boston...etc. I am not using the Title, column though. I don't know if that's a problem.

 

Event List the following columns that I need.

Name

Start Date

End Date

 

However, when I try to make a look up column in Mail Merge and pull this information. The only options available are Start Date and End Date that are relevant. It's missing most of the other columns (Email, contact info, City...etc.) Is it not possible to create a look-up column from an Event Calendar in Classic SharePoint? If not, is there a way to merge the data directly into Word from the Calendar list?

 

Thank you

0 Replies