Windows Support Forum

Mail Merge Word 2010 to email

Q: Mail Merge Word 2010 to email

Running Windows 7 machine with Office 2010 Professional. Just discovered that from Word I can send out mass emails (I am the email blaster for our organization) that show up in email as JUST addressed to the recipient without using bcc. Word 2010 BOMBS 75-90% of the time when I click on MAILINGS, Start Mail Merge, Email messages. If I do happen to get past there, when I click on Select Recipients Word bombs, then reboots. Very frustrating since each message I send out must be sent 3 times to get all of our people (more than 50 messages at a time are forbidden by my ISP).

Obviously Word and Outlook are both 2010.

Any fixes or suggestions are GREATLY appreciated!

https://forums.techguy.org/threads/mail-merge-word-2010-to-email.1027575/
Relevancy 100%
Preferred Solution: Mail Merge Word 2010 to email

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevancy 83.39%

I have recently upgraded to Office from and I perform a lot a mail merges I have come Word Outlook Merge Email - & Mail 2010 Issue across a few issues with this Email Mail Merge Issue - Word & Outlook 2010 feature within and wondered Email Mail Merge Issue - Word & Outlook 2010 if anyone has a solution I am obviously running Windows Issue - When performing the mail merge to emails HTML Word doesn t seem to recognise my IMAP email account which is set as default in Outlook it uses one of my other pop email accounts Is there any way to set my IMAP account as the default for mail merging Issue - Once I have completed the email merge I then need to create them as a PDF which in worked fine but the Acrobat addin in Word doesn t do anything I do have Acrobat prof installed as well I have done a little research and can see that this is a problem but I need a solution to fix Otherwise I ll be reduced to uninstalling and re-install Anyone with solutions please let me know nbsp

A:Email Mail Merge Issue - Word & Outlook 2010

Hi welcome to the forum,
Have you tried the macro to save As pdf file of print to the adobe pdf printer?
 

https://forums.techguy.org/threads/email-mail-merge-issue-word-outlook-2010.1021568/
Relevancy 101.91%

Hello I have a new issue that has come up since we converted an Access database to file format Here is the history We have an access database that was created in the old file format In that database there is a button that opens up word and a mail merge file Word s mail merge then uses a query from the access database to populate the mail merge merge mail 2010 Issues 2010 and data source a for a as Word with Access document We recently converted the Access database to the Office file format and now the merge process will not work I have tried to relink the files and have done some research and it appears that the DDE way of connecting is no longer used in Office I did finally get to the point where I could see the queries i needed but once I try to open that data source Word give me a general error that it can not open the data source How can I get these Issues with Word 2010 and Access 2010 as a data source for a mail merge merge files working again PS We are running Windows XP if that is needed We are quickly Issues with Word 2010 and Access 2010 as a data source for a mail merge moving to office also but that uses the same file format as so I assume it won t be Issues with Word 2010 and Access 2010 as a data source for a mail merge an issue Any help you can give me would be GREAT nbsp

https://forums.techguy.org/threads/issues-with-word-2010-and-access-2010-as-a-data-source-for-a-mail-merge.951212/
Relevancy 101.48%

