Mail Merge Using Excel Data

[HansV]

Please attach the document with the merge fields.

[hlewton]

Please attach the document with the merge fields.

Hans I only have the document that I created after giving up on that one and starting all over again. Will that work since it is now exactly what I wanted in the first place? I'll attach it just in case it can be of help.

Test Merge.docx

[HansV]

If this one does what you want, there is little point in investigating it. But thanks anyway for attaching it.

[hlewton]

If this one does what you want, there is little point in investigating it. But thanks anyway for attaching it.

Yes, I kind of knew that. I was just curious why I could not edit the one I messed up on instead of starting the merge over. I only create a new merge every 2 or 3 years or so and seem to forget the little I knew about them in the first place.

[hlewton]

Got another question and again I have to attach a screenshot to help explain what I am asking. When I start a mail merge I choose to use an Existing List as my source for Recipients. When I choose an Excel spreadsheet as the source, even though it only has 1 sheet in the spreadsheet, I am presented with a choice of 2 options. Please see the attachment. I chose the first option at the top of the list because it was highlighted, and when inserting the merge fields into the label document, the merge field named Title was not an option, it just was not there. So I then chose the second option, the one with the $ after it and the merge field Title was there. I don't understand why there were 2 options in the first place, but this has happened before so it's not new. Both have the same name as far as address1 but I have to use the address1$ to get all the fields I need in the merge. Why the 2 options?

By the way, the first option was highlighted when I choose the data source, I didn't pick it as it is seen in the attachment.

StartMerge.jpg

[HansV]

I have no idea, sorry. I hope that someone else can enlighten you.

[hlewton]

OK, thanks.

[macropod]

Perhaps you have a range named 'Address1' that doesn't include the title.

[hlewton]

Perhaps you have a range named 'Address1' that doesn't include the title.

No I don't have any range set up. However I was thinking, every one of these Excel spreadsheets, that this occurs in, was created by data that was exported from a table in Access. Does anyone think that may be the problem?