Mail Merge Using Excel Data
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- PlatinumLounger
- Posts: 3811
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
Re: Mail Merge Using Excel Data
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.
You do not have the required permissions to view the files attached to this post.
Regards,
hlewton
hlewton
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Mail Merge Using Excel Data
If this one does what you want, there is little point in investigating it. But thanks anyway for attaching it.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 3811
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
Re: Mail Merge Using Excel Data
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.
Regards,
hlewton
hlewton
-
- PlatinumLounger
- Posts: 3811
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
Re: Mail Merge Using Excel Data
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.
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.
You do not have the required permissions to view the files attached to this post.
Regards,
hlewton
hlewton
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Mail Merge Using Excel Data
I have no idea, sorry. I hope that someone else can enlighten you.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 3811
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Mail Merge Using Excel Data
Perhaps you have a range named 'Address1' that doesn't include the title.
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- PlatinumLounger
- Posts: 3811
- Joined: 24 Oct 2010, 23:39
- Location: Canton, Ohio USA
Re: Mail Merge Using Excel Data
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?
Regards,
hlewton
hlewton