I have a word document set up with fields that I want to create a mail merge from a Query. When I go through the steps to add my query as the source then click on edit recipients there are no recipients. I have tried the same steps with other queries that I have and it works. I'm not sure why the query I want to use isn't working. The query I have set up does have a lot of expressions. Here is an example IIf([fie dt] Between #8/1/2010# And #7/31/2011#,[fie dt]+1096,Null) I have tried to change the expression and it still doesn't work. Any ideas? Thanks!
 

Relevancy 99.33%

I'm using Word 2010 on a Win 7 machine. I'm having problems with mail merge in that when the merge is complete and I click on "OK" once the mail dialog has been completed, nothing happens. My e-mail client does not open up, nor do I see any messages in the outbox. This used to work just fine with Windows Live Mail and Word 2007. I then installed Word 2010 and it does not work now. Any suggestions from anybody? Any assistance would be MUCH appreciated. Microsoft is no help - impossible to contact.
 

A:Solved: Word 2010 e-mail Mail Merge Problem

Word and Outlook have to be same version.
 

https://forums.techguy.org/threads/solved-word-2010-e-mail-mail-merge-problem.941473/
Relevancy 98.9%

Hi I am just trying to learn how to mail merge with word 2010

I start Word then click on Mailings, then click on start mail merge, then click on envelopes, then select the size of envelope, then select recipients, and all works ok except the address block is almost at the bottom of the envelope no matter what setting I use.

I know I can grab this address block and move it anywhere.

But is there not a way to make the default position higher on the envelope please

Also I see using this method it prints the City County and post code on the same line

Is there a better way to select addresses and print without having to alter every ones position please

A:Mail merge with Word 2010

Have a look at these MS website to see if there is anything that helps you. In the second one which is applicable to Word 2007 there is a section on printing envelopes which may help you.

https://support.office.microsoft.com...rs=en-AU&ad=AU

https://support.office.microsoft.com...9-b462cc40c73a

http://www.sevenforums.com/microsoft-office/361088-mail-merge-word-2010-a.html
Relevancy 98.9%

I am working in Microsoft Office Word on a Bit Windows OS I am using Mail Merge I am trying to make it so that if Field is not blank that field will Merge Word 2010 Mail just populate Otherwise I need the system to look at the date the document is generated i e today s date If the date is to I need it to print quot DATE quot yy quot -CH- quot Otherwise - I need a prompt to pull up I have tried IF MERGEFIELD Field quot quot quot IF DATE quot Word 2010 Mail Merge MMdd quot lt quot quot quot FILLIN quot Case No quot o d quot -CH quot quot quot MERGEFIELD Field quot And as a test IF MERGEFIELD Field quot quot quot IF DATE quot yyyyMMdd quot lt quot quot quot FILLIN quot Case No quot o d quot -CH quot quot quot MERGEFIELD Field quot I am having no issues if Field is populated However if Field is blank nothing is pulling through with either of the above coding Now I am sure this is something I am doing but there are several instances where what prints will be based on a date Is it possible to do this without delving into Macros an area where I am completely clueless nbsp

A:Word 2010 Mail Merge

Update:

I found a little more information here: http://www.gmayor.com/formatting_word_fields.htm
Below is what the site has to say on the matter. It seems to agree with what I've done. I even tried to change my DATE field to a regular MERGEFIELD populated with a date and that did not work either. I do not understand what I am doing wrong here.
Testing for events that occur before or after a certain date

When running a mail merge, you may want to test for events that happen before or after a certain date. Mail merge does not convert dates to numbers, so if you cannot automatically derive a date number from the date in the data file, as you could in (say) Excel, a different plan is called for.
Let's say the date comes into Word in the format d/MM/yyyy or 1/10/2002 (1st October 2002) from a MERGEFIELD called Start_Date. In this example, we are looking to identify records with Start_Date entries before 1st October 2002.

The above would appear the logical check, but the check treats the date as a number and identifies that number as 1, which is the first part of the number before the slash '/'. All dates other than the first of the month will be greater than 1, so all will produce the result "False".
We therefore need to display the date in numbers that represent the date in a unique way by using the date mask yyyyMMdd which displays the date as a series of digits for year month and finally day, without any breaks. This is a number that the conditional field will view as a whole.

Thus any date before 1/10/2002 would produce "True" and any other date would produce "False"
 

https://forums.techguy.org/threads/word-2010-mail-merge.1056693/
Relevancy 97.61%

I just upgraded to Microsoft Office 2010 and when I try to use mail merge for Christmas card labels, I get clear down to the final formating and get an error message that says "not enough memory." This is very discouraging because of all the time and effort to download the addresses from Outlook. What gives with Word 2010? It seems to crash a lot, produce many "not responding" messages, and many of the windows within Word are funky and hard to read.

A:Word 2010 Mail Merge not working

Welcome
Lets not overlook the obvious, it may indeed be memory.
Bring up task scheduler to determine how much memory you actually do have.
Press alt+cntrl+delete and then click on performance tab to check remaining memory.
Crashes can, also, be caused by memory.

http://www.vistax64.com/software/285749-word-2010-mail-merge-not-working.html
Relevancy 97.61%

Microsoft no longer providing online forums for support as far as I can tell I'll ask merge Mail issue 2010 Word here because I can't think of anywhere else I have a Win Pro bit desktop running Office Professional Today I needed to do a mail merge letters and envelopes in Word This was the first time I ever tried that My data was in an Word 2010 Mail merge issue Excel spreadsheet The letters printed beautifully When I tried to print the envelopes the first thing it gave me was a little printer configuration window In the window I had to change the way the printer handles envelopes because my elderly HP Photosmart C printer doesn't handle them the way Word thinks envelopes should be handled Having changed that I clicked on the OK and immediately got this error In order to apply the selected envelope options Word must delete the current contents of lt filename gt Any unsaved changes to this document will be lost I couldn't get away from that so I clicked OK and my mail merge document vanished leaving only headers and footers There was nothing to print envelopes from I could not make it work Does anyone have a solution for this Has anyone ever seen it

A:Word 2010 Mail merge issue

Mail merge in Word can be a bit fiddly and the details keep changing between versions but it generally works - eventually.
 
The only suggestion I can think of is, when you come to the 'create new document' bit in the merge, you go into 'File - Page set-up' and set the template envelope to match the printer's settings rather than leaving it until you press 'Merge' or 'Print'.
 
Chris Cosgrove

http://www.bleepingcomputer.com/forums/t/570668/word-2010-mail-merge-issue/
Relevancy 96.75%

Hi all I m attempting to create a mail merge in with multiple records merging into a table on one page I ve tried a couple of options Use the quot Next Record quot rule This works in the first row but the merge reads left to right so when it gets to the next row Nightmare Mail Merge (Word Solved: 2010) it s screwed up I can t find a way to tell it to read down the column and then move to the next record instead of reading across the row Merge to a directory I can create a table with one column but when I merge to the directory it stacks Solved: Mail Merge Nightmare (Word 2010) the columns on top of each other There will only be three records for each page so even if I use a three column layout there s enough room to stack the columns Solved: Mail Merge Nightmare (Word 2010) instead of showing them side by side Also since there s so much other data on the page there s no good way to fit the merge to a directory information within it Anyone have any ideas I m attaching a sample document and the cells in yellow are the ones I need to merge Thanks nbsp

A:Solved: Mail Merge Nightmare (Word 2010)

Nevermind, I see what you are trying to do. I am not sure how you would approach this since it is not your typical mail merge.
 

https://forums.techguy.org/threads/solved-mail-merge-nightmare-word-2010.1043971/
Relevancy 96.32%

Oh dear! I created a mail merge in Word 2013 and chose the Edit Individual Documents option under Finish and Merge. I edited each and every email to personalize them. There was no option to email directly from that document, so I went back to the original email and sent them all. To my dismay, every person received an email including a [ ] in the space where I had entered their personalized information! Totally embarrassed. How can I email the edited documents??
 

https://forums.techguy.org/threads/using-email-mail-merge-in-word-2013-and-editing-each-email.1117313/
Relevancy 95.89%

Have just upgraded to Microsoft 2010, where before I could email mail merges from Outlook and choose my sender email address I cant now. Email mail merges have to be created and sent in word but it is defaulting to my pop email address and will not let me choose my imap address? my Imap is set to be the default
 

A:Email Mail Merge 2010 Problem with IMAP

Do you have the IMAP account showing in Outlook?
 

https://forums.techguy.org/threads/email-mail-merge-2010-problem-with-imap.1058645/
Relevancy 93.31%

I have windows 7 & office 2007. I am attempting to create an email merge. I have tried to do so starting with first with outlook (which takes me to word) which failed in sending, and then starting with word (which takes me to outlook and then back to word) and also failed in sending. I have followed all instructions to a T (as provided by help in both programs as well as microsoft help online).

What am I missing? Is there some connection between the 2 programs that needs to be set up first?

http://www.bleepingcomputer.com/forums/t/290939/cant-mail-merge-email-with-outlook-and-word-2007/
Relevancy 93.31%

Is it possible to create an e mail merge? It would be so helpful, but I haven't yet figured out how to do it.

Thanks
 

Relevancy 92.45%

Hi all,

I am trying to send multiple emails to different people with slightly different links to a survey page, so I can monitor who takes the survey (e.g. http://forums.techguy.org&c=90001, http://forums.techguy.org&c=90002....)
I have no trouble setting up Word to do a mail merge using an Excel file as the data source, and in the Excel file the links are all different and they are live.
However, when an email shows up on my pc, the link is dead - can't click on it to go to the survey, only can cut and paste into the browser, which I don't want to have happen to the client's customers.

(Edit) Note: I installed Microsoft's FixIt
http://support.microsoft.com/kb/823301
and continue to have the problem.
Any ideas? Thanks in advance!
 

Relevancy 83.42%

Hi I have set up 2010 issues/errors Merge Word data to a 2010 - query Access a new Access database saved as accdb copying tables forms and queries from my current one then deleting the old data Access 2010 - Merge a query to Word 2010 data issues/errors and modifying a lot of fields I have a query in with some simple calculations All the calculations work perfectly in Access When I merge this into Word set up as a letter document it doesn t use show the correct data The calculated fields in the query are number of people price tea amp coffee cost tea amp coffee and number of people price buffet cost buffet quot I then use these costs in the same query to work out VAT another calculated field adding up the calculated quot cost tea amp coffee quot and calculated quot cost buffet quot as well as a number of other non-calculated fields and multiplying the total by and Total Cost a calculated field adding up various non-calculated fields the calculated quot cost tea amp coffee quot calculated quot cost buffet quot and the calculated VAT field There are two errors in the data that ends up in the merged Word document The quot VAT quot doesn t add in the two calculated fields it only uses the data from non-calculated fields in the query Also the quot Total Cost quot doesn t add in any of the calculated fields teas amp coffees buffet and VAT it only uses non-calculated fields from the query It doesn t ping up any error messages Why is it changing the data between Access where the query works perfectly and Word It does the same errors when I have experimented merging the data into Excel when I set up a completely new Word document and also when I have set up a completely new query with the same calculations It all works perfectly in the current database also but started in a much older version saved as mdb and my current Word document again started in an old version now Word linked to the current database Any help gratefully received please keep it simple I can send screen shots if that helps nbsp

https://forums.techguy.org/threads/access-2010-merge-a-query-to-word-2010-data-issues-errors.1164245/
Relevancy 82.56%

i am mail merging word and excel database when i choose to send the messages as HTML all is good when i choose to send text or attachment - i get this security warning even after pressing quot allow + office attachments mail 2010 2010 merge exchange quot - nothing mail merge attachments office 2010 + exchange 2010 happens nothing no trace of messages in outbox mail merge attachments office 2010 + exchange 2010 and no mail sent i know that quot If you choose a format other than HTML an Outlook message may inform you that a program is trying to access e-mail addresses and send e-mail This message is a security measure designed to protect against viruses that replicate through e-mail To continue with the merge select the Allow access for check box in the security warning dialog box and then select the amount of time that you need to complete the merge Click Yes If you are prompted again continue to click Yes until the merge is complete quot thank you very much Tech Support Guy System Info Utility version OS Version Microsoft Windows Enterprise bit Processor Intel R Core TM CPU GHz x Family Model Stepping Processor Count RAM Mb Graphics Card NVIDIA Quadro FX SDI Mb Hard Drives C Total - MB Free - MB E Total - MB Free - MB Motherboard Dell Inc DN CN Antivirus Kaspersky Anti-Virus Updated and Enabled nbsp

https://forums.techguy.org/threads/mail-merge-attachments-office-2010-exchange-2010.994728/
Relevancy 78.69%

Windows XP Professional Service Pack 1 with office 2002 plus Outlook 2003 installed, Exchange 2003 is being used as the e-mail server.

When I do a mail merge from Word 2002 to e-mail for a mass e-mailing in Outlook 2003. The process completes but there are no e-mails sent from Outlook 2003. The e-mails that were merged are never recieved by the recipents that are being set to. Help.
 

https://forums.techguy.org/threads/mail-merge-from-word-2002-to-e-mail-for-a-mass-e-mailing-in-outlook-2003.293923/
Relevancy 78.26%

I would like to use Word 2007 Mail Merge to compose and send email messages. My email client is Windows Live Mail. I do not have Outlook. I do not need to access my WLM Contacts list. The email addresses I want to send messages to are in a column of the Word table that I am using as the Mail Merge data source. I have gone through all of the steps of a Mail Merge, including writing the email message, inserting data fields into it, and selecting recipients. The last step is to finish, merge, and send messages. I click on that step and nothing happens - no error message appears but no messages are sent. Any advice? It's possible this can't be done, but I am hoping it can.

--Jim--

http://www.techsupportforum.com/forums/f217/windows-live-mail-and-word-2007-mail-merge-445028.html
Relevancy 78.26%

Hi
I used Word 2007 for mail merge to send about 1000 mails to my prospects
After I click the Merge and Complete button, for every email it sends, outlook pops a warning
"Some program is trying to access to send email. If it is not ok, click deny and check your virus settings ..."

I am forced to click "Allow" for every mail, this is too much to take for the number of mails I am sending
Is there a way to disable this warning system when I am doing a mail merge

Kindly help

Thanks and regards
Sasi Sekar K
 

Relevancy 78.26%

Hi All,

I am trying to do an e-mail merge from a database that is saved on my hard drive.

According to the help files in WORD 2000, I should be able to do this, similar to sending form letters, only e-mail instead.

I can get everything set up and working, right up to the Merge dialog box, but all I have to select for Merge To, is 'New Document,' or 'Printer.' According to the WORD 2000 help files, there should be an option called 'Electronic Mail.' There is not, and I don't know why. I am apparently missing something, but I can't figure it out.

Any help or ideas will be appreciated. Any thoughts as to what else I may run into--difficulty wise--would be appreciated also.

Thank you.

Clayton
 

Relevancy 77.4%

I am trying to figure out how to use MS Publisher to generate a form that can be used for statement of assurance of time and effort.

My payroll program will generate a list but it's vertical.

Any suggestions as to how I can create a data file that will import?

I am attaching a sample of the Pub file I want to use and the list that my payroll program generates.

I have over 100 employees, so I am hoping I can do this.

Thanks for looking!

Carla
 

https://forums.techguy.org/threads/mail-merge-ms-publisher-2010.1145574/
Relevancy 77.4%

I'm trying to write individual letters to all members of congress with the salutation of "The Honorable" for each.
Can you show me if this is possible?
Thank You,
Gary Teresi
 

Relevancy 77.4%

I have email addresses stored for a Windows Mail Merge docx. and now want to use the email addresses for each entry.How can this email data be exported for use in Windows Live Mail as a Folder in my 'Contacts'?All assistance gratefully accepted in advance. Many thanks
Using OS: 64 bit MS7
 

Relevancy 77.4%

Can anyone advise me if there are limits anywhere to the number of e-mails I can send out simultaneously when using a mail merge to e-mail? I have set up and tested the mail merge and it all works fine, but I don't want to launch the real one only to get problems. I have a mailing list with 1,600 addresses, I'm using Outlook and Word 2011 for Mac to do this.
 

A:Mail merge to e-mail using Word / Outlook 2011 for Mac

One of the problems your going to face is getting labeled as a spammer. If your sending these internally it may not be a problem. The standard answer for this is to Outsource this if your sending over 100. Good decision not to launch the real one yet.

A detailed response to similar question in StackOverFlow
 

https://forums.techguy.org/threads/mail-merge-to-e-mail-using-word-outlook-2011-for-mac.1091069/
Relevancy 76.54%

I have an excel spreadsheet with data as below:
School Name Result
Applewood James AAB
Applewood John A*
Birkwood Mike AAC
Birkwood Sam BBC
Colins Jack CCD

I would like to merge them into a word document and send out letters to each school as follows:

Applewood School

The following pupils have achieved the grades below:
James AAB
John A*
Then on the next page another letter:
Birkwood School

The following pupils have achieved the grades below:
Mike AAC
Sam BBC

This is a very simplified version but you probably get the general idea. I know there is a tutorial online, but I cannot understand it. Please could someone explain it simply????
 

https://forums.techguy.org/threads/mail-merge-2010-2-items-or-more-on-letter.957334/
Relevancy 75.68%

I have two email accounts that I want to be able to switch between using outlook so that I can use one for general use and Mail Outlook - 2010 send won't Merge emails another for a mail merge When I run the mail merge Mail Merge won't send emails - Outlook 2010 microsoft word looks like it performs the merge correctly however no emails are sent to outlook I am Mail Merge won't send emails - Outlook 2010 using Word Outlook and Windows The email accounts are gmail accounts POP I was able to mail merge before I set up multiple accounts and I have been able to get multiple accounts to work on separate computers not with the same email address s though Unlike other people s problems sending emails through mail merge I am not able to send any emails out - not plain text nor HTML I have looked online and found a suggestion to run SCANPST EXE and it did not fix my problem I have also read online that this maybe an unknow bug or issue Does anyone know how to fix this problem Maybe there is something with office that my give clues to what may be wrong Any help would be greatly appreciated Mail Merge won't send emails - Outlook 2010 nbsp

https://forums.techguy.org/threads/mail-merge-wont-send-emails-outlook-2010.978970/
Relevancy 75.68%

I have Office 2010. I am trying to do a Mail Merge with 650 addresses on an envelope. All the fields merge fine except one. The field is Street Type (Dr, St, Ave, etc.). The field returns a value of time. 12:00:00 AM. The field settings on the excel spreadsheet are for Text.

There are no leading or trailing spaces in the field.

All other fields merge just fine and have the same settings.

Any advice?
 

Relevancy 75.25%

Hi,

I would like to set up a word mail merge the following:

If field OPTION1, OPTION2 and OPTION3 are al three empty, I would like to show the text "no options available" in any other case I would like to display these options.

I was thinking it would be something like this.
{IF<<OPTION1>>AND<<OPTION2>>AND<<OPTION3>>="" "No options available" <<OPTION1>><<OPTION2>><<OPTION3>>}

Unfortunately that doesn't work.
The problem is likely the AND selector. I haven't found any documentation of how to use AND selection in Word.

Any ideas? Help would be greatly appreciated.
 

Relevancy 75.25%

Hey Guys I have an end user who is needing to set up word mail merge She is drawing her list of recipients from our SQL server database She is needing to place up to nine names into a x word Merge 07 in Mail table with one name per cell Mail Merge in word 07 Our problem is Mail Merge in word 07 that some of the schools she is doing this for don t have nine people So not all nine cells are filled Now the problem this causes is that when one page doesn t fill all of the cells word starts grabbing names that are supposed to be on the next page school and using them to fill the partially filled chart This is a huge problem because each page is a different school with different Board members So I need to figure out a way to separate the charts so that each page s chart is filled according to the School name that is pulled from the database She is currently having to do a separate merge for each school we have different schools And it is an extreme hassle for her If you have any suggestions please let me know Also if you need me to clarify anything please send me a message Thanks nbsp

A:Mail Merge in word 07

Name Name Name
Name Name Name
Name Name Name

It's going to look similar to that, but there is going to be a chart surrounding it. and each Name is a different board member. however some schools dont have 9 board members, and word is currently pulling the names from the next school on the list in order to fill all 9 cells. How do i Prevent it for doing this without having to do a new mail merge for each school?
 

https://forums.techguy.org/threads/mail-merge-in-word-07.924977/
Relevancy 75.25%

I am currently using an older printer to merge 3.5" x 8.5" card stock from a FoxPro database. The older printer has a swinging door style manual feed and that's how I print the merge. I am interested in buying a newer printer, but most of them have small manual feed slots which only take one card at a time. I tried resizing the tray and changing the default paper source in Word and the printer settings, but the printer still wants the card from manual feed. Am I missing something? Thanks.
 

A:MS Word Mail Merge

swaters said:

I am currently using an older printer to merge 3.5" x 8.5" card stock from a FoxPro database. The older printer has a swinging door style manual feed and that's how I print the merge. I am interested in buying a newer printer, but most of them have small manual feed slots which only take one card at a time. I tried resizing the tray and changing the default paper source in Word and the printer settings, but the printer still wants the card from manual feed. Am I missing something? Thanks.Click to expand...

Just a little thing:
When creating mail merge, MSWord automatically puts option "Manual" in "Tray" (Don't ask me why!); change it to "Default Tray (Auto Select)". Only withdraw is that You'll have to create new main merge document.
 

https://forums.techguy.org/threads/ms-word-mail-merge.288633/
Relevancy 75.25%

i am trying to do a mail merge using the data in excel; i have done mail merge before and never had any problem until today ; but it's an odd problem tho; for some reason, word doesnt read the column for job title, and when i try to play around with the fields, it gives unpredictable and not logical result; i never had this problem before and dont know if anyone else has the same experience

the format should be

full name
job title
company
address 1, address 2
city, state zip

and for some reason it wouldnt pickup the job title field data, and when i try to put 2 job title fields , it omits the full name!!!,etc.... very weird
 

Relevancy 75.25%

I want to use a spreadsheet for the records in the merge. I would like to use one of the columns to specify how many times that particular record should be printed. Is that possible?

I also want a number on each document that auto-increments each time that document is printed.
 

https://forums.techguy.org/threads/need-mail-merge-help-in-word.421782/
Relevancy 75.25%

I m having some Merge Word Mail in Using trouble printing a mail merge document from Word Here are the details The document is formatted such that form letters can Using Mail Merge in Word fit on a single X piece of Using Mail Merge in Word paper each form letter is inches tall thus I want to print three on a single sheet of paper and will later cut it into thirds Each form letter has text and a graphic common to each letter thus a quot form quot letter and fields of unique data imported using the Mail Merge option on the TOOLS menu I am able to get the merge to occur however it results with a single form letter per page hence two-thirds of each printed page is wasted space If I delete the page-break that appears on Using Mail Merge in Word each page I am able to get all three form letters on a single page however I end up losing some of the formatting graphics Can anyone offer some suggestions of how to proceed Thanks nbsp

A:Using Mail Merge in Word

You must have the *doc* set up 3 times on the sheet. On the first you will have your first merge field.

On the 2nd, in FRONT of the first merge field, you must have a Word field "next record"

On the 3rd, same thing...

Suggestion: Right-click, Format picture and set text wrapping to INLINE WITH TEXT.

Hope this helps. If not, email data (change names if you like, and I only need four or five records) and merge doc as is to:

[email protected]
 

https://forums.techguy.org/threads/using-mail-merge-in-word.79227/
Relevancy 75.25%

What is the quickest way to create a mail merge in Word 97.
 

A:Word 97 Mail Merge

Some pointers:

I personally prefer using Excel as my data source (get data, change files of type to Excel). The mail merge helper will actually use a Word table as the data source (create data source) if you follow through the steps.

Regardless, your column headings in the data source need to be in row 1 and the first record of data must be in row 2.

Follow the steps in the mail merge helper. Generally, you'll use "active document" when prompted, except when performing the actual merge--use new document.

When you've put the codes into the letter, labels, etc., I suggest testing it (use the <<abc>> button on the mail merge toolbar), and then saving it as a template. Close it, hit file-new whenever you want to use that merged letter, label, etc.

Recognize that you're creating two files. The data source (put "data" into the name somewhere) and the coded file (put "merge" in the name somewhere).

Check here, if you can. 2000 and 97 are virtually the same when it comes to mail merge: http://support.microsoft.com/servicedesks/Webcasts/WC110200/wcblurb110200.asp?

Let me know if you run into problems or need more help.
 

https://forums.techguy.org/threads/word-97-mail-merge.51226/
Relevancy 75.25%

I develop an application that does mail merges with Word. It runs fine on Win2K and XP and with Office 97 up to 2003.

I am now running on Vista Business and Office 2K7. when I do a mail merge, I sometimes get an extra window like this:

Sometimes I can't even close this extra window. Any help appreciated!
 

Relevancy 75.25%

When performing a mail merge from Word 2000 to my Outlook 2000 contact list only the merge fields are sent. How do I insert pictures so they are viewed once the email is received?

Thank You

Littlebits
 

https://forums.techguy.org/threads/merge-to-email-from-word.746593/
Relevancy 75.25%

I have figured out how to do a Merge through word via email, but what I'd like to be able to do is have an attachment go with each of the emails in the merge.

Is there a way to do this? I can't seem to figure it out.

I want it to be an attachment instead of an additional page because this additional document is a form fill and if I insert it into the document it loses the form fill capabilities once the email is sent.

Thanks for any help you can offer.
 

A:Email Merge through Word

I've posted this question on a few sites but I'm not getting any responses at all

Can anybody help me?
 

https://forums.techguy.org/threads/email-merge-through-word.302414/
Relevancy 74.82%

Hi guys,

Sorry if this has been answered before, I did have a search.



I've just upgraded to Windows 7 and have installed Office 2010 which I also had on Vista, in Vista however my email *****@optusnet.com.au was part of personal folders, but now they are separate, I'd like not to see a separate menu for *****@optusnet.com.au but instead have all my emails under the Personal Folders menu, any ideas?

http://www.vistax64.com/software/292497-office-2010-how-merge-personal-folders-email-account.html
Relevancy 74.82%

Hi guys,

Sorry if this has been answered before, I did have a search.



I've just upgraded to Windows 7 and have installed Office 2010 which I also had on Vista, in Vista however my email *****@optusnet.com.au was part of personal folders, but now they are separate, I'd like not to see a separate menu for *****@optusnet.com.au but instead have all my emails under the Personal Folders menu, any ideas?

A:Outlook 2010 - How do you merge personal folders to an email account?

Hello MzTearyuz

See if this link is of help.
Combine POP3 accounts in Outlook 2010 | MSOutlook.info

FYI -
Where do I find?? | HowTo-Outlook

http://www.sevenforums.com/microsoft-office/185819-outlook-2010-how-do-you-merge-personal-folders-email-account.html
Relevancy 74.82%

I have a letter that I want to email out to a group of 50-100 clients but I want it to be personal with their name in the letter.
Is there a way to do a mail merge with a contact group from outlook and then email each letter for the individual person?
I know how to do a mail merge but that would be for printing and mailing.
I know I could take the time and email each letter individually but that would take a while.
I have Office Pro 2007

never mind i figured it out. The only tricky part was trying to add and attachment.
I had to save the file to my website and then provide a link to the document so they could open it.
 

https://forums.techguy.org/threads/mail-merge-and-then-email.648198/
Relevancy 74.39%

I'm unable to edit data sources in Word. It's stand alone (doesn't have MS Access installed).

When following through the usual process I press EDIT and all I get is the list of labels, not the Data Form that allows me to edit individuals details. It's as if it's been turned off!!

Hope I've explained this clearly enough!!!

Any ideas?

Thanks
 

https://forums.techguy.org/threads/word-2000-mail-merge.295940/
Relevancy 74.39%

I work for a management company, so we use Office 2003 (Basic Edition) for a whole bunch of stuff. My question has to do with the Mail Merge option in MS Word. I type all the leases for my company, so being able to use the Mail Merge would be awesome. I am not very computer literate, and was wondering if anyone knows a good site for a tutorial, or if they know how to use the Mail Merge option. Any help would be greatly appreciated. Thanks a lot.

A:Help With Word 2003 Mail Merge

Check the Microsoft Office website: Use mail merge for mass mailings and more.

http://www.bleepingcomputer.com/forums/t/40115/help-with-word-2003-mail-merge/
Relevancy 74.39%

If a person creates a main document using fields.Then merges with data and realizes that he needs to edit his document that has his fields. What's the best way to add a field or take away a space between the 2 fields after one has merged. Thanks!!
 

Relevancy 74.39%

Hi,

I have an access db that has .bmp files linked by SIS ID. I would like to merge the .bmp into a mail merge with Word 07.

I have never successfully been able to do this but thought I would try again. I have the word doc setup with a text box that I want the pic to merge into.

The SIS ID always shows up but not the .bmp.

Any ideas?

Thanks so much!
 

A:Access DB with .bmp/Mail Merge to Word 07

Can you post a copy of the Word Doc and a Bmp file?
I have never used mail merge in word, but I could try using VBA to do it.
 

https://forums.techguy.org/threads/access-db-with-bmp-mail-merge-to-word-07.751133/
Relevancy 74.39%

I am running MS Office 2003 and am trying to create a Word macro to open a main document with an attached data source, execute a merge and save the resulting document. I just get an error message: " Run time error 5852, Requester object is not available". I have been able to create a macro to execute a merge and save the resulting document on a main document that I open normally but not when opened by the macro itself. What am I doing wrong?
 

Relevancy 74.39%

One of my colleagues at Work has discovered that following an upgrade from Word 97 to Word XP, the Data Source fields within Mail Merge no longer show the field's contents in full. Instead only half of the sentence is visible in the right hand pane. Then, when she selects the source to add it to the document, it is still only showing half of it. This did not used to happen with Word 97.

Question:

Is there a way of increasing a fields character length, so that the full intended sentence or data to be merged shows up after adding it to the document ? If so please advise on how this can be done.

Many Thanks

Anton
 

A:Mail Merge Problem In Word XP

See if this article will help you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q292101
 

https://forums.techguy.org/threads/mail-merge-problem-in-word-xp.88290/
Relevancy 74.39%

Been having a problem with editing the recipient list in mail merge. When I go to save the edited list, I get one of two errors- a "read only" error if saving to a network drive, or a "insufficient permission" if saving to a local drive.

I've been able to duplicate this problem on multiple machines, with multiple files in both the .doc and docx. format. The data files are tables in Word, I have not tried duplicating the issue with Excel or Access datasources.

Of course, I have made sure the data files are not actually read only...

Thanks,

Michael
 

https://forums.techguy.org/threads/word-2007-mail-merge.741318/
Relevancy 74.39%

Using Windows 98, trying to do Excel to Word mail merge.
Workbook name
Main.xls
Worksheet names:
Board
CLEC_Affliates
ISP_Affliates
MCC

I have named cell ranges on each of the sheets, and would like to use that information selectively for a variety of mail merges in Word. When doing the merge though, my only choice for Data source, is entire spreadsheet...and my "named" ranges do not show up? Any advice...named ranges are named in following manner:
Board='Board'!$A1!Bx17 etc
Any help would be appreciated, please cc the email to
[email protected] as I will be working on this tonite at home too.
Thanks
Victoria
 

A:Excel/Word Mail Merge

Dear TSGF: No one ever answered my post, so I assume, as is always dangerous, that no one knew the answer. However, I figured it out even though it is not intuitively obvious from the MS standpoint! Here's the answer to my own question"

If you do not have Excel ODBC Drivers, Please install them in this way :

1) Click on Start --> Settings --> Control Panel

2) Select 'Data Sources (ODBC)' and press Enter key.

3) Goto 'System DSN' tab (3rd tab out of 7 tabs) in the "ODBC Data Source Administrator" dialog box.

4) Click on ADD.

