| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access vs Excel database
I sent a formated letter using mail merge to 25 people. All 25 people
received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
Your description of the way in which you did this does not seem to follow
the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
yes, I inserted "email" in the main word document, and the email address for
each of the 25 persons were on the excel spreadsheet. The mail merge email button did ask for email addresses in which i had to state in the box, the email address, the subject and then the format. I chose as an attachment. I have done this same process using access as my database and never did each recipient receive all letters. Is the process of doing mail merge using excel as a database different than using an access database. When I printed the letters, all were unique to the individaul. I had no way to know the email would have a "tail" of 25 letters each, or could I? Thanks for such a speedy response! -- Thank you! "Doug Robbins - Word MVP" wrote: Your description of the way in which you did this does not seem to follow the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
I cannot replicate that behaviour using Excel as a data source - I had to
try it just to prove to myself because I certainly did not believe that using Excel rather than Access would be the reason for that happening. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... yes, I inserted "email" in the main word document, and the email address for each of the 25 persons were on the excel spreadsheet. The mail merge email button did ask for email addresses in which i had to state in the box, the email address, the subject and then the format. I chose as an attachment. I have done this same process using access as my database and never did each recipient receive all letters. Is the process of doing mail merge using excel as a database different than using an access database. When I printed the letters, all were unique to the individaul. I had no way to know the email would have a "tail" of 25 letters each, or could I? Thanks for such a speedy response! -- Thank you! "Doug Robbins - Word MVP" wrote: Your description of the way in which you did this does not seem to follow the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
Whether using Excel or Access as a database should not be a problem. The
reason being they are single vendor product. View the merged document first and try sending to one or two friends. This should solve your problem. Challa Prabhu "Doug Robbins - Word MVP" wrote: I cannot replicate that behaviour using Excel as a data source - I had to try it just to prove to myself because I certainly did not believe that using Excel rather than Access would be the reason for that happening. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... yes, I inserted "email" in the main word document, and the email address for each of the 25 persons were on the excel spreadsheet. The mail merge email button did ask for email addresses in which i had to state in the box, the email address, the subject and then the format. I chose as an attachment. I have done this same process using access as my database and never did each recipient receive all letters. Is the process of doing mail merge using excel as a database different than using an access database. When I printed the letters, all were unique to the individaul. I had no way to know the email would have a "tail" of 25 letters each, or could I? Thanks for such a speedy response! -- Thank you! "Doug Robbins - Word MVP" wrote: Your description of the way in which you did this does not seem to follow the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
I appreciate your willingness to help, but I was not the one with the
problem. That notwithstanding, I don't think that what you are suggesting will make any difference in this case. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "challa prabhu" wrote in message ... Whether using Excel or Access as a database should not be a problem. The reason being they are single vendor product. View the merged document first and try sending to one or two friends. This should solve your problem. Challa Prabhu "Doug Robbins - Word MVP" wrote: I cannot replicate that behaviour using Excel as a data source - I had to try it just to prove to myself because I certainly did not believe that using Excel rather than Access would be the reason for that happening. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... yes, I inserted "email" in the main word document, and the email address for each of the 25 persons were on the excel spreadsheet. The mail merge button did ask for email addresses in which i had to state in the box, the email address, the subject and then the format. I chose as an attachment. I have done this same process using access as my database and never did each recipient receive all letters. Is the process of doing mail merge using excel as a database different than using an access database. When I printed the letters, all were unique to the individaul. I had no way to know the would have a "tail" of 25 letters each, or could I? Thanks for such a speedy response! -- Thank you! "Doug Robbins - Word MVP" wrote: Your description of the way in which you did this does not seem to follow the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
UPDATE: An excel user in my office suggested I needed to close the main
document after I printed the letters and then go into email merge button. Instead I went directly to the "email" merge button and sent to all email address in the database fields. From memory, when using my more familiar and usual process from information in an access database, I dont remember having to close my document after printing, but do just as i did and go right to the option of send "send via email". She did her own test and claimed she duplicated my "error". I've not had the chance to try it, but thought I would let you know. Thanks again! -- Thank you! "Doug Robbins - Word MVP" wrote: I appreciate your willingness to help, but I was not the one with the problem. That notwithstanding, I don't think that what you are suggesting will make any difference in this case. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "challa prabhu" wrote in message ... Whether using Excel or Access as a database should not be a problem. The reason being they are single vendor product. View the merged document first and try sending to one or two friends. This should solve your problem. Challa Prabhu "Doug Robbins - Word MVP" wrote: I cannot replicate that behaviour using Excel as a data source - I had to try it just to prove to myself because I certainly did not believe that using Excel rather than Access would be the reason for that happening. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... yes, I inserted "email" in the main word document, and the email address for each of the 25 persons were on the excel spreadsheet. The mail merge button did ask for email addresses in which i had to state in the box, the email address, the subject and then the format. I chose as an attachment. I have done this same process using access as my database and never did each recipient receive all letters. Is the process of doing mail merge using excel as a database different than using an access database. When I printed the letters, all were unique to the individaul. I had no way to know the would have a "tail" of 25 letters each, or could I? Thanks for such a speedy response! -- Thank you! "Doug Robbins - Word MVP" wrote: Your description of the way in which you did this does not seem to follow the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
|
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Access vs Excel database
Once you close the main document, you can not execute the merge to email (or
the any other destination for that matter). What your co-worker may have done was then attach the data source to the document created by executing the original merge to a new document and then executed a merge to email in which case, I would expect to get the result that you mention - sending all 25 letters to each recipient. As mentioned, I cannot replicate your problem and it is very hard without being there to give any other advice other that to copy the Excel data and paste it into Access (where it will become an Access table) and then use the method that you are familiar with. That should not be necessary however. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... UPDATE: An excel user in my office suggested I needed to close the main document after I printed the letters and then go into email merge button. Instead I went directly to the "email" merge button and sent to all email address in the database fields. From memory, when using my more familiar and usual process from information in an access database, I dont remember having to close my document after printing, but do just as i did and go right to the option of send "send via email". She did her own test and claimed she duplicated my "error". I've not had the chance to try it, but thought I would let you know. Thanks again! -- Thank you! "Doug Robbins - Word MVP" wrote: I appreciate your willingness to help, but I was not the one with the problem. That notwithstanding, I don't think that what you are suggesting will make any difference in this case. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "challa prabhu" wrote in message ... Whether using Excel or Access as a database should not be a problem. The reason being they are single vendor product. View the merged document first and try sending to one or two friends. This should solve your problem. Challa Prabhu "Doug Robbins - Word MVP" wrote: I cannot replicate that behaviour using Excel as a data source - I had to try it just to prove to myself because I certainly did not believe that using Excel rather than Access would be the reason for that happening. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... yes, I inserted "email" in the main word document, and the email address for each of the 25 persons were on the excel spreadsheet. The mail merge button did ask for email addresses in which i had to state in the box, the email address, the subject and then the format. I chose as an attachment. I have done this same process using access as my database and never did each recipient receive all letters. Is the process of doing mail merge using excel as a database different than using an access database. When I printed the letters, all were unique to the individaul. I had no way to know the would have a "tail" of 25 letters each, or could I? Thanks for such a speedy response! -- Thank you! "Doug Robbins - Word MVP" wrote: Your description of the way in which you did this does not seem to follow the procedure. How are the email addresses arranged in the data source? There should be one email address per record. Were you asked for the field that contains the email addresses? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "debilynn" wrote in message ... I sent a formated letter using mail merge to 25 people. All 25 people received 25 pages of each others letters, email addresses etc...I normally use access database to record information, however the information was sent to me via an existing excel worksheet. I inserted merge fields onto the master word document, checked correct amount of records and printed the leters. Then went into email merge button, was asked to state time for protection, and then sent the letters. Saying yes about 25 times. How could I have known that everyone received not only their own unique letter, but everyone elses too. Thank you! |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Text from Excel to Word | Microsoft Word Help | |||
| Using Access on Company Intranet | Microsoft Word Help | |||
| Problem in uploading database from excel | Microsoft Word Help | |||
| EXCEL file as a database for Word mail merge in XP. how do I do it | Mailmerge | |||
| Word 2003 Mail Merge from Excel spreadsheet database | Mailmerge | |||
Linear Mode