5) Select 'Driver do Microsoft Excel (*.xls)' from select driver list box.

6) Click on Finish

Now you will see 'ODBC Microsoft Excel Setup' dialog box.

7) Type a name in 'Data Source Name' and click OK.

Now, Microsoft Excel ODBC Drivers are installed onto your system.

NOTE : You must install Excel ODBC Drivers prior to using mail merge facility.The Microsoft Excel ODBC driver must already be installed.

NOTE: In the Select Table dialog box, you will see all the tables in the workbook, not just the ones from the first sheet.

To connect to Excel using ODBC, follow these steps:

1) From the Get Data list, click Open Data Source.

2) Locate and select the Microsoft Excel file. In the Open Data Source dialog box, make sure that the Select Method check box is selected.

3) Click Open.

4) In the Confirm Data source dialog box, select "Excel Files via ODBC (*.xls)," and click OK.

5) In the Select Table dialog box, select a Named range from the list (the lists contains the available named ranges) and Click OK.

6) Edit the main document and continue with the merge process.
 

https://forums.techguy.org/threads/excel-word-mail-merge.46645/
Relevancy 74.39%

I have a list of records that will be merged from either an Excel worksheet or an Access database. The ID Number field repeats for multiple records but I would like the merged document to show the ID field once but list all records with that ID as on the same document page(s). When the ID number changes, then the next group of records are merged under that ID. Can this be done?
 

A:Mail Merge in Word 2003

No.
Sorry, but this is a huge shortcoming of Word.
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg
 

https://forums.techguy.org/threads/mail-merge-in-word-2003.379089/
Relevancy 74.39%

I'm trying to build a database to use just the labels option of the "mail merge" feature of WORD.
However, in my home edition of XP, I don't have excel. So, to create a database of companies, addresses and towns I was going to use a WORD table to become my database for mail merge to "draw" from.
When I went to create mailing labels from this document (a WORD table) I got an error message that says Microsoft Works does not recognize this database.

Also, I tried to enter each address singly to create a single label, when I went to adjust the column and row it would not let me, hence creating typed text over and over on the same mailing label(?). Help?

Can someone advise me on how to create approx. 300 different mailing labels.

Thank you very much,
 

A:Word/Mail merge/Windows XP

"Microsoft Works"??

What are you really using? Word or WORKS?

Use the TAB key to get to the next table cell in labels in Word, but not sure how to help if it turns out you're using Works.

Anyway, to answer your last question, let me know exactly what program we're running here and what version. See Help-About...
 

https://forums.techguy.org/threads/word-mail-merge-windows-xp.81414/
Relevancy 74.39%

We just upgraded (if you call it that) to Word 07 from 03 (which I loved). I am trying to do a merge into Word using an Excel spreadsheet saved as a CSV as my data. It seems that only half of the data merges into my document and there is no logical reason why. Any suggestions?

Thanks.
 

A:Word 07 Mail Merge issues

I would try copying the data to a new spreadsheet and see if the problem still occurs.

I have found that 2007 is very buggy, but quite good at resolving itself.

I am doing some searching to see if i can come up with anything else. I'll let you know if i come up across anything
 

https://forums.techguy.org/threads/word-07-mail-merge-issues.844047/
Relevancy 74.39%

Hello,

I am formating a letter through Microsoft Word 2007 using Mail Merge. This is the layout I am using:

«FirstName» «MiddleInitial» «LastName»«Comma»«Suffix»
«Company»
«Title»
«Address1» «Address2»
«Address3»
«City» «State_Abbr», «Postal_Code»

They all have Mergefield in the brackets with \b" " at the end of the bracket. The problem I am having is that a space appears in front of "FirstName" throwing off the alignment.

Is there a code or something I can put before to fix this??

Thank You!!!!!
 

A:Word 2007 Mail Merge Help

Welcome to the forum. I would check the FirstName field in your datasource to make sure you do not have a leading space within it. If so just delete them and you should be fine.
 

https://forums.techguy.org/threads/word-2007-mail-merge-help.832557/
Relevancy 74.39%

Hi folks

I'm doing a merge.

The address block is fine and I;ve used the <<company>> filed in the body copy of the letter to and that works fine.

I want to use another filed called <<Page>>. When I preview the merge, the <<Page>> field shows 0 rather than the field content which is "lower than page 4".

The data is in Excel.

Can anyone help please?

Thanks
 

Relevancy 74.39%

When using a mail merge documnet in word and using Outlook Contact as a database the merge fields do not all match, The state = city and the zip code = state. I have match fields and saved format but the same issue occurs in a new document
 

https://forums.techguy.org/threads/mail-merge-in-word-from-outlook.1079969/
Relevancy 74.39%

I'm using mail merge in Word 2003 on XP for a company holiday newsletter. It doesn't allow me to choose email merge--that option is disabled. (See picture.) Why? I can send individual emails without any trouble. I've also successfully used email merge in Word on another XP computer in the past.
 

A:Can't email merge in Word 2003

bump--any guesses?
 

https://forums.techguy.org/threads/cant-email-merge-in-word-2003.881848/
Relevancy 73.96%

I understand, and regularly use the email mail merge function in MS Office WORD 2007 - but am limited because I can't add an attachment - is there a simple solution to this problem?

Thanks

John
 

A:Email Mail Merge with an Attachment

There is no simple way, but it can be done. Here is what I did before. I first setup Outlook to work offline. I then did the mail merge and copy and pasted the file attachments from one email to another. After I get all the attachments pasted I then have the PC work online and hit send/receive to send them all out.
 

https://forums.techguy.org/threads/email-mail-merge-with-an-attachment.750408/
Relevancy 73.96%

Help please.

I'm attempting to create a form letter in Word 97 which I can mail merge to email. All well and good so far, but I also need to include an attachment in teh email (A PDF file). Word help seems to suggest that the INCLUDETEXT field is the anser, but I can only get this to insert the contents of the document into the email, not the document itself.

Any clues?

Michael.
 

Relevancy 73.53%

I’m using the Microsoft Word mail merge feature to merge data from a Microsoft Works database file onto labels. I’m able to do that successfully and now want to automate that process into a macro in Word. I recorded this process in a macro in Word but when I executed the macro, the mail merge process did not work. I went into the macro Visual Basic code and the only line generated was:

ActiveDocument.MailMerge.MainDocumentType = wdMailingLabels

There was no code generated that reflected the mail merge steps where I specified the database file that contains the data to merge and choosing the label form to use.
Any clues on why the macro did not record the steps needed to duplicate what I was able to successfully do manually?
 

A:Creating MS Word macro for mail merge

You can try this, but Works doesn't support VBA, so that could be why it won't work.

http://vbaexpress.com/kb/getarticle.php?kb_id=122
 

https://forums.techguy.org/threads/creating-ms-word-macro-for-mail-merge.400541/
Relevancy 73.53%

We have Word 2002 and excel 2002 applications we are trying to merge an excel file to Word and we are having problems getting getting the format correct. we have 4 decimal places on excel file, when we merge it to word it changes the format and puts a lot of zeroes on the file.
I also got this window message when we open the word file "Opening this Doc will run the following SQL on Select * From 'Sheet1$' Data from your...Base wil be placed in the Document. Do you wan to continue?"
We always click yes.
I looked at MS KB online the only thing I see is 97,98 older versions of Word and Excel. Has anybody experienced this problem already?
Please help. Thank you
 

Relevancy 73.53%

Hi All,

I have a Word document that pulls data from an Excel spreadsheet...everything was working fine in Word 2003, but we have changed the system and it has Office 2007 on it and the problem that I am getting is this box that pops up as soon as I open the Word document...

*****************************************************************

Microsoft Word

Opening this document will run the following SQL command....

Data from your database will be placed in the document. Do you want to continue?
*****************************************************************

I click "Yes", but that warning keeps popping up everytime I open the document? is there a setting in 2007 that I can set so it doesn't prompt me all the time? I have added the location of the documents in the "trusted zone", but not sure where else to look?

thanks!
 

A:Solved: Word 2007 and mail merge..

The reasons for the warning and the workaround to disable it (which is a security risk) are here:
http://support.microsoft.com/kb/825765
 

https://forums.techguy.org/threads/solved-word-2007-and-mail-merge.576546/
Relevancy 73.53%

Hey all,

Using Words Mail Merge with Excel as the source, however when i merge to new document, it merges into one long document, as I want to email out the merged letter separately, how can I make the merge to new documents rather than document?

Multiple letters ready to be saved separately for each merged letter.
 

https://forums.techguy.org/threads/excel-word-mail-merge-to-new-documents.571986/
Relevancy 73.53%

Is there away to make a button on a form that will merge the selected record with a word document print it and close the word document?

Thanks,

Jnar
 

A:Access Mail Merge with Word from button

Not unless you're (very) comfortable using VBA and automation. To make that happen at the click of a button, you have to have a pretty good mastery of coding.
 

https://forums.techguy.org/threads/access-mail-merge-with-word-from-button.75152/
Relevancy 73.53%

I completed a mail merge using 2003 & creating a list -- If I wanted to print just the list of names & address database associated with the merge letter -- how do I do that?? It looks to be a .mdb extention, but I can't seem to locate it on it's own!!

For the life of me, I can't figure it out! I think I preferred the old mail merge - when you had to create two seperate files! Seemed less confusing somehow!
 

A:Mail Merge (Word 2003) name list

A .mdb is an access file. Do a search and then use access to open it.

That should work out for you.
 

https://forums.techguy.org/threads/mail-merge-word-2003-name-list.574162/
Relevancy 73.53%

I am trying to do a mail merge for address labels in word 2003 on my xp. The steps seem to make sense, but it never works! I am ok up until the address block. All of the addresses don't appear. It just says address block or just the first address on my data source. Thanks for your help.
 

A:Mail merge in Word 2003-Windows XP

When you get to the point where you insert the address block. Are you clicking the Update All Labels button. That will update all the lables with the address block and you will see all your addresses.

If you are using the task pane to do the merge it is on step 5 I think.
Let me know if that helps
 

https://forums.techguy.org/threads/mail-merge-in-word-2003-windows-xp.304962/
Relevancy 73.53%

Hi I've just Word Merge? 2007 Office E-mail tried using Office Word email merge I've followed the tutorial for doing it step by step Use E-mail Messages Use The Current Document my email message is already types out in the open document Use An Existing List I already have an email list to send from and choose it Add my recipient information blocks I've done this Preview the message done this all is Office 2007 Word E-mail Merge? good Hit quot Electronic Mail quot a small options window opens to make sure the right fields are selected I've selected quot email message quot filled the subject line selected HTML and under quot Send Records quot I've selected quot All quot I hit quot OK quot this is suppose to be when the emails get sent but nothing happens Office 2007 Word E-mail Merge? At least I am not getting any of the emails that I've sent to my own email address Does anyone now why this might be I really like finally getting to mail merge I am looking forward to using quit frequently that is if I can figure it out Any help will be greatly appreciated HAPPY THANKSGIVING John

http://www.bleepingcomputer.com/forums/t/182249/office-2007-word-e-mail-merge/
Relevancy 73.53%

Despreate does not even desrcibe my state of mind right now!
I havent used mail merge many times before- I have my wedding invites that need to go out today! (The envolopes are 4.12 X 9.5... the invitation company left out it the fact that they wont fit in a standard printer) I need to print addresses on my envolpes and they wont fit in my printer! There has to be an option to change the printing/layout- right? What am I missing here? If I cant the envolpes to go in long way not width I would be all set... I just cant figure this out
Any expirences with this? Please... any thoughts much appreicated!

I have Windows XP, MS WORD 2003
My printer is a HP psc 2200
 

A:Help! MS Word Mail Merge & Printing Question

how about printing the addresses on labels then attach to the envelopes?
 

https://forums.techguy.org/threads/help-ms-word-mail-merge-printing-question.603246/
Relevancy 73.53%

Hi,
When trying to import an excel list into mail merge.
I get the errror "document locked for editing" and I cant continue. Does anyone know what is happening. Im not using it elsewhere and it used to work!

Thanking you for you help

Mikee
 

A:Solved: Word Mail Merge Problem

did you tried to do it in safe mode and checked.
try saving the excel file with a different name and then try mail merge
 

https://forums.techguy.org/threads/solved-word-mail-merge-problem.802037/
Relevancy 73.53%

I m trying to take data that I entered into an Access database and merge it into a Word document What I want it to do is that after the mergefield Word would read the merge field and spit out information from yet another source a word document and or excel spreadsheet So it goes like this Gift which would be like a camera in one circumstance or a TV in another would in the Word document post merge say camera or TV mail question merge Access/Word Now instead of saying Camera or TV what I would like it to be able to do would be to replace camera or TV with a specific other source of information i e if it is camera it would say in the merged document - quot Camera Nikon D quot or if it was a TV as gift one it would say quot TV Phillips XGs quot I hope that make sense to someone because I m wracking my brain trying to make it make sense to me Essentially I m stuck with having to pick things out of a page list and I want it to reference in Gift Gift Gift just what they are without having to hand do it I m also tired and have spent hours Access/Word mail merge question dinking with the set ask fillin if then commands I don t know where else to go nbsp

Relevancy 73.53%

I have an excel spreadsheet with names in one column and street and city address in another. I want to make a simple mail merge so I can make labels but I can not figure it out. Any ideas? I am using the mail merge wizard, but when I merge it is all blank.
 

A:Solved: Word and Excel Mail Merge

You merely have to name the Excel spreadsheet as the source of the data for the mailmerge (I think it is about the 3rd step) where you can select browse to use an existing list (MS calls it a database on this step, even though a spreadsheet isn't really a database).
Have you done all that?
Also, you might want to consider splitting the street and city into two separate columns, just to make it a bit more flexible in arranging your data.
 

https://forums.techguy.org/threads/solved-word-and-excel-mail-merge.843853/
Relevancy 73.53%

I am running an application that uses automated mail merge from access records called by a VB6 programme. It generally works fine on all versions of Word but periodically Word 2007 on an XP machine is not closing properly leaving the template open and therefore, next time one attempts to run the same mail merge one gets a 'document in use' message.

It is working fine in most environments - this particular PC did have both Word 2003 and 2007 loaded. We have removed 2003 but this doesn't seem to have solved the problem.

Any ideas anyone?
 

https://forums.techguy.org/threads/automated-mail-merge-with-word-2007.804067/
Relevancy 73.53%

Okay I ve been working on this all day and feel like I m trying to learn brain surgery Here is my situation I have an EXCEL worksheet name address city state zip as headings saved with records I go to WORD and open a new document Go MAIL gt Excel Merge Mail with Word 2007 Start Merge and choose quot Label quot and select my label Avery I then SELECT RECIPIENTS go to quot Existing User quot and find my worksheet and open it The first label is blank and the other labels have lt lt Next Record gt gt I then go to ADDRESS BLOCK and match my headings for the merge All of my records show up in the little preview box lt lt Address Block gt gt shows up in the first Excel 2007 Mail Merge with Word label I then highlight the whole label sheet clicking on the little corner icon in the top left corner and change the font to Arial Narrow point so the print will fit Upon hitting quot Preview Results quot I have the correct address showing in the first label space Now I go to UPDATE LABELS and Excel 2007 Mail Merge with Word the Excel 2007 Mail Merge with Word lt lt Address Block gt gt shows up in the and label and the and label for a total of five labels When I preview this is what I get pages of labels Page Record on the top row Record on the bottom row Page Record on the top Record on the bottom Page Record on the top Record on the bottom etc through page The rest of the labels are blank Any suggestions because you can stick a fork in me Thanks in advance Win Bit G Ram Dell PC G Video Card all soon to have dents Mark nbsp

A:Excel 2007 Mail Merge with Word

On the Microsoft forums, a semi-fix was posted for the same problem. Go through the Mail Label Wizard and when you get to "Step Four", press "F6" and tab to the "Update Labels" and hit enter (don't use the mouse to "enter". For some reason, that propagates all the labels.

However, for 85 records, it created 85 pages of labels.

Page 1 = Record 1-30;
Page 2 = Record 2-31, etc.

So I printed pages 1, 31, 60 and got my 85 labels.

Is any of this sound familiar to anyone?

Thanks.

Mark
 

https://forums.techguy.org/threads/excel-2007-mail-merge-with-word.944274/
Relevancy 73.53%

Maybe the Office 2002 gurus out there can direct me to a solution to this pesky problem...
When I try a mail merge to make mailing labels with Word 2002, I always use my Outlook contacts for the data.

However, Word always gives me an error message that says that Outlook is not configured as the defualt mail client. It instructs me to make the changes in Outlook and to try again.

I've been in Outlooks Tools menu, as the help files tell me, and have checked the settings, and made sure the box is checked to configure Outlook as the defualt email program, but Word behaves the same.

Any suggestion?

Thanks,
Ken C.
Chino Hills, CA
 

A:Problem getting Word to use Outlook for Mail Merge

Try this, go to contol panel, click on internet options and on the program tab set Outlook as the default email program.
 

https://forums.techguy.org/threads/problem-getting-word-to-use-outlook-for-mail-merge.101518/
Relevancy 73.53%

I was wondering if it is possible to do a merge where instead of outputting to a document where each record is on a seperate page, but rather, each record is it's own document.

For example, if I have 12 records in my database, I would like 12 documents after the merge. So instead of having one document with 12 pages, I'll end up with 12 documents with 1 page each.

The other alternative is to be able to save each page of a multipage document in a separate file for each page.

Any insight would be greatly appreciated!!!

Thanks!!!
 

A:Word 2000 Mail Merge Output

I am sure you could do it from Access alone and output the fields into a preformatted document that would create a new doc for each record.
 

https://forums.techguy.org/threads/word-2000-mail-merge-output.86917/
Relevancy 73.53%

I Access to Mail images Word from Merge have a Database in Access with a Picture field I merge information from this database to a word doc I want to start to merge the picture I thought this would be easy but I am struggling I have set up a new database with just fields to try different things but as yet no Mail Merge images to Word from Access success Below is an example of my merge attempt in work Name MERGEFIELD quot name quot Photo INCLUDEPICTURE quot D Photos MERGEFIELD quot photo quot jpg MERGEFORMAT d After seting this up I am clicking finish amp merge then Ctrl A then F But I am getting an image box with the error quot The linked image cannot be displayed The file may have been moved verify that the link points to the correct file and location quot Not sure if this is how you do it or where the link point comes from Access I presume Anyway I hope you can help and thank you for your time nbsp

A:Mail Merge images to Word from Access

In the access database there should be a url or image location property for the Picture field.

make sure it is properly pointing to the photo image location.

and when hardcoding the file path as in...

Photo[INCLUDEPICTURE"D:\\Photos\\{MERGEFIELD"photo"}.jpg\*MERGEFORMAT\d}

Be sure the two agree

cplmckenzie
 

https://forums.techguy.org/threads/mail-merge-images-to-word-from-access.1050870/
Relevancy 73.53%

Hya I have a database which I m planning on using as a source for a mailmerge in Word However when I open up the form in Word which reads the source amp lists the recipients it is always sorted in the order of the primary key quot Patient ID quot in this case rather than the Word mail in a Auto merge sorting field I have them sorted in on the database quot Overall Rank quot I need them listed in that way as the top patients going by quot overall rank quot are placed into my clinic more than patient can have the same quot rank quot so I can t use that as a primary key I ve tried using a macro but couldn t get it to work Is there anyway I can either get them listed Auto sorting a mail merge in Word in the order I wish automatically when I open Word or get Word to quot read quot the Source exactly in the order shown on the database Thanks Gogs nbsp

Relevancy 73.53%

I am using Office 2000 with Access 97. When I try to do
a mail merge with my access database I get the following message: You can't make changes to the database objects in the database "Golf & Tennis: 2002. This database was created in an earler version of. To convert this database to the current version of, close the database, point to database utilities on the tools menu,and then click convert database. I tried to do this but the convert to database option is grayed out. I have tried doing the mail merge on another machine with the same software, and database and there is no problem, so it is definitely a problem on my computer.
 

A:Access 97 w/word 2000 mail merge

What version do you NEED the Access database in? You may want to export your query to Excel first?
 

https://forums.techguy.org/threads/access-97-w-word-2000-mail-merge.103796/
Relevancy 73.53%

I have created a database for mail merge purposes in microsoft word

how can i print the database??

thanks
 

A:Printing Mail Merge Database in Word

jim, you should be able to hit File-Open, double-click My Data Sources under your My Documents folder, and it should be there. What did you name it?

What version of Office/Word do you have? And do you have the whole Office suite or just Word?
 

https://forums.techguy.org/threads/printing-mail-merge-database-in-word.108163/
Relevancy 73.53%

We are now on Office Pro 2007. We use Mail Merge in Word extensively, using our Access database as the source. We have 2 computers in the office.

When we open the mail merge document, it links to Access properly (we generally open the Access db first because it is quicker). We then merge to an individual record and save the merged document as *.docx.

When we re-open the document, it should be a normal Word document. Now what is happening is that when the merged document is created on MY computer, it opens the link to Access. When the merged document is created on THE OTHER computer, it opens as it should, without the link to Access.

Any ideas on what is going on???
 

A:Mail Merge - Word & Access 2007

I have never used Mail Merge, but it sounds as if on your Computer the merge data is being "Linked" instead of "Imported".
 

https://forums.techguy.org/threads/mail-merge-word-access-2007.821772/
Relevancy 73.53%

I set up a mail merge document in Word 2000 and then merge the results to a new document, then save the new document. I can open this new document fine. But, if I move the document to a different computer it won't open and crashes Word. Don't know why it does this as it shouldn't still be linked to the source mail merge database. It's just a completed mail-merged document.

Any ideas on this one? The only way it works is if the two computers are networked together, then it opens fine on the second computer, which suggests that it's looking for something on the orginal computer which it needs before opening the document on the second computer.

This has me baffled. Weird and frustrating.

If anyone would like a sample document I could attach one.

Thanks
 

https://forums.techguy.org/threads/word-2000-mail-merge-problem.333244/
Relevancy 73.53%

Wow I hope that title made sense I am supposed to do a project for someone She wants a BIZ Mail WORKS SPDSHEET WORD SML Merge & mailing database for her small business I am perhaps what you would call a beginner I ve had a little Mail Merge WORKS SPDSHEET & SML BIZ WORD exposure to various programs and was off and running with some tutorials coaching me through Mail Merge with MS Word and MS Excel In the interim things happened My computer crashed and I ended up having to buy some new software -- I have an OEM version of MS Office Small Business XP with Word coming to me in the mail -- and the second thing is that my client wants me to use the MS Works spreadsheet which is what she has in her computer rather than Excel So now I m thinking of going out and buying MS Works for another or whatever and using the MS Works spreadsheet with the Small Business Office Word She has Word but I think it came packaged with MS Office Suite So can I do what she wants of me by using the MS Word I ll be getting in the mail with the MS Works spreadsheet Is there any problem with that Please advise in whatever way you can Would much appreciate it By the way I now have Windows XP on a brand new computer nbsp

Relevancy 73.53%

I am trying to create an e-mail merge with a word document and data from an excel sheet. I used the Mail Merge wizard, everything seemed in place, previews were correct. I "finished" by putting in a subject name and hitting ok. The box closed, but no e-mails were sent. No error message. Any thoughts? I've tried several times.
 

https://forums.techguy.org/threads/e-mail-merge-word-excel-2007.1033931/
Relevancy 73.53%

Is it possible to include tabular data (with embedded tabs and carraige returns) in a mail merge document?

Thanks for any help you can lend.

Here's what I'd like to accomplish: In addition to name, addresss, etc. in a mail merge letter to people who have made donations to our organization, we want to include a list of contributions. The number of contributions per donor could be one or many, and for each contribution we want to have columns for date, amount, and category.

For example:

To: Donor #1
123 Main Street

Thank you for the following donations:

Date Amount Category
02/01/08 $50 membership
09/15/08 $100 scholarship
 

A:Word mail merge with an embedded table?

No.

This is called a compound merge or multiple-record merge. The best option is to either use Access and create reports from there, or have someone program it in Excel.
 

https://forums.techguy.org/threads/word-mail-merge-with-an-embedded-table.784122/
Relevancy 73.53%

I just installed Office Prof 2007. Word is working fine except when I try to start mail merge.
As soon as I use any of the menu choices, the program pauses and then shows that the program is not responding.
 

Relevancy 73.53%

I have a mail merge document with a date code. I merge to a new document and the new document contains the date codes. How can I set this up so the new document contains only the date, not the code, for the date that the merge is run?
 

Relevancy 73.53%

I have never completed a mail merge and cannot seem to eliminate the "mail merge helper" in the "tools" drop down. I now have 21 and growing. I have one that is used to establish a mail merge with the pointer on it but the rest are just hanging there with no pointer on them.
How do I ever get rid of them and get back to having only the one active mail merge, that came with word 2000, remaining?
I have searched the computer as best as I can and cannot find the source of any started mail merges and have read all of the help functions in an attempt to stop this mutipication of "mail merge helpers".
HELP!
Thank you in advance
Elaines
 

Relevancy 73.53%

Hi again guys Not being a database specialist can anyone help with an Access Word problem I have a database application which performs a query and outputs the result to Word for mail merging problem merge Word/Access mail The query works perfectly and gets the results I would expect Word opens correctly Word/Access mail merge problem on request from Access The Word merge document is a simple test case so should have no faults in it The data is passed across as a txt file and can be seen saved where it should be and correctly formatted by simple inspection in Notepad However Word cannot recognise this txt file as its database for the merge procedure and point blank refuses to let me merge The txt file has its first line as the data fieldnames and then has tab delimited fields and quot End of Line quot delimited records after It seems to me as if the problem is within Word rather than Access but I am no expert Is there some simple Word option I have set incorrectly or is it something within Access after all Any suggestions appreciated nbsp

A:Word/Access mail merge problem

What version of office are you using first of all?

Also, there are two ways to merge access/Word. One way is from Word and one way is from access. I'm assuming from your description that you are merging from Access.

This is where you kind of lost me. I've done thousands both ways, but I've never seen anything about the data saved as text fields.

You might try starting over. If you are merging from Access:
Open the query you want to use.
On the toolbar choose Tools, office links, then merge with word.
A dialogue box will pop up and ask you if it new or existing document. Choose the correct one.
When the document opens, it will prompt you for more responses. However, at this point the mail merge options and appearances are different on different versions of office.
Good luck!!!
 

https://forums.techguy.org/threads/word-access-mail-merge-problem.155777/
Relevancy 73.53%

I am working for assistance with using the IF statement in a mail merge in Word.

What I am trying to get my mail merge to do is the following:

Excel Spreadsheet
Ex. 1 Name _1 = Tony Name_2 = Christopher Name_3 = Alex Name_4 = "" Name_5 = "" Name_6 = ""
Ex. 2 Name_1 = Samantha Name_2 = Selena Name_3 = "" Name_4 = "" Name_5 = "" Name_6 = ""

Mail Merge Text

This agreement is made this «Day» day of «Month», «Year» , between (new code here)

Would like for it to read: between Tony, Christopher and Alex ~ for example 1
Would like for it to read: between Samantha and Selena ~ for example 2

Any ideas, would be greatly appreciated

 

A:Helped Needed IF and AND Word Mail Merge

Forgot to mention that I am using Microsoft Excel Professional 2010
 

https://forums.techguy.org/threads/helped-needed-if-and-and-word-mail-merge.1045183/
Relevancy 73.53%

I have been working on this for hours I have a simple voucher per Word Skipping Microsoft Mail Merge page that each requires its own unique code The voucher is in JPEG format so I copied and pasted it into a word document Then I created a text box for where the code will go I have the Microsoft Word Mail Merge Skipping list of codes in a seperate excell document Now I created a directory mail merge list and once I merged it show up vouchers to a page great BUT only Microsoft Word Mail Merge Skipping the first voucher had a code At first I thought it was only giving me every fifth record because every th code was in the first voucher at the top of the page Then I found out the text boxes were stacked on top of eachother in the first voucher s place There are thousands of these codes so I can t go through and manually move all of the text boxes PLEASE HELP I have no idea what I m doing nbsp

https://forums.techguy.org/threads/microsoft-word-mail-merge-skipping.997630/
Relevancy 73.53%

Hi

We have just moved from Word 2003 to Word 2007 and I am having a slight problem with mail merge. Whereas with 2003 when selecting the source data (Excel 2003) I was able to bring it in as DDE, now the only option I have when bring in the data (Excel 2007) is to select OLE Database file. Whilst this does work, the merged fields especially currency amounts, do not retain their formatting, but when I used to bring them in as DDE they did. I know I can go in and amend the field codes to put it back, but I would rather not have to.

Is there some setting somewhere I need to change to get the DDE option back?

Thanks for your help

Peter
UK